Skip to Content
0
Former Member
Nov 26, 2006 at 09:35 PM

InfoCube Design

59 Views

Hello all!

What are the rules for designing a good InfoCube? For example, I have the problem to design a InfoCube for some InfoSouces as follows:

0CO_OM_WBS_1

0CO_OM_WBS_6

0CO_OM_OPA_1

0CO_OM_OPA_6

For each one InfoCube.

How do I know in which dimension I should put which InfoObjects and which not?

I had seen that sometimes dimensions are designed after business topics like order, customer and so on. As I understand, this is not good because of possible n:m-relations and that they pump up the volume of my data due to redundance. I am right so far?

So I should look for n:m-relations and just put 1:n-relations in a dimension? I have to check this for every attribute in a dimension?

Is there a good method to do this or just over understanding of all the attributes?

If you want, see also the following link to my other thread for context of this topic:

Design of data-flow

Best Regards,

Peter