on 01-19-2011 12:31 PM
Hi ,
1) CAn we identify whether a key figure is virtual? If yes how.
2) Virtual key figures are displayed at runtime in report or are they displayed in the cube itself?
3) Issue I am facing:
Key figure in infocube is neither mapped to anything nor any ABAP code is written in the routines but still values are present in the Infocube for that key figure.
I suspect it to be a virtual key figure. But I am not sure how virtual key figure behaves.
Need your help.
Thanks,
Ramesh
Hi.
Virtual KF is regular KF (the cube contains IO physically, but without data).
Such KF has no data in the cube because the values being calculated dirung query execution.
You can't identify in the cube whether KF is virtual or not - you should goto BADI for virtual KF and see is there any code that calculates the result for it.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ramesh,
yes virtual key figures are visible in cube also, the only difference is that the Virtual keyfigure is used to derive the value at run time.
Please go through the below link:
Tis will give a clear picture of how to implement VKF usin BADI.
Hope it Helps,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ramesh,
The key figure is not populated in the load process ie its value is not stored in the cube. The logic for populating the keyfigures is written in an SAP Exit RSR00002.
Since the values are computed at run time, it affects the query performance if you have too many VKF or too many records in your cube.
To give an example suppose you need an aging report where you want to show how many orders are delayed by 50 days , how many 50 to 70 days and so on based on todays date, So this number needs to change dynamically based on the date the report is run , you could use VKF in this scenario...There might be other ways of doing but just giving an example to explain the concept.
regards,
Raj
Hi Ramesh,
Most of your questions have been answered here. I would just like to consolidate on those and try to find a solution for you.
1) You are right, the KF you see in Infoprovider which is unmapped but still has value coming in the report, might be a virtual key figure.
2) Methods to fill VKF can either be written in SAP Exit RSR00002 and now, also using Business ADd-In definition RSR_OLAP_BADI.
3) As I understand, your main intention is to see the logic behind this. First, to verify if your query does use VKF, go to transaction RSRT, give your query name and check the Technical Information button. It shall show you under Olap relevant data if your query has virtual key figures or not.
4) Now, if your query does use VKF, you'll have to check in SAP Exit RSR00002, if there is any code written for your Infoprovider (as VKF logics are based on InfoProvider data). You would also need to check BADI implementations, as the method can also be there. Please check the following article:
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/60e34f63-f44c-2c10-488e-c89b04e0ca7c
You might want to check the Defined Filters for the BADIs existing in your system, to find your InfoProvider.
Please check in both places. Still looking for a standard table with such information.
Hope it helps,
Thanks.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.