josrisager
2 days agoNew Contributor
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
You can implement similar logic to this thread, getting descriptions instead of IDs: How to include Member IDs in data export | OneStream Community