XREF and mdshift

Summary:

Hi

I have a BSO and ASO architecture in the application, where BSO is used for data consolidation from different applications and ASO is used for aggrgation/reporting.

Content (please ensure you mask any confidential information):

Am writing calculation which involves calculating average of last 3 months using totals at parent level of multiple dimensions, is there any clean way to do it ?

Ex:

FIX(FY25,P02)
"ACCOUNT_100"(@XREF(_FSCube_,FY25,P01,"Cost Center","Total Market","Total Product") +
               @XREF(_FSCube_,FY24,P12,"Cost Center","Total Market","Total Product") +
              @XREF(_FSCube_,FY24,P11,"Cost Center","Total Market","Total Product");)

ENDFIX

Appreciate expert guidance and inputs, ideas