Forum Discussion

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
2 years ago
Solved

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. ...
Cube View
Reports
Krishna's avatar
Krishna
Valued Contributor
2 years ago

CAIGuySeanF  - Based on the Example in the Member filter builder it should work.

 

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
2 years ago

Hey Krishna, I'm currently using that logic but want to make it dynamic.  My index needs to change each month as the column is AllPriorInYearInclusive.

For March, I needed the member filter to be..

GetDataCell(
CVC(Actuals, 1)+
CVC(Actuals, 2)+
CVC(Actuals, 3)
)

For April, I don't want to go back into the cubeview to add the 4th index.  I want to be able to automate it to pull all the values or base it off a parameter.

 

  • Krishna's avatar
    Krishna
    Valued Contributor
    2 years ago

    CAIGuySeanF  - Got it. You can use the XFBR for this based on the Time Period Filter it should return the GetDataCell formula. so you do not need to change every month.

    • CAIGuySeanF's avatar
      CAIGuySeanF
      Contributor
      2 years ago

      Do you have some sample syntax that I could leverage?

      • Krishna's avatar
        Krishna
        Valued Contributor
        2 years ago

        CAIGuySeanF  -

        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