Forum Discussion

SC's avatar
SC
New Contributor III
3 years ago

Time Description for non standard time profiles

Hi,   Would be great to get your thoughts on the below:   I have 2 cubes with 2 different time profiles attached – Standard (Jan-Dec) and AugYearEnd (Sep – Aug)   I have used the below qu...
Dashboards
Parameters
Conchas's avatar
Conchas
New Contributor
2 years ago

Hi All,

I was able to solve this issue as follows:

Dim strTime As String = args.NameValuePairs.XFGetValue("Time")
Dim TimeDimProfileEx As TimeDimProfileEx = BRApi.Finance.Time.GetTimeDimProfileUsingCubeName(si, "<CubeNameHere>")
Dim TimeDimAppInfoEx As TimeDimAppInfoEx = BRApi.Finance.Time.GetTimeDimAppInfo(si)
Dim TimeId As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId.Time, strTime)
Dim memberDesc As String = TimeDimProfileEx.GetTimeMemberDescription(si, TimeDimAppInfoEx, TimeId)

Return memberDesc

I hope this helps and kind regards,

Andrés