Hello every one !
I have few reports which were converted from XI R 2 to XI R 4.0 but they did not convert correctly. When you open the reports so each block has value as " multivalue". Can you please help why I am getting this error and whtas the solution to it. Thanks
junaid1987 (BOB member since 2013-08-08)
Try searching the WebI forum on the term “multivalue”
charlie 
(BOB member since 2002-08-20)
There have been calculation changes between the two versions, quite often the brackets need to change position. You will have to re-work the formulas to get these working again.
Mak 1 
(BOB member since 2005-01-06)
OK this is the formula
=[Custom - Total Exceptions Approved 1M to 2.5M]+[Custom - Total Exceptions Unapproved 1M to 2.5M]+[Custom - Total Exceptions Approved 2.5M]+[Custom - Total Exceptions Unapproved 2.5M]
Can you tell now how can solve it. Thanks
junaid1987 (BOB member since 2013-08-08)
Are those other Webi variables, or straight objects from the universe?
If they are other variables, how are they defined?
Mak 1 (BOB member since 2005-01-06)
All Of these are variables defined at report level. And all of them have almost same kind of structure.
junaid1987 (BOB member since 2013-08-08)
Well, maybe you can actually state what the syntax is for each of these.
Does simply wrapping a Sum() round the variable work.
=Sum([Custom - Total Exceptions Approved 1M to 2.5M]+[Custom - Total Exceptions Unapproved 1M to 2.5M]+[Custom - Total Exceptions Approved 2.5M]+[Custom - Total Exceptions Unapproved 2.5M])Mak 1 (BOB member since 2005-01-06)
The syntax is same but there is only difference in : approved and unapproved
=[Custom - Total Exceptions Unapproved 1M to 2.5M]
=[Custom - Total Exceptions approved 1M to 2.5M]
junaid1987 (BOB member since 2013-08-08)
Again, please post the Webi syntax of all the variables.
Have you tried wrapping this in a Sum(), as I suggested earlier?
Mak 1 (BOB member since 2005-01-06)
Yes I didnt work I even tried TO check avoid multiple aggregation that aslo didnt work 
Is there something we can do at universe level??
junaid1987 (BOB member since 2013-08-08)
In the variables sintax there are any If ?
rgoulart 
(BOB member since 2011-08-21)
That is likely to remain a mystery 
Mak 1 (BOB member since 2005-01-06)
These are dimension variable:
=If( ([Custom - Item]<>“Fin stmt quality”)And([Custom - Item]<>“Curr fin stmt borrower”)And([Custom - Item]<>“Current fin stmt guarantor”)And([Custom - Item]<>“Global cash flow analysis”)And([Custom - Item]<>“Moodys fin spread projection”)And([Custom - Item]<>“Current credit analysis”) ; “Non-Customer-level Exception” ; “Customer-level Exception”)
=If( (Left(Trim([Itemkey D]) ;1)=“1”) ; [Adhocdescription] ; (If( (Left(Trim([Itemkey D]) ;1)=“2”) ; [Adhocdescription] ; (If( (Left(Trim([Itemkey D]) ;1)=“3”) ; [Adhocdescription] ; (If( (Left(Trim([Itemkey D]) ;1)=“4”) ;[Adhocdescription] ; (If((Left(Trim([Itemkey D]) ;1)=“5”) ;[Adhocdescription] ; (If((Left(Trim([Itemkey D]) ;1)=“6”) ; [Adhocdescription] ; (If((Left(Trim([Itemkey D]) ;1)=“7”) ;[Adhocdescription] ; (If((Left(Trim([Itemkey D]) ;1)=“8”) ; [Adhocdescription] ; (If((Left(Trim([Itemkey D]) ;1)=“9”) ; [Adhocdescription] ; Replace(WordCap(Trim([Itemkey D])) ;"_" ;" "))))))))))))))))))
=[Custom - Region Name]+[Banknumber]+[Account Customer Name]+[Custom - Category]+[Custom - Item]+[Custom - Status]
=[Region 1]+[Banknumber]+[Category D]+[Custom - Status]+[Custom - Item]
=[Banknumber]+[Account Number]+[Note Number]+[Commitment Number]+[Current Commitment Amount]+[Note Current Balance]+[Custom - Total Relationship Debt]+[Custom - Item]+[Custom - Category]+[Custom - Status]+[Comments]+[Custom - Whether Above 1M]+[Custom - Whether Greater Than 2.5M]+[Custom - Exception Level]
=If( ([Custom - Total Relationship Debt] > 2500000) ; 1 ; 0)
= If( ([Custom - Total Relationship Debt] >= 1000000) ; 1 ; 0)
These are Measure variables:
=Sum(Count([Custom - Unique for Loan Account Level])ForEach([Xt Loanaccount Id] ; [Custom - Item] ; [Custom - Status])Where([Custom - Exception Level]=“Non-Customer-level Exception” And [Custom - Status] = “Approved” And [Custom - Whether Greater Than 2.5M] = 0))+Sum(Count([Custom - Unique for Customer Level])ForEach([Custom - Loan Account and Information])Where([Custom - Exception Level]=“Customer-level Exception” And [Custom - Status] = “Approved” And [Custom - Whether Greater Than 2.5M] = 0))
=Sum(Count([Custom - Unique for Loan Account Level])ForEach([Xt Loanaccount Id] ; [Custom - Item] ; [Custom - Status])Where([Custom - Exception Level]=“Non-Customer-level Exception” And [Custom - Status] = “Approved” And [Custom - Whether Greater Than 2.5M] = 1))+Sum(Count([Custom - Unique for Customer Level])ForEach([Custom - Loan Account and Information])Where([Custom - Exception Level]=“Customer-level Exception” And [Custom - Status] = “Approved” And [Custom - Whether Greater Than 2.5M] = 1))
=Sum(Count([Custom - Unique for Loan Account Level])ForEach([Xt Loanaccount Id] ; [Custom - Item] ; [Custom - Status])Where([Custom - Exception Level]=“Non-Customer-level Exception” And [Custom - Status] = “Not Approved” And [Custom - Whether Greater Than 2.5M] = 0))+Sum(Count([Custom - Unique for Customer Level])ForEach([Custom - Loan Account and Information])Where([Custom - Exception Level]=“Customer-level Exception” And [Custom - Status] = “Not Approved” And [Custom - Whether Greater Than 2.5M] = 0))
I hope it works
junaid1987 (BOB member since 2013-08-08)
Ok we are getting there.
What are the names of the variables, how do they relate to:-
=[Custom - Total Exceptions Approved 1M to 2.5M]+[Custom - Total Exceptions Unapproved 1M to 2.5M]+[Custom - Total Exceptions Approved 2.5M]+[Custom - Total Exceptions Unapproved 2.5M]Mak 1 
(BOB member since 2005-01-06)
Custom - Total Exceptions Approved 1M to 2.5M
Custom - Total Exceptions Approved 2.5M
Custom - Total Exceptions Unapproved 1M to 2.5M
Custom - Exception Level
Custom - Item
Custom - Region + Banknumber + Category + Status + Item
And what do you mean how do they relate??
I did not create these reports.
junaid1987 (BOB member since 2013-08-08)
Mak 1 wrote
If there was any conditional calculations (with an If), this could be generating a #Multivalue 
rgoulart 
(BOB member since 2011-08-21)
What should be the solution to it???
junaid1987 (BOB member since 2013-08-08)
Enclose your if with a Sum, like :
=Sum(If…)
rgoulart (BOB member since 2011-08-21)
I did that what happened is that Multivalue block has beeen replaced by a blank block. No data in the coloumn.
Anything we can do at the universe level???
junaid1987 (BOB member since 2013-08-08)
Do you have more than one query in your document ?
rgoulart (BOB member since 2011-08-21)