04-05-2023 09:04 PM - last edited on 05-03-2023 08:54 AM by JackLacava
I am trying to create a Cube View that has 2 GetDataCell formulas. The formulas work separately but if I add them both to the same Cube View, one will not work. I am using XFBR in Columns (Time) and GetDataCell in Rows (Accounts). Is there a way both formulas will work in the same Cube View?
Solved! Go to Solution.
04-06-2023 10:32 AM - edited 04-06-2023 10:33 AM
Ok, if both produce results rather than expanding members, only one of the two can "win". The priority should be (from lowest to highest) POV -> Columns -> Rows -> Column's Row-Overrides -> Row's Column-Overrides . I don't know if the XFBR messes with things somewhat.
04-06-2023 05:09 AM
Er, yes, there is no limit to the number of formulas you can have, as far as I know... I think we'll need more details to help further. Can you post a screenshot of your columns and rows definitions that don't work, specifying which one fails?
04-06-2023 07:40 AM
Yes, below is the column and row definition I am using. Individually they both work but if I put them in the same cube view, it picks up the column formula not the row.
04-06-2023 10:32 AM - edited 04-06-2023 10:33 AM
Ok, if both produce results rather than expanding members, only one of the two can "win". The priority should be (from lowest to highest) POV -> Columns -> Rows -> Column's Row-Overrides -> Row's Column-Overrides . I don't know if the XFBR messes with things somewhat.