How to name a CV column member in business rule

[Filip]

Dear community,

Is there a way to name (:Name("test")) a column when the columns in a CubeView is set by a parameter (Application dashboard) which is referencing to a business rule?

I want the last member to be renamed from description "2024 Q2" to a name I choose "2024Q2 YTD"

Public Function GetFCTCVColumnSet(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String

Try

Dim CurrentScen As String = args.NameValuePairs.XFGetValue("SelectedScenario").ToString.Replace("'","")

Dim CheckFct As String = CurrentScen.Substring(0,8)

Dim CheckFctSubstring As String = CurrentScen.Substring(0,12)

Dim TimePeriods As String = ""

Dim CurrentScenYear As String = CurrentScen.Substring(CurrentScen.Length - 4)

Dim CurrentScenNextYear = CurrentScenYear + 1

Dim CurrentScenNextNextYear = CurrentScenNextYear + 1

TimePeriods = "T#" & CurrentScenYear & "Q2:V#Periodic:U3#Top:U4#Top:U5#Top,T#" & CurrentScenNextYear & "Q2:V#Periodic,T#" & CurrentScenNextYear & "Q2:V#YTD"

[TheJonG]

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

[Filip]

Hi, 

Thank you for your reply. Yes I have tried it and unfortunately it didn't work.

[TheJonG]

I am not sure why that wouldn't work. Can you paste the entire XFBR rule script? I cannot see the Return value.

[db_pdx]

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