"MULTIVALUE" in reports

[Former Member]

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.

[Former Member]

Post Author: Adrin

CA Forum: WebIntelligence Reporting

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

[Former Member]

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.

[Former Member]

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!

[Former Member]

Post Author: Adrin

CA Forum: WebIntelligence Reporting

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

[Former Member]

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.

[Former Member]

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?

[Former Member]

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