Navigational Attribute is not displayed in the report.

[Former Member]

Hi Experts,

   I am working on a Actual vs Target report. I want to see the Actual Quantity sold Vs Target Qty base on Region ( N / E / W / S ) , State and Dealer.

The report should look like below mentioned.

REGION ( N /E/W/S )	STATE	DEALER	ACTUAL QTY	TARGET QTY
N	J & K	1000450	100	200
E	ODISHA	1000152	280	350
S	KARNATAKA	1000415	450	540

But the same is appearing like below mentioned.

REGION (N/E/W/S)	STATE	DEALER	ACTUAL QTY	TARGET QTY
N	J & K	1000450	100
E	ODISHA	1000152	280
S	KARNATAKE	1000415	450
Unassigned		1000450		200
		1000152		350
		1000415		540

   This is working fine in quality system. But not appearing properly in Production system.

The actual data comes from one Info-cube . The Plan data, we load through Excel to a second cube. And finally merging the data by a multi-provider.

    I am not able to find any clue , what for this is happening.

Kindly suggest.

Thanks,

Sanjana.

[Loed · Accepted solution]

Hi Sanjana,

Check your cube if there are values for your NAV.ATTRIBUTES..If none, the problem lies in the ZERO PADDING of your values in DEALER (this is the masterdata, right?)..

Please check your object or transformation if you have ALPHA conversion..

SAMPLE:

If there is none, you may use this field routine code for your DEALER object..

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
   EXPORTING
     input         = SOURCE_FIELDS-DEALER
  IMPORTING
    OUTPUT        = RESULT.

Just change the correct SOURCE_FIELDS for your DEALER object..

Regards,

Loed

[Former Member · Accepted solution]

Hi Loed,

  Yes, there are values of Navigation Attribute in the cube.

0000000531	IN	N	DEL	201505	1,000
0000000538	IN	N	DEL	201505	1,000
0000001112	IN	W	GJ	201505	1,000
0000001113	IN	W	GJ	201505	1,000

But it is not appearing in the Report.

Put some light.,

Thank you,

Sanjana

[Loed · Accepted solution]

Hi Sanjana,

How come values didn't appear?

Can you tell us some info about your query? Like where it lies, if it is on top of multiprovider, what are the providers under it, what are the objects in the providers, etc..

If DEALER object are present in all your providers and if it is the masterdata then values should be available in your report unless you have filters in  your keyfigures..

Regards,

Loed

[Former Member · Accepted solution]

Hi Loed,

    The Query lies just above a multi-provider.

The data flow is like , Actual data is stored in CUBE-1 and Target data is stored in CUBE-2. And to combine, a MULTI-PROVIDER is placed.

   For checking , I created a query over CUBE-2. The query is fine. This is displaying the required data as required. Only problem in the query generated from Multoprovide.

Please advice.

Thanks,

Sanjana

[Loed · Accepted solution]

Hi Sanjana,

Then perhaps you didn't assign the correct assignation of provider in multiprovider..

Right click one of the attributes of MULTIPROVIDER and select ASSIGN, click ALL then OK..

Regards,

Loed

[swati_gawade]

Hi Sanjana,

First of all, please check the assignment of the navigational attribute in your multiprovider. It should be mapped from both cubes with those Cubes Nav-attributes.

Then check if your multiprovider is active and then display the data using LISTCUBE transaction. If you are able to see the values correctly then there should not be any issues in Bex query.

If you still see issues then check your input file data at PSA level. check if its in correct format(like no spaces or special chars etc)

Hope this helps.

-Swati.

[former_member186053]

Hi Sanjana,

How are the region and dealer fields are pulling data, i mean from both cubes. Blank lines are generated due for one field data is available in 1st cube and no data in other cube(cube2) or vice versa.

Regards,

Vengal.

[konkasreenivasulu]

Hi Sanjana,

Could you please check for assignment in multiprovider and values for Region InfoObject in Target infocube.

Regards,

Sreeni

[konkasreenivasulu]

Hi Sanjana,

Could you please check in Multiprovider , where Dealer InfoObject is assigned for both Info providers ( Tick CheckBox for both ). And also check Dealer InfoObject has values in the Target InfoCube.

Hope this will solve your issue.

Regards,

Sreeni