Re: Need Help Connecting and extracting data from Info Cube
You will need to load all of the following tables for a cube (these can be found by using the function ListSchema in SAP BW)
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
The template for SAP cube building is doing this automatically in the script
Need Help Connecting and extracting data from Info Cube
Thanks a lot Sunil,
I really appreciate your help. It has been great since I am working on this for the first time.
Sunil, it would be really great if you can clarify me one more thing..
I can connect Fact table (Transaction) with Master data in two ways..
One through SID_ field directly linked with Master data. Secondly through DIM tables.
But problem, that I see here, is if I Unqualify SID then there is no need for DIM tables, but if I Unqualify.. KEY (After changing DIM to KEY_cube nameU etc), that would not link it with Masterdata. If I qualify both it would create Circular relationship again..