Skip to Content
Jan 16, 2018 at 11:33 AM

BEx Query KeyFigure returns #Multivalue in BO Webi



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.