#MULTIVALUE Error

building reports desktopintelligence
1

Hello,

I am getting “#Multivalue” for a character object.
This issue is solved by applying Min/Max for numeric data objects.
But whats the option for charater datatype objects.
Please suggest.

Thanks;
Dipti

MBD (BOB member since 2009-08-18)

2

You can apply Min(), Max() for Character data type too.

Jansi :india: (BOB member since 2008-05-12)

3

#MULTIVALUE Error occurs when a block is confused when it receives a dimension qulification instead of a measure.

Point where in a block you are receving this error. what is the solution, the local variable and the block where this equation in the block?

KhoushikTTT :us: (BOB member since 2005-02-24)

4

If I am using Min/Max, the value disappears :frowning:

MBD (BOB member since 2009-08-18)

5

If you elaborate your exact requirement, we may help. Also please answer the questions of NewyorkBaasha.

Jansi :india: (BOB member since 2008-05-12)

6

What is the requirement?

KhoushikTTT :us: (BOB member since 2005-02-24)

7

Hey The thing is that if im dragging that charater object i should get a value. That object has multipls values and i am trying to get it in a single cell. So its obvious to get #Multivalue in that cell. But we can resolve this by applying Min/Max if its a numeric datatype to get a single value in cell, however the object is of charater datatype. So when i am applying Min/Max, the value disappears. But in formula bar i can see the object present.

MBD (BOB member since 2009-08-18)

8

Min and Max function would result in the what the object carries which is defined by the function itslelf.

What is the report requirement :?:

KhoushikTTT :us: (BOB member since 2005-02-24)

9

I’ve had the exact same problem! I used variables to select the value I wanted but still got #multivalue and when I used min or max, it would disappear (with the formula remaining). I’m going to post a separate topic to see if others have seen a change from XIR2 to XIR3 regarding merged dimensions (which I feel is causing this :hb: ), however, my resolution was to break my one query up into 3 separate ones so there would no longer be multiple values for the character description I was needing. I don’t know if that would help you out as well but it might be worth a try…and good luck!

mdower (BOB member since 2009-02-27)