I am trying to use a cross dimensional operator to display certain intersection of data on a planning form. However, when I save the form and try to preview it, I get an error like "Variable is not defined." This is the variable, i've been using in my calc scripts for a long time but the forms just dont like the usage of variable.
Has anyone encountered similar issues?
Thanks for any help.
To add extra information to the issue -
The variable I am trying to insert in the form is actually a range variable which marks the open periods for forecast. For instance, the variable might looks like this -
&Range = FY12->DEC,FY13->MAR
Pardon me if I am wrong, but we can't use cross dimensional operator in Planning web form.
If you want to use web form for forecasting, you can control the periods locking by using scenario dimension's start period and end period property.
Are you trying to use the range to display a certain set of columns on the form, or do you simply want to display the sum of "FY12"->"Dec":"FY13"->"Mar"? In other words, do you want the individual periods to show up as separate colums (or rows), or just one column/row containing the sum?
Ok.. that kinda answers my question. But its funny that the error message that the form give is something like "The variable is not defined." Could have used a better error message but Oracle is known for their ambiguous error messages.. So I'll let that slip by.
Anyways, Thanks for your responses.
Gotcha. Unfortunately, the only way I could see this working is by creating an alternate hierarchy in your Period dimension (that contains only forecast periods), and driving the forms off of that. As others have stated, you cannot use ranges (via a variable, or otherwise) in the form definition. You CAN use attribute dimensions, however those only work on Sparse dimensions.
EDIT - Now that I think about it, you would need two alternate hierarchies. 1) Forecast periods in Current Year 2) Forecast periods in Next Year.
Edited by: Jake Turrell on Jan 29, 2013 1:44 PM