Cube View - Column and Row Index
Is it possible to use a variable or dynamic selection on the the index? For example, I would like it to vary based on the cubeview time, e.g. - an index of 1:(SubPeriodNum).
See example below.
...
1. You have to create Dashboard XFBR String Rule under Business Rules.
2. Call the XFBR in your CV Col Ex XFBR(BRName,FunctionName, Param1 = Value1) Based on the below Code
XFBR(YourRuleName,YearParamRpt9,ParamYear=|!YourParam!|)
Hope this helps.
'Function Name If args.FunctionName.XFEqualsIgnoreCase("YearParamRpt9") Then 'Get the Parameter from Cube Dim Pov As String = args.NameValuePairs("ParamYear") 'Mon If FinalMon = "2024M3" Then Return "GetDataCell(CVC(Actuals, 1)+CVC(Actuals, 2)+CVC(Actuals, 3))" End If End If
