Multiprovider Mapping Issue # Values in the query output

[Former Member]

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 .

[former_member185132 · Accepted solution]

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

[Former Member]

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

[Former Member]

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