Skip to Content
avatar image
Former Member

Routine in Multiprovider

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 08:52 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 21, 2007 at 07:08 PM

    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...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 07:44 PM

    You dont need a routine for this.

    Keep filter on value type in the query.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 08:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta

      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

  • avatar image
    Former Member
    Aug 21, 2007 at 08:34 PM

    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

    Add comment
    10|10000 characters needed characters exceeded