dimension table and fact table exists data physically

[Former Member]

Hi experts,

can anyone plz tell me weather dimension table and fact table exists data physically or not/

[former_member181964 · Accepted solution]

Hi,

Yes Physically data is tehre but it is in Code formate, not actuall data, that is the differnece between ECC table and BW Cube. Bcoz BW follows Extended Star Schema, so that data will store in differner locations, i,.e. Mater Data, Dimensional Data and Fact Data using the keys like SID and DIM ID relations.

You can see it in SE11. Goto SE11 and give Table = Star0IC_C03Star and press F4, it will display all tables related to the cube 0IC_C03

/BI0/D0IC_C031                 Location
/BI0/D0IC_C032                 Material
/BI0/D0IC_C033                 Batch
/BI0/D0IC_C034                 Stock Type
/BI0/D0IC_C035                 Supplier
/BI0/D0IC_C036                 Flag
/BI0/D0IC_C037                 Movement Type
/BI0/D0IC_C038                 Indicator
/BI0/D0IC_C03P                 Data Package
/BI0/D0IC_C03T                 Time
/BI0/D0IC_C03U                 Unit
/BI0/E0IC_C03                  Material Stocks/Movements (as of 3.0B)
/BI0/F0IC_C03                  Material Stocks/Movements (as of 3.0B)
/BI0/L0IC_C03                  Material Stocks/Movements (as of 3.0B)
/BI0/V0IC_C03F                 FACTVIEW - INFOCUBE 0IC_C03

Where:

D = Dimensional Table

F = F Fact Table

E = E Fact Table

U = Units

T = Time

P = Package

etc..

Thanks

Reddy

Edited by: Surendra Reddy on Feb 4, 2010 5:38 AM

[Former Member · Accepted solution]

Thanks for the answer

so where can i see data in fact table is this transaction we use LISTCUBE to see data in fact table

Thanks in advance

[Former Member · Accepted solution]

Hi ,

LISTCUBE(TCODE) or the infocube contents disply the data of the cube i.e complete data after combining a true picture of Fact ,Dimension and SID tables.

Fact table structure would be like DIM Id's along with Key Figures

DIM ID1 DIMID2 DIMID 3 KF1 KF2 KF3

If you want to see the data in fact table alone go to SE16-->ENTER the table name as /BIC/F<Infocube name>.

-Vikram

[Former Member]

Hi..Sudheer

SAPu2019s BW is based on "Enhanced Star schema" or "Info Cubes" database design.This database design has a central database table, known as u2018Fact Tableu2019 which is surrounded by associated dimension tables.

Fact table is surrounded by dimensional tables. Fact table is usually very large, that means it contains

millions to billions of records.

These dimension tables doesn't contain data it contain references to the pointer tables that point to the master data tables which in turn contain Master data objects such as customer, material and destination country stored in BW as Info objects. An InfoObjects can contain single field definitions such as transaction data or complex Customer Master Data that hold attributes, hierarchy and customer texts that are stored in their own tables.

SID is surrogate ID generated by the system. The SID tables are created when we create a master data IO. In SAP BW star schema, the distinction is made between two self contained areas: Infocube & master data tables/SID tables.

The master data doesn't reside in the satr schema but resides in separate tables which are shared across all the star schemas in SAP BW. A numer ID is generated which connects the dimension tables of the infocube to that of the master data tables.

The dimension tables contain the dim ID and SID of a particular IO. Using this SID the attributes and texts of an master data Io is accessed.

The SID table is connected to the associated master data tables via teh char key.

Fact table(Transaction data,DIM ID)<>Dimention Table(SID and Dim ID)<->Masterdata table(SID,IO)

Thanks,

Abha

[former_member354103]

Thanks for update and information is very helpful for me.

[Former Member]

You can see the names of tables of infocube by double-clicking on it, then goto ->Extras->Information (log/status)->Dictionary/DB status, then check them in se11

[former_member378735]

Hi,

Yes the data exists physically in SID/DIM ID format.

Check the tables /BIC/D* or /BIC/F* tables.

Regards,

Sunith

[Former Member]

yes they do .. you can find the tables associated with a cube in Tcode LISTSCHEMA.