Skip to Content
0
Former Member
Aug 18, 2008 at 10:32 PM

Dynamically update a KF name?

16 Views

I have numerous key figures which are based on the year (past, present, and future).

For example, I have a key figure which identifies the percent difference between current year sales and last year's sales. The key figure is: "2008 Total vs 2007 Total % Chg."

Every year, I have to update this book to adjust for the new year.

I'd like to be able to remove this manual intervention, while still displaying year. Is there any way that I can dynamically set the KF name based on the date? So, when Jan 1, 2009 hits the key figure would automatically roll over to the new year and display "2009 Total vs 2008 Total % Chg".