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.
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.