Skip to main content
Contributor
Oct 4, 2023 2:57 PM UTC
Solved

XFBR not working when passing Custom Name Function

Hi community,

I am trying to pass a custom name function in the manner below:

XFBR(XFBR_CubeViews, CustomTimeExpansion, timeExp=T#2020.Base, desc = :Name(|MFTimeShortDesc|))

Somehow the XFBR is not able to append custom name function to the periods that are output in custom sort order. Its not reading the custom name function that i am passing to desc variable. Please help.

Employee - Sage
Oct 5, 2023 2:18 PM UTC

Yeah, that's not going to work. You can only append ":Name()" at the very end of the filter, e.g. XFBR(...):Name("My ColName") should work. :Name is effectively a command to the cubeview ("rename the column with X"), not a generic function.

In your case, I guess something like this *might* work, although it depends on what your XFBR actually does:

XFBR(XFBR_CubeViews, CustomTimeExpansion, timeExp=T#2020.Base):Name(|MFTimeShortDesc|)

2 replies

Employee - Sage
Oct 5, 2023 2:18 PM UTC

Yeah, that's not going to work. You can only append ":Name()" at the very end of the filter, e.g. XFBR(...):Name("My ColName") should work. :Name is effectively a command to the cubeview ("rename the column with X"), not a generic function.

In your case, I guess something like this *might* work, although it depends on what your XFBR actually does:

XFBR(XFBR_CubeViews, CustomTimeExpansion, timeExp=T#2020.Base):Name(|MFTimeShortDesc|)

Contributor
Oct 6, 2023 3:51 PM UTC

i agree this would work. thank you JackLacava !