on 09-04-2013 7:12 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for the Responses,
Im closing the thread
cheers
Raj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.