Question about the dimensions of a multiprovider

[former_member636500]

Hi all,

I need to create a multiprovider based on 2 infocubes. They have 22 dimensions altogether, without taking the default ones in account.

I'm able to group 6 dimensions into 2 because they have characteristics in common, but after this action there will still be 16 dimensions.

My question is: is there any problem in putting unrelated dimensions together? Would there be some problem related to the multiprovider design?

Thanks and regards,

Tiago.

[Former Member · Accepted solution]

HI,

This mainly depends on the reporting requirements you have. If you want to do better on the reporting performance since the requirement is on the two cube with more number of characteristics. While design the cube take only those char which are useful for reporting. Group the char in dimension as per the reportign requirements like the two char collectively used in a query can be used in one dimension.

http://help.sap.com/saphelp_nw70/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/cf/bc734190ba137de10000000a155106/frameset.htm

Tarak

[former_member636500 · Accepted solution]

Hi Mayank, Tarak.

The links have been very useful and my questions are now clarified and solved.

Thanks and regards,

Tiago

[Former Member]

Check the below thread:

You can search for more threads.