Question Re: Derived Variable in Technology Q&A

Derived Variable

Former Member — Sun, 04 Feb 2024 01:50:56 GMT

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

Re: Derived Variable

Former Member — Wed, 25 Jan 2006 19:29:27 GMT

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.

Re: Derived Variable

Former Member — Wed, 25 Jan 2006 19:36:11 GMT

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

Re: Derived Variable

Former Member — Wed, 25 Jan 2006 19:37:44 GMT

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...

Re: Derived Variable

Former Member — Thu, 26 Jan 2006 16:15:45 GMT

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.

Re: Derived Variable

Former Member — Thu, 26 Jan 2006 16:19:26 GMT

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

Thanks.

Re: Derived Variable

Former Member — Thu, 26 Jan 2006 16:20:46 GMT

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