Skip to Content
author's profile photo
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 comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    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 comment
    10|10000 characters needed characters exceeded