Skip to Content

Navigational Attribute is not displayed in the report.

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 11, 2015 at 01:25 AM

    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


    pastedImage_2.png (15.9 kB)
    pastedImage_0.png (15.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 11, 2015 at 06:42 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 11, 2015 at 06:48 AM

    Hi Sanjana,

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

    Regards,

    Sreeni

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 11, 2015 at 11:41 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 12, 2015 at 10:13 AM

    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.

    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.