The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

osdevadmin's avatar
osdevadmin
New Contributor III
2 years ago
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.

Cube View
Parameters
Reports
  • JackLacava's avatar
    JackLacava
    2 years ago

    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

  • JackLacava's avatar
    JackLacava
    Icon for OneStream Employee rankOneStream Employee
    2 years ago

    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|)