primary key in fact/Dimention/SID table?

[Former Member]

Hello sap gurus,

2 Questions....

Which is primary key in

-Fact table (probably answer is .... combination of DIM_ID keys)

-Dimention table ( probably answer is .... DIM_ID key)

-SID table ( probably answer is .... SID_ID key)

Thnx in advance

[Former Member]

Gaurav,

You already have the answers. A very simple way to figure out the keys is to use the transaction LISTSCHEMA, it will list the tables in an Infocube. Once you have the tables , you can use se11/se12 to check the keys.

For ODS information in BI 7, check the link below.

http://help.sap.com/saphelp_nw70/helpdata/en/80/1a60cae07211d2acb80000e829fbfe/frameset.htm

For ODS information in BW 3.5 , check the link below

http://help.sap.com/saphelp_nw04/helpdata/en/c0/99663b3e916a78e10000000a11402f/frameset.htm

-Saket

[Former Member]

Hi Saket,

Thx for replying....ok i checked it...one correction...

I think SID table .... Key is characteristic ID (ex . CUST_ID)

I checked SE11....

correct me if i m wrong

thnx