Hi Gurus,
I discovered that in one development project, one star schema with its dimensions has a dimension "organisational units".
In this dimension are all units put together and those units are also in the InfoCube.
That means in one dimension is available:
Company code
Credit control area
Customer number
Profit Center
Business unit
Business segment
Sales organisation
Sales division
Distribution channel
Does this make sense?
I mean will the system allow to make correct selections/drill downs etc. with those adjustments?
As the development is still in progess I would make a suggestion to partition the dimension "organisational units" into following dimensions:
Company code
Credit control area
Company code
Customer
Customer number
Profit Center
Profit center
Business segment
Business unit
Sales organisation
Sales organisation
Distribution channel
Sales division
I think this would make more sense ...
Correct?
Thanks in advance!