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

     

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

       

      • CAIGuySeanF's avatar
        CAIGuySeanF
        Contributor
        2 years ago

        Thanks. I needed to modify the code a little bit, but this did the trick!  Appreciate the help!  Sharing my final syntax in the event it helps others.