Skip to main content
M
MarkBird
Veteran
October 19, 2023
Solved

Use XFMemberProperty to get year from time parameter

  • October 19, 2023
  • 2 replies
  • 0 views

Hi 

I'm looking to get the year from a time parameter to use in a cube view header. Is it possible to use the XFMemberProperty rule if possible?

I've tried :Name(XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Year)) but the system doesn't like it.

Note, the following works to get the time description, but I'm looking to just get the year i.e. 2023

XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Description)

Thanks,

Mark

    Best answer by JackLacava

    Are you sure you can't do it with one of the substitution variables? |WFYear|, |PovYear|, |CVYear| ... ?

    If you have to go down the scripting route (be it in XFBR or CV Extender), I'd suggest to get the year in the "proper" way, to avoid issues with funky Time Profiles:

    Dim nValue As Integer = BRApi.Finance.Time.GetYearFromId(si, _
    BRApi.Finance.Members.GetMemberId(si, _
       DimType.Time.Id, "yourMemberName"))

    A bit slower than string manipulation but more robust.

    2 replies

    T
    Thomas_Bennett
    Newcomer
    October 19, 2023

    Probably overkill but you could write a brstring rule, send your parameter to that and substring it. I mocked it up here: 

    CV Column:

    Thomas_Bennett_1-1697712876403.png

    rule:

    Thomas_Bennett_2-1697712903284.png

     

    Output:

     

    Thomas_Bennett_0-1697712864126.png

     

      M
      MarkBirdAuthor
      Veteran
      October 19, 2023

      Thanks Tom, yeah I'll go down that route if there isn't an option using XFMemberProperty or some other standard function within OneStream

        J
        OneStream Employee
        JackLacavaOneStream EmployeeAnswer
        OneStream Employee
        October 19, 2023

        Are you sure you can't do it with one of the substitution variables? |WFYear|, |PovYear|, |CVYear| ... ?

        If you have to go down the scripting route (be it in XFBR or CV Extender), I'd suggest to get the year in the "proper" way, to avoid issues with funky Time Profiles:

        Dim nValue As Integer = BRApi.Finance.Time.GetYearFromId(si, _
    BRApi.Finance.Members.GetMemberId(si, _
       DimType.Time.Id, "yourMemberName"))

        A bit slower than string manipulation but more robust.

          M
          MarkBirdAuthor
          Veteran
          October 19, 2023

          Thank Jack, I managed to use |MFYear|

            Terms & ConditionsAccessibility statement