Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Can i use @PRIOR in an XREF?

edited Aug 4, 2020 3:05PM in Planning 5 comments

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");)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!