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

"MULTIVALUE" in reports

Post Author: Adrin

CA Forum: WebIntelligence Reporting

On Web Intelligence report I have encountered this problem. In some queries, if there is more than one value in database for some of the fields of query, the report can't display all values in different rows. It returns the data with the value of "#MULTIVALUE" for some fields.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:34 AM

    Post Author: amr_foci

    CA Forum: WebIntelligence Reporting

    "#MULTIVALUE" ,,i think this is based on ur business, you have to revise the contexts you've created at the universe level,, like there is one measure comes through 2 or more contexts

    good luck

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 08:13 AM

    Post Author: Adrin

    CA Forum: WebIntelligence Reporting

    But I have got the same report on Desktop Intelligence and the report was right with out any "MULTIPLEVALUE" so, what do you think about that?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 02:38 PM

    Post Author: jsanzone

    CA Forum: WebIntelligence Reporting

    Adrin,

    #Multivalue is a tricky item to navigate around, but let me explain a little bit of why it happens in a WebI environment.

    If you create a section on two items, then your two items must synchronized properly, otherwise your second item (the typical culprit) will show up as a #Multivalue entry. Let me give you a "for instance".

    You have an ID field and a reference (or description field): A/Dog; A/Cat.

    Both IDs are A, however, the reference one time shows as "Dog", then again as "Cat". If you put the ID and Reference in a Section but on two lines (or two cells), the Reference will show #Multivalue because WebI is seeing two items that can go into one space, and boom, you get #Multivalue. The solution is to go back and look at your data for consistency, if there are any inconsistency then you'll need to fix it and that should clear up the problem. I'm not very familiar with DeskI, so I'm not sure why you get different results, but when you see the problem in WebI, it normally means that something has not gone along with plan, so you need to regroup.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 05:31 AM

    Post Author: Adrin

    CA Forum: WebIntelligence Reporting

    thank you but let me know this issue can be related to universe design?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2008 at 04:10 PM

    Post Author: jsanzone

    CA Forum: WebIntelligence Reporting

    If your reporting objective is working correctly in DeskI, then I would rule out a problem with the universe and consider the problem to be a usage problem (technique) in WebI. I don't use DeskI so not of much help in that regard. However, if you can build it in DeskI and look at the SQL generated (if that is possible), and then build the report in WebI and do the same with SQL, maybe you can tell if something is wrong, or something you can do differently in the universe to help "correct" the WebI version. I'm just drawing straws right now, so good luck!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2008 at 01:01 AM

    Post Author: Rose2k

    CA Forum: WebIntelligence Reporting

    Hi, i guess this would fix your issue..Web Intelligence automatically aggregates any rows that display the same set of dimensions.If you select the Avoid duplicate row aggregation option, each duplicate value is displayed in a separate table column or row.

    1.Select the table, right-click and select Edit Format from the menu.The Properties tab displays the table formatting options.

    2.Select Display > Avoid duplicate row aggregation.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2008 at 06:22 AM

    Post Author: Adrin

    CA Forum: WebIntelligence Reporting

    thank you so much Rose2k, that did it and fixed the issue.

    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.