Skip to Content
author's profile photo Former Member
Former Member

Multiprovider Mapping Issue # Values in the query output

Q . I am getting # values for the free chars and no values for some of the KPIs

I have created this report on top of a multiprovider which has a huge number of cubes ( exceeding 10 ) , four DSOs and a couple of infosets , and the query which i am creating should get values from 3 cubes only .

1.I have placed Global Restrictions ( Char Restrictions ) on top of the query with 3 cubes

2.had restricted the KPIs with the relevent infoproviders .

3.I have mapped all the chars and key figures used in this query with relevent infoprovider restrictions

But Still when i execute the Query i see the following formatt of my Output

Free Char KPI1 KPI2

filed3 10

field2 09

field1 07

field0 06

Not assigned 12.00 0

Not assigned 12.00 0

Not assigned 12.00 0

Please provide me input for why i am getting this kind of out put with Not assigned values and indifferent values for KPIs and what should be done to solve this problem .

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Nov 17, 2011 at 05:34 AM

    Hi,

    You mention that there are several InfoProviders underlying your MultiProvider. Check the characteristics and free chars you are using in your query - all of these should be present in all the underlying InfoProviders. For example, if you are using 0COMP_CODE in your query, and 0COMP_CODE is not present in one of the underlying DSOs, then they Key Figure values coming from that DSO will be shown against # (Not Assigned) value for 0COMP_CODE.

    Easy way to find out - go to LISTCUBE and enter your MP name. Display all the chars and free chars that are present in your query. Also display the INFOPROVIDER field. Look at the data, and see if there are any characteristics that are blank for all records for any particular InfoProvider. If you find any such chars, then that may be the reason behind your problem.

    To avoid this sort of problem, you can use Constant Selection http://help.sap.com/saphelp_nw70/helpdata/en/46/91f0f090ea13e8e10000000a155369/content.htm

    Regards,

    suhas

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2011 at 06:41 PM

    Individually do you get the data for the 3 different cubes? Please check.

    If the 3 cubes have different key figures, it my give the result in multiple rows.

    For not assigned, maybe there is no data in the cubes for that selection.

    If all this is fine, then the issue lies at the query level and assignment of key figures from different cubes.

    If possible, add the 0INFOPROVIDER characteristic to the query to check where the fields are being picker from.

    Regards

    Vishal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 17, 2011 at 11:16 AM

    Hi,

    Multiprovider works on Union Condition.may be that characteristic not present in your DSO's.

    if you want to find the characteristic name go to LISTCUBE and giver your Multiprovider name , it will displays the all characteristics and free characteristics in your query.

    Regards

    satyaprasad

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.