Summarising structure in Webi

[former_member462823]

HI All,

I have requirement-

I have two Crosstabs in webi

One is detailed and other one is summary of the first cross tab.

The rows and column of the crosstab is made up of bex Structure-
like below

          A1     A2     A3     B1     B2     B3

A1      1          1      1     1         1        2

A2     

A3

B1

B2

B3

Z1

Z2

Z3

Now I have to achieve the below summarized crosstab using the above cross tab..

          A     B     C     D

A

B

C

D

Z1

Z2

Z3

I have created two variables to get A from A1 A2 A3 and B from B1 B2 B3 and so on..

But the key figure is not getting summarized. shows multivalue error.

Can any one suggest how can I get the Keyfigure working to get the summary data.

PS: this summarization should happen only for A B C and D.. Z1 Z2 Z3 should remain same in summary cross tab..

Many Thanks,

Swapna

[Former Member]

Hello Swapna,

In that case you need to use String Function as

=Substr([ColumnData];1;1)

This will aggregate all A1,A2 and A3 to A similarly for B,C and D and for Z you can check an if condition as

=If Substr([ColumnData];1;1)="Z" then [ColumnData] Else Substr([ColumnData];1;1)

Regards

Niraj

[former_member462823]

HI Neeraj,

Thanks for the suggestion.

Unfortunately the key figure still  gives multivalue error..

I applied aggregation function as Sum([Keyfigure])..

[Former Member]

What are your measures is your Key Figure Delegated or Smart?

Since I am able to achieve the same with above approach.

Regards

Niraj

[former_member462823]

Hi Neeraj,

The measure is a keyfigure from bex.. I am not sure any setting like Smart or delegate should be set at Bex.
any such setting need to be done?