Skip to Content
avatar image
Former Member

dimension table and fact table exists data physically

Hi experts,

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Feb 04, 2010 at 04:38 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Feb 04, 2010 at 04:07 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2010 at 04:17 AM

    Hi,

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

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

    Regards,

    Sunith

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2010 at 06:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2010 at 11:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded