Why do dimension tables contain data?

[Former Member]

Hi there,

as far as I understodd the BW datamodel, the dimensions are to summon characteristics that do belong to the specific view I want to access via my InfoCube. So, the dimensional tables should contain just the mapping between DimIDs and SID, shouldn't they? What else do these dimensional tables contain??

Thanks,

Pascal

[Former Member]

Hi Pascal,

The Dimension tables only have relationship b/w the Dim IDs and SIDs. They don't store any other information

Regards,

Sree

[Former Member]

Hi,

I think the concept of using dimension table as the intermediate to SID And Facttable is to develope <i>extended star schema</i>. So that it allowing more than 13 characterstics in infocube.

With rgds,

Anil Kumar Sharma .P