cancel
Showing results for 
Search instead for 
Did you mean: 

Table for storing contents of a Infocube

Former Member
0 Kudos

Hi,

We are building a report with data fetch from a Info cube. I need information on how to find a database table name which stores the content of a Info cube.

Request to provide valuable inputs.

regards,

Mohit

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Mohit

Best option to create data source based on the respective infocube, Once you have data source you can extract the data using functional modules or using standard BI techniques. Info cube follows different technical architecture then ODS where data get stored in one table only.

You can go to SE16 and search like /BIC/*cube name*. You will get the tables with all the dimensions.

as an example for demo Cube 0D_DECU:

Fact Table /BI0/F0D_DECU

and Dim Tables: /BI0/D0D_DECUT,/BI0/D0D_DECUP,/BI0/D0D_DECUU,/BI0/D0D_DECU1 etc

in this example the /BI0/D0D_DECU1 Dim table is the link between the fact and the Organisation master and SID tables link as follows:

Fact Table - KEY_0D_DECU1 to Dim table DIMID with an inner join load in QlikView to give you a single table with all the fact data and linked DIMID's, also rename DIMID in the join to KEY_0D_DECU1 to avoid loops.

Next the master data is linked with the S,M and T tables

The Dim table contains fields starting with SID_ this is the key to link to the S tables for the master data. In the S tables the key field is called SID so you need to rename this to match the SID column in the Dim table

from here you can also link M and T tables

Please let me us know if this information helps you.

Thanks

Amol