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:
Best Regards,
Peter