Skip to Content
avatar image
Former Member

multiprovider issue ..??

Hi All

I have created one MP on inventory cube and budget cube. But data only coming for inventory cube only in sap bex query. common identification is material and 0fiscper. Here I am sending 0calenderday as posting date to query as input, calculating YTM for budget. Calenday is part of inventory, so I have fiscper is common values. Lets look below example.

calendar date: 17.09.2013

Budget YTM : I need for 09, 10, 11,12 months means till year end. I am calculating stock for the previous months till year start. And checking how much budget I have for future. I am getting stock YTD., not getting budget YTM., Am I missing any thing here ???

Regards

swetha

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Sep 18, 2014 at 04:59 AM

    Hi,

    Please check your two base cubes have data for reporting symbol?

    Any failures of roll up or create index?

    please check them.

    Even try to run your report thru RSRT - use debug option.

    That may give idea, where its stopping to display data from two cubes.

    Mean while try to see the data thru t code - LISTCUBE.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      I did everything. In debugging also, I found that 0FISCPER for LOW and HIGH properly assigning in variable code. But data is not coming. listcube is giving data. but its not working at query level.

  • avatar image
    Former Member
    Sep 18, 2014 at 05:03 AM

    Hi Swetha

    Did you check the Multiprovider assignments or perform LISTCUBE
    There is also 0INFOPROV which is used to restrict the infoprovider underlying a multiprovider. Could you please check what is it showing?
    Below thread has been answered by experts see if it helps


    Thank You
    Aparajit

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2014 at 05:23 AM

    Hi Swatha,

    1)Can you please check once again the assignment of info objects it should be from both data target.

    2)check the data in to each data target for same conditions

    Regards,

    Ganesh Bothe


    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2014 at 06:08 AM

    Are you putting 0CALDAY as characteristic restriction? Is 0CALDAY part of your budget cube?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi,

      make a copy query, then step by step remove all the restrictions on the query and see which characteristic is resulting in filtering out the inventory data. And if removal of all restriction also does not bring data, then add the base inventory kf in the copy query and then one by one add all the restriction applied on the RKF for inventory data.

      regards,

      Arvind.

  • avatar image
    Former Member
    Sep 18, 2014 at 06:18 AM

    hi,

    the 0calday should not be in the global filter, it should be used in dummy kf, if you need to input some date for KF calculation. If 0calday is in global filter then the whole data is restricted to those values and as 0calday is not present in budget cube,hence the data is getting filtered out.

    regards,

    Arvind.

    Add comment
    10|10000 characters needed characters exceeded