Doubt on star schema..

[Former Member]

Hi all ,

I have a smaal doubt on Extended star schema . Like Dimension table stores only the Dim ids and corresponding SIDs and through this SID values these are linked to SID table which contains the SID for a master data . My doubt is where is our characteristics value for dimension tables . Like if one doimension if we have Employee name , college are the dimension and its master data let us assume is Employee code. CAn somebody explain me the scenario..

Thanks in advance..

[Former Member]

Hi, Iam clear with the joining , but where are the values like employee name etc. are stored as dim. table only contains DIM id and SID . And SID table only contain SID and corresponding master data values .

[Former Member]

Niyati,

To find the employee name, check the sid value, i.e :-

/BI0/SEMPLOYEE

Which will give you the employee number

Put this in :-

/BI0/TEMPLOYEE

and you will succeed.

Cheers,

Pom

[Former Member]

If you are clear with the join, what is your doubt? master data values are in master data tables and are joined to cubes via join.

cube fact table, dim id -> dim id, sid master data -> sid master data, master data key -> master data key, master data attributes.

[Former Member]

The SID table is used to connect to various Attribute MD data tables and a Text table.

Try searching for some tables that begin with /BI0/X, /BI0/Y to get an idea of where the master data is stored.

The BI Dveloper area on SDN has a good documents that details the star schema. If you are familiar with SQL, reviewing the BW generated SQL query would help.

[former_member619464]

Hi,

This doc may help u & give u a clear idea

http://help.sap.com/bp_biv235/bi_en/documentation/Multi-dimensional_modeling_EN.doc

Regards,

R.Ravi

[Former Member]

the SID for a master data is linked to the value of characteristic, the you obtain the value through join between dimension - sid table - master data table