BW on HANA: Working of In-Memory Info Cube
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 🙂