a month ago
a month ago
Hi - have you tried:
TimePeriods = "T#" & CurrentScenYear & "Q2:V#Periodic:U3#Top:U4#Top:U5#Top,T#" & CurrentScenNextYear & "Q2:V#Periodic,T#" & CurrentScenNextYear & "Q2:V#YTD:Name("2024Q2 YTD")"
a month ago
Hi,
Thank you for your reply. Yes I have tried it and unfortunately it didn't work.
a month ago
I am not sure why that wouldn't work. Can you paste the entire XFBR rule script? I cannot see the Return value.
a month ago
I'm interpretting that your BR is generating a (complex) member expansion (as a string), correct? If so, you should be able to use regular MF variables. For example, your Cube View Column would be:
|!YourParameterThatResolvesXFBRString!|:Name(|MFTime| |MFView|)
Or if you are referencing the XFBR directly in the cube view column it would be something like:
XFBR(YourBRName, YourFunctionThatGeneratesMemberExpansionString, SomeParameter=|!YourCustomParameter!|):Name(|MFTime| |MFView|)
Cheers, -db