Formula variable used in exception and condition - gives a check error

[matt]

The same formula variable is used in a condition and exception within a query. When I click on "check", I get the message "Variable <myvar> Is Used By More Than One Infoobject". The variable is a formula variable, processed by User Entry/Default Value, with optional entry, ready for input, Dimension "number", default value -0.01. However, the query still saves, generates and executes without problem.

This is with BW 7.0, SP 14. And with query designer 3.5, version 3500.7.572

I'd be grateful if a few people could try to reproduce this, letting me know their version. To reproduce it:

Create a query. Create formula variable processed by User Entry/Default Value, with optional entry, ready for input, Dimension "number", default value -0.01. Create a condition using the variable. Create an exception using the variable. Click on Check. Save and execute the query.

Thanks

Matt

[Former Member · Accepted solution]

Hi Mathew,

It is not the error message it seems, It is just the warning. What ever u have done is rite.

Khaja

[matt · Accepted solution]

But it does seem that the warning is spurious.

matt

[Former Member · Accepted solution]

It is a warning and you can ignore it , if in query execution you get correct result / output...(then it implies u r on safe side)

But if you are so much concerned about warning then as a workaround just create another Formulae variable and use it in Condition and use the previous formulae variable for Exception.

This way you will have 2 variables for 2 different purposes

and you will get rid of the warning message.

So far if you get the correct output of query then there is no need to worry.

Edited by: kartikey on Dec 20, 2007 1:45 PM

[matt · Accepted solution]

Just in case someone with the same problem does a search, SAP have issued note 1134115 to address this issue.

matt