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

#MULTIVALUE When it Occurs and How Do I resolve it

I have a query and report built from two different data providers. One of the data providers is a reference universe that I have a query called Material Item which provides descriptive informaiton about an item of a shipment that I want to include in my shipments report. I've merged the dimensions of the two queries on "Material Item Identifier" I then added the joined dimension Material Item Identifier, and also a detail object (Material Item Name) I created since it wouldn't let me drag and drop this dimension on the report saying "incompatible object".

The problem I am having now is the detail object column in the report called "Material Item Name" some of the fields display the item name as it should, and then other fields give me the #MULTIVALUE. How do I need to change the report to get rid of the #multivalue and so the item name displays in the column right after Material item identifier in my shipments report?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 10:47 AM

    Hi John

    Make sure the measure value is sum instead of database delegated in universe level. if this is not worked out then provide a example of your requirement ?

    Sunil

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 13, 2011 at 02:56 PM

    Hi john,

    After changing the properties of the object a sunil mentioned.

    You should also go to Your webi report and under report properties ->Display ->Avoid duplicate row aggregation shoulld be marked as YES.

    Hope this help's!

    Regards,

    S.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      The only issue that still remains is My results are giving me duplicate rows which I really don't want. In some cases I have 3 or 4 records being returned for a single shipment. My pages of results also jumped from 4 to 33 pages. Is there any other solution?

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.