Skip to Content
0
Apr 23, 2015 at 09:14 AM

SAP BO WEBI Formula For #MULTIVALUE

141 Views

Dear Experts,

I need some suggestion for my WEBI formula:

We have to build a dashboard based on BO WEBI report.

Source of data for WEBI report is Relational universe.

We have build relational universe on ECC tables for specific scenarios.

My question is related to WEBI formulas:

I have data as shown below:

Transaction status Date Moth

T1 1 01 -02-2014 02-2014

T2 0 01-02-2014 02-2014

T3 1 02-02-2014 02-2014

T1 2 01-01-2014 01-2014

T1 1 01-02-2014 02-2014

T2 1 01-02-2014 02-2014

T1 0 01-02-2014 02-2014

T3 0 02-02-2014 02-2014

T2 1 01-02-2014 02-2014

T1 1 01-02-2014 02-2014

T3 2 01-02-2014 02-2014

I am expecting an Output :

T1 with status 1 on date 01-02-2014 in my scenario I want to compare with current date for time being the current date is 01-02-2014

Transaction Stat_1_count

T1 3

T2 2

T3 0


It would be grate if I get some suitable formula, I have tried using count/sum functions with where/ForEach Claus getting #MULTIVALUE issue when I put a dimension in the table drill down.

i.e. if I display only the count variable I am getting right value ,when I bring Transaction on table I am getting .

Thanks/Best Regards

Anand T