Restricted keyfgure.

[ravi_chandra3]

Hi all

i want to create a report based on calendar year , i have to pass the year dynamically . i think i can use the restricted keyfigure, passing keyfigure value as amount and restricting calendar year dynamically.

How to achive this .

Any suggestion would be greatly appreciated

[Former Member · Accepted solution]

Hi,

If u create a RKF automatically the new row will created .It restricts that Particular keyfigure based on char but not all Kfs.

For this requirement simply u will create characterstic variable with user entry.

Drag calyear into rows.goto the charectersticrestriction tab ,select calyear RC retrict,in the next screen select variable ,create new charecterstic variable with processing type manual input/default value.

Hope ths helps.

Regards,

Sai.

[ravi_chandra3]

answered

[Former Member]

Simple, create a restricted key figure.. drag and drop amount and cal year inside it.. and then right click on the cal year and restrict it with a variable

Now when ever user execute the report they'll get the selection screen for cal year.. based on their input amount will get calculated!!

[ravi_chandra3]

Hi YJV

When i created a RKF using variable in that i selected current year(2011) but in my record there are no records with 2011 year. but still i am getting all the records y it is happening so

[Former Member]

When i created a RKF using variable in that i selected current year(2011)

so you are restricting the amount for the cal year 2011 static in the restricted key figure itself?

or u've restricted the cal year dynamically?? I mean using any variable??

Please check the restricted key figure again, cal year restriction may not saved.. check it and then execute the report..

Note: drag calyear in the rows, so that u can see for which year does the amount appears in the report..

Edited by: YJV on Apr 6, 2011 11:16 AM

[ravi_chandra3]

Hi YJV thanx for u r reply

Here when i have created the RKF , after executing in Analyzer i am getting another row , actually i have 3 keyfigure but now i am getting another row, in that i am getting the required result(getting the result as per the year given in the pop up) and AND IN THE REMAINING ROWS I AM GETTING ALL THE VALUES BUT I DO NOT WANT ALL THE VALUES TO BE DISPLAYED JUST I WANT ONLY THE REQUIRED RESULT AS PER THE YEAR GIVENIN THE POP UP.

EG:

suppose if gave 2009 in the pop up, i have to get

cust RKF amt price qty

c100 2009 100 20 2

c200 200 40 5

c300 300 150 2

c400 2009 800 400 2

the above is the result i am getting but i should not get all the result i should have the report of only 2009(given in pop up)

Edited by: Ravichandra.bi on Apr 6, 2011 12:10 PM

[Former Member]

Hi,

when you restrict the cal year with 2009 you shd be able to see the data Only for 2009 and not for any other years!

Check your variable once, are you using any offsets on the variable?? Please chcek and also keep calyear in rows and then execute the report.. then u can easily find where it is going wrong?