Can we use Sum range function within XREF function in Oracle EPBCS ?
I am trying to fetch GL wise data from a custom cube to financial statements lines in out of the box FS cube, for this I am using @XREF with @SUMRANGE function in FS cube, While doing so I am encountering an error which says,
"Cannot calculate. Essbase Error(0): Error executing formula for [Revenue Reserves] (line 3): argument [2] can not be [LIST] in function [@_XREF]"
Any Idea where i am going wrong? Can Sumrange be used with XREF? Any help will be highly appreciated. Thanks.