Forum Discussion

CAIGuySeanF's avatar
CAIGuySeanF
Contributor
8 months ago

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

     

Krishna's avatar
Krishna
Valued Contributor

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
8 months ago

Do you have some sample syntax that I could leverage?

  • Krishna's avatar
    Krishna
    Valued Contributor
    8 months 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
      8 months 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.