on 08-11-2015 6:50 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
12 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.