Skip to Content
0
Former Member
Nov 06, 2014 at 08:16 AM

Multi Value Error in Webi report

65 Views

Hi,

I am facing #multivalue error in my webi report.

I am using 2 queries and source as single bex query

Bex query have prompt for Company hierarhcy.

Query 1

Company code

Company code- country text

Product

Filtered applied for country code dimension

Query 2

Company code

Company code- country text

Product

Filtered applied for country code dimension

In Report layout, Merged the dimensions Product,Company code, Company code-country text.

Report should contain only Product,Company code-country text, Revenue.

Created one variable total Revenue as below

=If(IsNull([Query 1].[Actual ]);0;[Query 1].[Actual])+ If(IsNull([Query 2].[Actual]);0;[Query 2].[Actual])

Is there any way to resolve this issue with including the company code text dimension in the report layout?

Attachments

Error Output.png (22.3 kB)