FDX Cube View Rule

Thanks.

I found the Solution & answered my own question

FDX Adapter call

{FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=FDX_Data_CubeView,entityDimName=AccReconEntity,entityMemFilter=E#|!FDXEntity!|}

Dashboard BR

Dim entityDimName As String = args.NameValuePairs.XFGetValue("entityDimName")

Dim entityMemFilter As String = args.NameValuePairs.XFGetValue("entityMemFilter")

KrishnaS

Here is the entire code & Steps. It is kind of very basic

1. Create a CV with the Parameter in this example it is entity. 

2. Dashboard Dataset rule is below.

3. Create an Adapter call the BR with the parameters. entityDimName parameter is your entity Dimension in the dimension library. This was the parameter I was missing in the adapter.

{FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=FDX_Data_CubeView,entityDimName=AccReconEntity,entityMemFilter=E#|!FDXEntity!|}

Case Is = DashboardDataSetFunctionType.GetDataSet
    If args.DataSetName.XFEqualsIgnoreCase("ExtractCubeViewTimePivot") Then

        Dim cvNameToExtract As String = args.NameValuePairs.XFGetValue("cvNameToExtract", String.Empty)
        Dim entityDimName As String = args.NameValuePairs.XFGetValue("entityDimName")
        Brapi.ErrorLog.LogMessage(si, entityDimName)
        Dim entityMemFilter As String = args.NameValuePairs.XFGetValue("entityMemFilter")
        Dim scenarioDimName As String = args.NameValuePairs.XFGetValue("", String.Empty)
        Dim scenarioMemFilter As String = args.NameValuePairs.XFGetValue("", String.Empty)
        Dim timeMemFilter As String = args.NameValuePairs.XFGetValue("", String.Empty)
        Dim nameValuePairs As NameValueFormatBuilder = New NameValueFormatBuilder(String.Empty, args.CustomSubstVars, False)
        Dim includeCellText As Boolean = False
        Dim useStandardFields As Boolean = True
        Dim useGenericTimeColNames As Boolean = False
        Dim filter As String = String.Empty
        Dim parallelQueryCount As Integer = 8
        Dim logStats As Boolean = False
        Dim dt As DataTable = BRApi.Import.Data.FdxExecuteCubeViewTimePivot(si, cvNameToExtract, entityDimName, entityMemFilter, scenarioDimName, scenarioMemFilter, timeMemFilter, nameValuePairs, includeCellText, useStandardFields, useGenericTimeColNames, filter, parallelQueryCount, logStats)
        If Not dt Is Nothing Then

            Return dt
            Brapi.ErrorLog.LogMessage(si, entityDimName)
        Else
            Brapi.ErrorLog.LogMessage(si, entityDimName)
            Return Nothing

        End If

    End If
End Select