cancel
Showing results for 
Search instead for 
Did you mean: 

BEx Query KeyFigure returns #Multivalue in BO Webi

0 Kudos
293

Hi,


I'm struggeling with a report I'm building, where I have query-calculated key figure that returns a #Multivalue error in Webi.

I'm using BI Platform 4.1 SP6.6
Source is a BEx Query

In general the Problem is this:
I have the dimensions [Company Code] and [Company Region] (both comming from company). And I want to show the measures [revenue], [revenue budget] and [revenue budget%]

The [revenue budget%] is calculated in the query as KeyFigure. Its [revenue]
%A [revenue budget]

Now, when I create a table like
[Company region] | [company code] | [revenue] | [revenue budget] | [revenue budget%]
-> everything works fine

As soon as I remove the [company code] I get a #multivalue error for the %. When I do the exact same calculation in the report as a variable, it works fine.

Any ideas?


And before you suggest to use a Webi Variable => reason I don't calculate it in the report is, the query calculated object is already used in a couple of reports with a lot of tables. The have been created by someone else who is no longer with the company. unfortunately the reports were only tested limited to one company code, so it worked fine then.
I just want to avoid to have to replace everything.

Accepted Solutions (0)

Answers (1)

Answers (1)

amitrathi239
Active Contributor

for % use this in webi table.

=sum([revenue budget%]) foreach ([Company Code])

0 Kudos

It resolves the #Multivalue error but does a wrong calcualtion in some cases. It returns 0 even when there is a revenue and a budget revenue.

amitrathi239
Active Contributor
0 Kudos

just check with format number option and add decimal points upto 4 and see.might be in some cases values are bit small and near to 0.

0 Kudos

I'm afraid that's not it, no difference with 6 decimals or more.
The report variable with the same calcualtion also returns 82,1% in this case, so I think there's an error somewhere.

Any other ideas?

amitrathi239
Active Contributor
0 Kudos

if number of rows are same with Company region,Code and only with company region then you can hide the Company code instead of deleting in the report.

is there any more dimensions in the report or only two region and code only?

0 Kudos

A company region has multiple company codes but one company can only have one region. The company code itself is not needed at all in the final table.
I just trying to get it working in as small a setting as possible currently, which is why its only these 5 objects at the moment.

I also tried to adapt the Key Figure in the query and change the Aggregation settings or adapt the formula. No success so far.