Derived Variable

[Former Member]

I seem to be stuck or just confused. The user wants to key in a month/year and then with that information I will derive a the Year, a actuals interval of lets say 001/2006 - 004/2006 and a plan interval from 005/2006 -

012/2006. The month they key in will not be used to restrict the data only the derived variables. Is there a way to do this? Will award points....

Richard

[Former Member]

Create a dummy Restricted Key Figure and hide it, have the variable for month in that Restricted Key Figure , use this variable for deriving the variable values in the exit.

Thanks.

[Former Member]

That sounds good, just not sure how to hide it?

[Former Member]

Hi Richard,

To Hide: right click your KF ( or RKF) > Properties. Here you can see the options for Hide in a drop down box to the right.

Hope this helps...

[Former Member]

If I'm going to create a dummy RKF whats the best way to create and restrict this. I don't want something that is going to add any addtional runtime to the query if possible.

[Former Member]

Just use any base key figure from the cube and your variable.

Thanks.

[Former Member]

I guess the rule of thumb would be to use the key figure from your avalilable one, which will not have a lot of aggregation to be done. You do not want to select a key figure that would be relevant at your line level.

Besides that restricition anything else is as good (or bad) as the other.

Doniv