Question:
Can a restriction be placed on a key figure that is a < "less than" a variable?
How to set the formula?
Answer:
Are you wishing to restrict based on key figure values less than the variable value? If so, you could use:
- a condition
- a formula variable within a boolean formula.
Are you wishing to restrict based on a characteristic value less than the variable value (for example fiscal year/period less tan the variable input value)? If so, just restrict the key figure, using value range less than the variable.
Answer:
The need is to restrict the key figure by a date range.
The start date will be hard-coded.
The finish date will be an input variable.
How to include both types in a restricted key figure formula?
Answer:
- Right click on the key figure and choose Edit.
- Drag the Date characteristic/attribute from the left side (Dimensions) panel to the right side (Description) panel.
- Right click on the Date characteristic/attribute and choose Restrict.
- In the Selection pull-down (top left) choose value range.
- In the argument pull-down (top right) choose 'Greater than or equal to'.
- Pick the start date and move it to the Selection panel (right hand side).
- In the argument pull-down (top right) choose 'Less than or equal to'.
- Select the 'Variables' tab (left hand side).
- Pick the variable and move it to the Selection panel (right hand side).
- Click OK.
- Click OK.
Answer:
This all works fine, except that the variable that we need to restrict on is not available to pull over.
It is already used in a filter.
What is a workaround?
Answer:
The variable should be available for your RKF definition even if it's already used as a query filter.
If you've already included the variable as a query filter, you should not have to do any further restrictions based on the variable in your RKF definition. The filter should restrict the entire query result.
Therefore the RKF defintion should only require the lower value in the range.
Answer:
[quote="Anonymous"]The variable should be available for your RKF definition even if it's already used as a query filter.
It is not available to use.
Can it be keyed-in rather than "selected"?
Answer:
I have never tried to key in a variable to a restriction definition, but I doubt that you can do it.
I have tested (since your last post) the ability to use the same variable on the same characteristic in both the query definition and in a local restricted key figure definition. No problem (BW3.0B SP10).
Answer:
Thanks again, looks as if this question is in two threads.