BEx Query KeyFigure returns #Multivalue in BO Webi

[former_member598675]

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.

[amitrathi239]

for % use this in webi table.

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

[former_member598675]

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]

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.

[former_member598675]

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]

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?

[former_member598675]

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.