SAP BEx and OLAP Analysis for Office

[Former Member]

Hi,

I got CCA Cube. Im creating the BEx Query which Includes YTD Calculations. Im using custom Exits, for that.

My question is Should I have YTD calculation at BEx level or Can I do it OLAP Level?

If its at OLAP Level, how can it be done

regards

Raj

[KamalMehta · Accepted solution]

Hi Rajeev ,

By defining it in Bex you are doing it at OLAP Level only.

Normally we define calculations related to YTD ,MTD etc in Query Designer only. You can achieve the same using Customer EDxit variable by writing code in CMOD.

Please check http://scn.sap.com/community/business-explorer/blog/2013/08/28/formula-variable-demystification

http://scn.sap.com/thread/1445551

Thanks