cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BEx and OLAP Analysis for Office

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

KamalMehta
Advisor
Advisor
0 Kudos

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

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks for the Responses,

Im closing the thread

cheers

Raj

former_member182470
Active Contributor
0 Kudos

Yeah, please close it.

anshu_lilhori
Active Contributor
0 Kudos

Hi,

You have to close the thread by marking correct answer or assumed answer.

Regards,

AL

MGrob
Active Contributor
0 Kudos

Hi

As the others explained calculate YTD in CMOD both will go through the olap engine CMOD is just a lot cleaner than create the forumla logic.

If you search SCN you'll find YTD codes for CMOD pretty quick. I remember posting it at least twice.

hope it helps

Martin

Former Member
0 Kudos

Hi,

Please let me know what u mean by OLAP level?

Do u mean about the transformation?

As far my knowledge any calculations part can be very well done in Bex level.

In your case u can use Variables in Bex to calculate YTD.

Hope this helps u.However just reply with what OLAP level means.

Thanks

Former Member
0 Kudos

Thanks for the responses ,

My apologies for not being clear.

Yes I agree, the YTD, MTD should be calculated at BEx level, when Im saying at OLAP level, its SAP BI OLAP for Analysis.

I would like to use BEx query as data feed for my OLAP Analysis View.

regards

Raj

former_member182470
Active Contributor
0 Kudos

Still you have to make your YTDs at Bex level only. Your OLAP server will just consider Bex as its source. When you try to execute from OLAP Server, it will execute through Bex(it will execute in CMOD). So no problems will occur. hope I have clarified your doubt.

anshu_lilhori
Active Contributor
0 Kudos

Hi,

As stated by suman all calculation happens at OLAP level only with the OLAP engine.

I think you must be saying regd the calculation at modeling level only.

Calculations like YTD MTD should not be created at modeling level as its all based on user input so that has to be calculated at runtime at bex level either with the help of formulas or by writing code in cmod.

I hope this is what you were referring to.

Regards,

AL

former_member182470
Active Contributor
0 Kudos

What do you mean by OLAP level?

All Bex calculations are done in OLAP engine. BEx and OLAP tightly integrated.

I think you are asking about Infoprovider level. Create separate KF for YTD in Cube and write the field level routine to populate into KF.

But this requirement can be done with Customer exits in the query. But the code has to be written in CMOD. So when the query executes from Bex, the actual execution happens in BW( CMOD) and fetches you the values to the BEx report.

Regards,

Suman