on 11-08-2007 10:48 AM
Hi
I have some KF's in my report .
1) When user enter the<b> "month"</b> in the selection paramter then he should get those KF's for that current month .
2) And he also wants those KF's values from <b>"Starting Month Of that Year to Current Month(YTD)"</b>.
so how can i get the YTD for those KF's in my report. please let me know
kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Try to create two variables one for one for Fiscal year and one for Fiscal Year/Period. Use those two variables in your query (select Fiscal Year/Period -> right click -> select the variable name -> select value range -> select greater than or equal to). (Make sure that you select variable entry as mandatory when you create those variables).
Hope this will help!
Let me know if you have any questions.
Thanks,
RK
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
1. Just restrict the KF with month.
2. You can restrict the KF with standart variable "Current year cumulated to current month". you can find it under the characteristic value variable of 0calmonth.
regards,
Mustafa,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
in addition, set the variable using a value range. then you can set the value between a specific range. for example start range = X and end range = Y. This allows for very flexible and dynamic selections.
in our case, we know ytd is always period 1 thru X, so we create RKF and in the definition, we restrict to a value range (aka interval) on posting period. the start period is hard coded = period 1, then the "to" range is a variable. then using separate year variable, user gets ultimate flexibility.
you can also use sap delivered variables which automatically determine current period/month based on system date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi,
Create restricted keyfigure and restrict againest Year (should be derived from Month entered by User) and Month(less than or equal to).
For year variable need customer exit.
Hope it Helps
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
11 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.