Routine in Multiprovider

[Former Member]

Hi all

There is mutliprovider which is taking plan data from both Cubes say A & B & Actual data only from B

My requirement is so that i want to have data for this report like plan data from A & actual data from B .

how can this be achieved ??

is any routine possible to identify the Amount field based on the 0valueType ??

is there any workarnd ?

Regards,

Ramesh

[Former Member · Accepted solution]

Thats why I gave you how to definem your rest key figures.

OR

Keep a filter on info provider and restrict it with cube A.

Ravi Thothadri

[Former Member · Accepted solution]

Thanks Ravi and Bhanu....

My problem is solved. it works.

points to both

[Former Member]

In the rest key figure you cna have like this:

Value type - restricted by 10.

Info provider - cube A

key figure - 0amount.

Likewise for value type 20.

Ravi Thothadri

[Former Member]

Thanks Ravi and Bhanu

But in my case the the data in the query is present for both value types from the Cube A

. HOw is it possible to restrict it in the query as to from which Cube the amount field data should come.

if it were to be a routine , my logic would be

if Value type = 10 , pull amt from Cube A

if Value type = 20 , pull amt from Cube B

one more problem , is that i need to keep both value type 10, 20 data in Cube A as a requirement for another query, so I cannot restrict the data in the Cube either.

hope you got hold of my problem.

Thanks

Ramesh

[former_member188975]

Hi ramesh,

This is why I suggested you to create RKF. Are you familiar with this concept? If not, check here:

http://help.sap.com/saphelp_nw04/helpdata/en/61/d0b143aa26b849b4e79a859ea1d7d1/content.htm

Hope this helps...

[Former Member]

Hi Bhanu

A RKF can restrict the data based on a KF like I can define a Selection showing data only Plan data & other one with Actual only.

But in my case the Plan data is coming from both the Cubes A & B in the Multiprovider , But I want in my Query that the Plan data show come only from Cube A.

is this possible through RKF ?

if yes , can you help me out.

if no, is there any other way out ?

Thanks

Ramesh

[Former Member]

You dont need a routine for this.

Keep filter on value type in the query.

Ravi Thothadri

[former_member188975]

Hi Ramesh,

You can do this in the query using RKFs. There is no way to write a routine for multiprovider as the data is not loaded to this object.

Hope this helps...