CMP problem occurred in characteristic of Multi provider

[Former Member]

Dear Experts,

I'm facing Compounding problem as an warning message while activating Multiprovider.

My scenario is... Actual cube was present in MultiProvider and i created a History cube which is a copy of Actual cube and i added the History cube also into same multiprovider and compounded the Characteristics as same as Actual Cube...while activating I'm getting warning Message as "Compounding problem occurred in characteristic" ...and then i cross checked the Characteristics assignment also and it's correct.

Request you to let me know how to overcome this...

Thanks in advance,

Ramesh-Kumar.

[Former Member · Accepted solution]

Hi Ramesh ,

Suppose you have two cubes in the MP : CUBE1 & CUBE 2.

Cube 1 has X and Y.

Cube 2 has X .

This warning comes due to Compounding Attribute. X infoobject is a compounding attribute of Y i.e X is a "parent characteristic" for Y . Now Cube 2 does not have Y infoobject . So in the identification of the multiprovider Y will only come from cube 1.

The above kind of situation leads to CMP probelm in multiprovider .

You can remove this warning by including Y in Cube2 . You can include Y in cube2 without any mappings for Y .

This CMP problem cause Query performance issues . For more help on this, please click on the help button on the message when you see this message . A good detailed explanation is given there with the note number also ( 1038604 ).

In addition to this you can check the note numbers : 702542 , 1045683.

Hope the above reply was helpful.

Thanks & Regards,

Ashutosh Singh

[Former Member · Accepted solution]

Thanks a lot for favorable information