Skip to Content
0
Former Member
Dec 05, 2011 at 08:31 AM

Organizing dimensions for organisational units

25 Views

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!