cancel
Showing results for 
Search instead for 
Did you mean: 

Webi CrossTab- Extra un-necessary column

former_member223074
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Use the Same 'Where' condition in the body as well.

Create a variable for Measure object and the Formula should look like:

=[Var_Measure] Where([Fiscal Year]=[vUserRespYear] And  ([vMonthNum]="[vUserRespMonth]))

Kindly update the discussion.

Thanks.

former_member223074
Participant
0 Kudos

Hi,

Thanks for the response.

If I use the measure variable as suggested, I would need to create such variable for each measure.

What I am looking for is create one time dimension variable and apply the same to all the available measures. Though the approach you suggested works but I think it would not be optimum.

I am still not able to understand the reason behind the additional column creation.

Thanks,

Anil