Skip to Content
author's profile photo Former Member
Former Member

CMP problem occurred in characteristic of Multi provider

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2011 at 12:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.