Skip to Content

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 16, 2018 at 11:46 AM

    for % use this in webi table.

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

    Add comment
    10|10000 characters needed characters exceeded

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