Can i use @PRIOR in an XREF?
Summary
Can i use @PRIOR in an XREF?Content
Hello
I have a data form that runs a background rule to use XREFs to pull data from a separate cube. The rule uses a run-time variable using the chosen financial year on the data form. In the example below i want "ACCOUNT_200" to pull prior year values, how can i edit the syntax for the XREF on that specific line?
FIX({Year})
"ACCOUNT_100"(@XREF(_FSCube_,"OFS_Gross Profit","Cost Center","Total Geography","Total Market","Total Product");)
"ACCOUNT_200"(@XREF(_FSCube_,"OFS_Gross Profit","Cost Center","Total Geography","Total Market","Total Product");)
Tagged:
1