Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

#MULTIVALUE error due to Exception Aggregation in BEx Query

Hello Everyone,

I am currently working on BO 4.1 SP3. I am facing below issue. Do let me know if there is anyway to solve this issue.

I have a BEx query which has key figure Order Counts. This key figure is an exception aggregation key figure with Exception Aggregation as Summation and Ref. Characteristic as Sales Document. I am having Company Code in Rows So, I can see Order counts by Company code in BEx query output as well as BO Webi output.

I have a requirement to Group no. of Company codes and look at Order Counts by Regions -> Sub Regions -> Company Code ( Multiple Company Code will group into Sub Regions and Multiple Sub Regions will group into Regions). I have created Sub Regions and Regions as Dimension Variable in Webi by writing a Formula.

When I create a table inserting only Region and Order Counts, I am getting #MULTIVALUE error. If I insert Region, Company Code and Order Counts then I am not facing any issue and I can see all the values perfectly.

Please find attached below screenshot for your reference and let me know what can be done to resolve this issue.

1. Region Order Count

2. Region Company Code Order Count

3. Order Count Key Figure Definition

Regards,

Foram Shah

Former Member
Former Member replied

Hi Foram,

As you said that you have created the variable in the webi report. Region, Sub Region and Comany Code and while using with this variable you are getting a #Multivalue error.

This is happening because the Region you are using with Orders Count Key figure is conrtaing two values for the region. Create new variable(Measure) as below that will help you solve this error.

=[Orders Count] in {[Region], [Sub Region], [Company Code]}

or

=sum([Orders Count]) in {[Region], [Sub Region], [Company Code]}

or

=sum([Orders Count]) foreach([Region], [Sub Region], [Company Code])

Regards,

Vaibhav

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question