cancel
Showing results for 
Search instead for 
Did you mean: 

Multiprovider - char differents betwen the cubes

Former Member
0 Kudos

Hello, I´am new here and I need your help experts!

I have a multiprovider with a SD_C03 (Sales) and SD_C16 (Conditions), and the only char in common is Sold_to.

I made a query and I saw that if I put the char Sold_to in the line, all the results (key figures) are displayed okay, but if I put in the line a char that exists only in one cube (for example 0REGION), so the results are incorrectly...(The total result of the report is repeated in each line)

I need to compare characteristics that only exist in a cube versus te other, for example: discount practiced for region.

Where the index (key figure)discount this only in cube SD_C16, e the region in cube SD_C03, however both possess the Sold_to in common.

What can I do?

Thanks a lot,

Samira Saverio

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

Please Can Anyone help me?

Thank´s a Lot

Samira

Former Member
0 Kudos

Hello Samira,

To get the correct results from the multi-provider, you need to use the same characteristics from each InfoCube.

See this link from the SAP Help... http://help.sap.com/saphelp_nw04/helpdata/en/52/1ddc37a3f57a07e10000009b38f889/content.htm.

One option may be to set the 0REGION as an attribute of the sold-to (if the sold-to only exists for a single region). If the 0REGION is not unique by sold-to, another possibility is to customise the 0SD_C16 to add the region.

Hope this helps,

Best regards,

Pat M.

Former Member
0 Kudos

Hi,

could u tell what do u mean when u say when u put sold-to in line ?

Former Member
0 Kudos

Hi,

I mean Drilldown the characteristic Sold-to party...

Ok?

Tk´s

Samira