Modeling: how to make the LOCATION for Material Group as in ii (below)?

Hi,

I just completed a review of the "...Modeling with BI" document and I will appreciate some clarification on the following:

Some key points leading to question:

--"..In order to cover all requirements, master tables in a BI Data model are NOT linked directly to cube .."

e.g. While Material Number is in the Material Dimension; Material Type and Material Group are outside the Star Schema (page 14) i.e. in the Material Master, Material Text, Material Hierarchy TABLES.

--".. translation tables called SID tables are used in the BI data model to link the master tables of the BI data model to cubes" (page 16)

--So, the discussion goes on to point to the different LOCATIONS that a dependent attribute (which are not in 1:N relationships) of a characteristic such as Material Group may be located:

in the

i) Material Dimension table or

ii) Material Master table or

iii) Material Hierarchy table or

iv) combination of i/ii/iii

My question:

When building a cube, I know how to add Material Group to the same dimension as in case of i.

How do I add Material Group in the cube, in such as way that it is ii?

If I created a separated InfoObject, Material Group, it will not meet ii, since it will not be part of the Cube in question.

Can you help me with how to make the LOCATION for Material Group as ii and iii in this example?

i.e. to make Material Group as part of the model but not added to the Material Dimention table but to "Material Master table"

i.e. I am trying to get this line well:

--".. translation tables called SID tables are used in the BI data model to link the master tables of the BI data model to cubes"

Thanks

Edited by: Amanda Baah on Jan 27, 2009 12:32 PM