on 12-31-2009 12:32 PM
I am trying to create a crosstab with a number of meaures in it. I have a variable called opening stock and another called closing stock. The opening stock for day 2 is the closing stock for day 1 and is a variable [LV Opening Stock] defined as =Previous([closing stock];Row). This works fine. But, the closing stock for day 2 is the opening stock plus production minus sales. So my variable has to reference the previous days closing stock.
When it is defined as =[LV Opening Stock]+[Planned Production Qty]-[Forecast Daily Qty] it validates but when I try to save it I get the following message : The formula for variable [LV Opening Stock] contains a reference to a variable with the same short name. You must use the fully-qualified variable name in the formula to remove this ambiguity. (Error: WIS 10040)
How do I solve this? What is the fully-qualified name? Is it because it's effectively referencing itself?
I'm using XI R2 sp4
Thanks
John
Hi, Appreciate if anyone has a solution to this, I am facing the same issue.
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
What happens is that the variabla is referência itself be through a direct referente ( like [a]=[a]+2) or indirectly, like in the original case, it referentes a variable that references itseif, creating a recurrence.
The only possible way of recurrence in WEBI , is through the Self operator with Previous function.Can you share what's the fórmula givimg the error?
Regards,
Rogerio
Hello! Did anyone find a solution for this? I would really appreciate if you can help me.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Did you find a solution for this?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.