Forum Discussion

josrisager's avatar
josrisager
New Contributor
2 days ago
Solved

Member Description using FdxExecuteDataUnitTimePivot

Hi.

I am using the FdxExecuteDataUnitTimePivot to pull data through a Data Adapter. My Setup now is only pulling the Names of the dimension members. Is there any way to get the descriptions as well? 

My Code:

		Public Function ToNexusSalaryBridge(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardDataSetArgs)
				Dim sScenario As String = args.NameValuePairs.XFGetValue("myScenario", String.Empty)
				Dim sYear As String = args.NameValuePairs.XFGetValue("myTime", String.Empty)
				Dim sWorkspaceID As Guid = BRApi.Dashboards.Workspaces.GetWorkspaceIDFromName(si, False, "Default")
				Dim sRootEntity As String = "MyRootEntity"
				Dim cubeName As String = "Test"
						
				'# data unit dims
				Dim consName As String = "Aggregated" 'member name only, no dim token
				Dim scenarioTypeId As Integer = ScenarioType.Budget.Id
				Dim viewName As String = "Periodic" 'member name only, no dim token
				Dim entityDimName As String = "E_ELTBU"
				Dim entityMemFilter As String = $"E#[{sRootEntity}].Base"
				Dim scenarioDimName As String = "S_ReportingScenarios"
				Dim scenarioMemFilter As String = $"S#[{sScenario}]"
				Dim timeMemFilter As String = $"T#{sYear}.Base"
				
				Dim suppressNoData As Boolean = True
				Dim parallelQueryCount As Integer = 8
				Dim logStatistics As Boolean = False

'				'# SQL like filter on output table
				Dim filter As String = "Flow='DKK_Input' and UD2='member1' and IC='None' and UD6='None' and UD7='None' and UD8='None'"
					
				Dim Dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, _
					cubeName, _
					entityMemFilter, consName, _
					scenarioTypeId, scenarioMemFilter, _
					timeMemFilter, viewName, _
					suppressNoData, False, filter, parallelQueryCount, logStatistics)
										
				If Dt IsNot Nothing Then
					Return Dt
				End If
		
		End Function