can we add new cubes and ODS after creating the multiprovider?

[Former Member]

Hi all,

i created a multiprovider on a cube and ODS. Now i needed one more charactersitic from other cube.then i did change multiprovider and then add that new cube and did the identification, and adjusted the query, when i ran the query it is showing chracteristic as # and not assigned. I even tried bringing in 0infoprovider object to see whether data is coming from third infoprovider, it is not showing up any data from third one. i tried logging out of bex and logging back in.....but still no use..............i am wondering now, once a multiprovider is created can new infoprovider be added to it ?

i am even able to see the new key figures and chracteristic in my query.but data is not getting populated...i also checked and found that the data is available in the infoproviders....

plz help me out..

points will be assigned for inputs

[Former Member]

Hi,

You can add a Infocube to the already defined multiprovider.But before that ensure that the cube you are adding contains data.Assuming that the cube contains data and the identification is correct, please try to run the following program to generate the changes you made to multiprovider: rsr_gen_direct_all_queries.There you need to mention the name of the multiprovider.

Hope this helps.

Assign points if useful.

Regards,

Venkat

[Former Member]

hi kiran,

thanks for your reply, i tired the program , but still i am stuck with the problem, can you tell me anything i need to do to fix this?

thanks in advance

points will be assigned for inputs

[former_member188975]

Hi Ravi,

It is surely possible to add another base data target to a multiprovider once you have created it. As you can see the objects fromthis new cube in the query, I thin it may be something to do with other filters or settings that you have created in your query. If you like, you can run the query in RSRT using the Debug > Multiprovider explain option, and see if you get some hints into what is causing the problem.

Also you can try LISTCUBE on the mutliprovider.

Hope this helps...

[Former Member]

Hi Bhanu,

nice to see your answer, I saw a lot of helpful posts on SDN by you.

I did the RSRT with debug multiprovider, it said,

0FISCPER: General restriction for InfoProvider ZSD_C12 not possible

Access to ZSD_C12 was excluded

now i corrected it, it is populating the key figure now but not the chracteristic still.....the chracteristic is still getting value only from one of the info providers

importantly, when i bring infoprovider above the keyfigures space on query, it still only shows two info providers for each key figure and not the third one ,the key figure coming the third one is only shown in overall result. how can i solve this?

i tried rsr_gen_direct_all_queries as told by krian, but still cant get the data in the report. i did list cube on mulitiprovider and i see the data for that chracteristic there....

are there any other options in RSRT to find possible setting faults....

thanks in advance

points will be assigned for inputs

[former_member188975]

Ravi,

When you added the new cube to the MP, did you make proper adjustments to the Identification and Selection screen?

In your query, do you have a filter on char 0INFOPROV?

[Former Member]

Hi Bhanu,

I strongly feel there is a filter restricting the third infoprovider. but how do i check that?

i didn't do any restriction on infoproivders, and i tried manual restriction by bringing in all 3 infoproviders and execute the query, but it still didnt work....

i did a system proposed identification now..but still the problem persists..

where else can i look for query infoobject filters?

Message was edited by:

ravi a