cancel
Showing results for 
Search instead for 
Did you mean: 

hi sap gurus I have few questions

Former Member
0 Kudos

1. Which table do we store the characteristics in sap bw extended star schema

2. how does dimension-sid tables and sid-master data tables joined

with wht keys (sid id,dim id or characteristics)

3. Is it possible to have characteristics have no masterdata

4. what is dimension attribute and describied attribute in star schema

Thnks

manan

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

thanks k.madhavi and sunil

Former Member
0 Kudos

Hi Manan,

Welcome to SDN,

Just go through the Doc. and you can get answers to all the questions listed.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6ce7b0a4-0b01-0010-52ac-a6e813c3...

cheers

Sunil

Former Member
0 Kudos

Hi,

In order understand these questions u should be clear with BW star schema

1.We store characteristics in master data tables

2.for earch and every dimid system will generate a sid in the sid table which is uniquely identified by system through this sid concept it links up dimid with master data table.

3.yes it is possible to have characteristics with no master data.(EG line item dimension)

4.dimension attribute is nothing but the characteristics infoobject,

but i am not sure about described attribute as i've not heard of it.

Regards

Madhavi