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.
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.
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.