#Multivalue Error in BO XI3.1

building reports webintelligence
1

Hi BOB guys,

I’m facing an issue in the report developed in XIR2 and upgraded to XI3.1

I have raw data like this

date format band count
1/1/2009 urban abc 10
1/2/2009 rock abc 15

I want to display the data for the band with latest format as

Band Latestformat count
abc rock 25

In XIR2 we have achived it using formula
Latestformat= max(format) where(date=max(date)) forall (date)

In migrating this to XI 3.1 we are facing a multivalue error

Band Latestformat Count
abc #MULTIVALUE 25

I have tried to recreate the report from scracth but the issue still remains

Wondering if any of the experts could help me.

Thanks

arbbi (BOB member since 2009-05-19)

2

Hi, did you resolve this issue? We are seeing something similar here.

FionaCasey :ireland: (BOB member since 2007-01-22)

3

same here: no problem in XIR2 (although it seems to me that this problem also occurred before XIR2SP2), only in XIR3 !

anybody ?

mirko (BOB member since 2002-08-21)

4

I had this in two different reports. I was able to fix the issue by putting the ‘where’ bit inside the min brackets, like this for your formula.

Latestformat= max(format where(date=max(date)) forall (date) )

However I have another issue as well as that one.

I’m getting an ‘#UNAVAILABLE’ error inside a section. If I remove the section the error goes away. It’s nothing to do with the dimension that we sectioned on because if I include that dimension in the table but remove the section the error goes away.

Are you using sections in your report? Have you seen this error?

FionaCasey :ireland: (BOB member since 2007-01-22)

5

hi,

this error always pops up when I use the following formula:

= Max() where ( = value)

I’ll try the bracket solution as soon as I find the opportunity (no access to an XIR3 environment right now). I’ll make sure to post my findings.

thanks for your help, Fiona.

mirko (BOB member since 2002-08-21)

6

Thanks FionaCasey for the solusion

Changing

= Max(<object1>) where (<object2> = value)

into

= Max(<object1>  where (<object2> = value) )

works perfect :smiley:

[Moderator Edit: Added code formatting - Jansi]

kflorek :poland: (BOB member since 2007-02-10)