When you create Dimentions, How do you decide which characteristics go!

[Former Member]

Hi,

I am New to SAP world, I appreciate if someone could explain:

at the time when you create Dimentions, how do you decide which characteristics go under which dimention?

Thanks: Vani

[Former Member]

http://kimballgroup.com/html/designtipsPDF/KimballDT53Dimension.pdf

http://kimballgroup.com/html/designtips.html

Check out these links..for details..

The basic idea while deciding which characteristics go to which dimension is that the size of the dimension table ideally should not exceed 10-20 % of the fact table..

Hope it helps..

Let me know if you need further clarifications..

Ashish..

[Former Member]

Try a search on SAP Business Intelligence forums on Data Modeling, you'll get lots of hits.

SAP Press also has a brand new book out - SAP BW Data Modeling

Haven't read it, but I imagine it does a good job on the dimension issue.

Message was edited by: Pizzaman

I would try a search on SDN as well. Seems to me there is a How To on Data Modeling floating around somewhere out there.

Also Google Ralph Kimball and Data Modeling.