Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
Former Member

Hello SCN,

In this blog, we will discuss about the structural changes of In-Memory Cube when compared with Standard Info Cube and also discuss about different advantages and limitations of using In-Memory technology with Cube. This blog is in continuation with my previous blog: *BW on HANA: Working of In-Memory DSO (BW on HANA: Working of In-Memory DSO)

Let us now discuss about existing schema of Info cube:

Extended Star Schema of Standard Info Cube:


For detailed understanding of extended star schema, please read my wiki: Extended Star Schema

How Does In Memory Cube look like?

As we have an additional boost of HANA computation power. Dimension tables are removed and Master Data tables are directly linked with F table.

There is no more E table. You can see the structure of In-Memory Cube below:

How does a Fact table of In Memory look like?

The fact table (F) no longer contains Dim Id (Except packet dim id). We can now see SID's in Fact table as shown below:

Dictionary of Standard Info Cube Tables:

Example: We can see in SE11:Or we can use the Report "RSDRI_CONVERT_CUBE_TO_INMEMORY”.
What does this conversion do?

Thank you for reading this blog :smile:

20 Comments
Labels in this area