Question:
Hello everyone,
Is there anyway to create a KeyFigure variable? For example, if I want to run the report to see only key figure with amount > 500 the user should be able to do a variable selection based on it at the run time?
Answer:
Hi,
Hmm... very good question...
I've only heard of exception reporting for this type of situation. Check out the whitepapers etc. Alternatively you might want to look at virtual key figures (not sure if these will do the trick, but worth a look).
Good luck!!!
Kim.
Answer:
Use Conditions. In the Conditions tab you can create a variable for Key Figures.
_________________
Ciao.
AQ
Answer:
Hi,
I must be thinking of something else... I didn't think the user could select their variable range using a condition - it doesn't pop up on the selection screen before the query executes.
Conditions are defined with fixed values against characteristics during query creation, so I'm not sure how you'd put a variable against that. If you could explain though, I'm sure it would be useful to know.
Many thanks,
Kim.
Answer:
If you want to restrict what get displayed in the report before query execution, user the variables (based on authorisation etc). However, after the report has executed, the Conditions can be used to do restrict the drill down to certain KF restrictions. I have found that within a Condition, the OR logic is applied but if you need to apply KF restrictions with the AND logic, this is possible between Conditions - just handy hint.
Answer:
Hi,
That would be before query execution - I needed to know details of how a user would make the selection *during* the query execution.
The situation is that the user wants to compare different variances based on his selections, which change daily. (eg. Monday wants to see sales over $5mn only, then on Tuesday, wants to see sales over $10 mn only).
I think the only way to do this is run the query for the whole value range of key figures, then use Excel to filter it, and use a custom filter which contains the logic.
If you could choose the range before running the query, then condition or exception reporting would be the obvious choice.
Hope this helps, and makes sense!!
Cheers,
Kim.
Answer:
You can do exactly what you are wanting to do by using a variable in a condition. When you are creating your condition, after you select <New>,
select the key figure that needs the condition, then select if it is equal to, not equal to, etc... After this, instead of putting a number in the last box, there is a variables entry check box, select this box then create a variable so that the users can enter the value that will be used in the condition. Hope this helps.
jlaruss
Answer:
Dear jlaruss
I am in 3.0b but the using variables for value is available in creation of exceptions and not in creation of conditions. In which version is this functionality available
Srikaran
Answer:
I am on version 3.0B SP12 and can create a formula variable in the create condition screen. I have been able to do this since we upgraded to BW 3.0B SP05. I am not sure why you would not be able to do this.
jlaruss
Answer:
Hi,
Is there a way to create a Key Figure Variable in a sense that the user can enter whatever they want and the query will use this number in a formula. Specifically, I need to provide capability for "What if analysis" where the user can enter whatever unit cost they want and the query will calculate Gross Margin based on this cost and the quantity that is in the cube, etc.
Is there anyway to use a Virtual Key Figure for this? What "step" are Virtual Key Figures calculated? In the regular variable user exit, there is the concept of I_Step 1 thru 3, eg. I_STEP = 1 is before variable popup, I_STEP = 2 is after variable popup. Does this exist for Virtual Key Figures?
Thanks.
Answer:
What you need to use is a formula variable. If you go into the formula editor in BEx, you can chose a formula variable or create a new one. You then create a formula that uses the variable for the calculation. As for the virtual key figure, I_STEP does not need to be used, that is only for the customer exit for filling variable values. The virtual key figure is always calculated before the query is executed in the OLAP processor. Hope this helps.
jlaruss
Answer:
Hi,
I wanted to know if this was possible only in the higher versions of BW, namely 3.0b.
I am currently on 2.0b and I do not see the option of creating a variable for key figures in the conditions tab.
Thanks
Answer:
This is a new feature in BW 3.0B. In 2.0 you have to use static values for conditions. Sorry.
jlaruss