Skip to Content
0
Jul 31, 2013 at 10:13 PM

Webi CrossTab- Extra un-necessary column

22 Views

Hi all,

I am trying to create a cross tab report and source is HANA Analytical view. I am getting the additional column for the measure object after I have applied the Calculated dimension formula on the horizontal axis and Sales Org as another dimension on the Vertical axis.

The problem with this as I see is the sales measure is getting calculated correctly for the current year dimension but it is giving the additional column which is the rest of the sales amount excluding current year.

The formula for the dimension I applied on Horiz. Axis is "=[Fiscal Period]Where ([Fiscal Year]=[vUserRespYear] And ([vMonthNum]="[vUserRespMonth]))...

Thanks,

Anil

Attachments

test.png (28.3 kB)