Solved

Get multiple time period in FDX

Forum|Forum|2 years ago
December 12, 2023
3 replies
1 view

Dear Community,

How to get multiple time period data in FDX ?

We have data's in row manner. We need it in column wise.

The data is imported into a table using FdxExecuteDataUnit function.

Best answer by MarcR

Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, "Corporate", "E#Frankfurt", "Local", ScenarioDimHelper.GetIdFromName(si, "Actual"), "S#Actual", "T#2018.base, T#2017.base", "YTD", False, False, Nothing, 8, True)

'Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, useGenericTimeColNames, filter, parallelQueryCount, logStatistics)

Try the TimePivot variant(s).

M

MarcRAnswer

Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, "Corporate", "E#Frankfurt", "Local", ScenarioDimHelper.GetIdFromName(si, "Actual"), "S#Actual", "T#2018.base, T#2017.base", "YTD", False, False, Nothing, 8, True)

'Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, useGenericTimeColNames, filter, parallelQueryCount, logStatistics)

Try the TimePivot variant(s).

R

ResmiKRAuthor

Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, "Corporate", "E#Frankfurt", "Local", ScenarioDimHelper.GetIdFromName(si, "Actual"), "S#Actual", "T#2018.base, T#2017.base", "YTD", False, False, Nothing, 8, True)

In this filter if I need to include multiple account dimension members, How to include that. Is that possible?

M

MarcR

Yes, in the filter option (the Nothing before the 8 parallel count) you can use 'SQL type filters' e.g. Account <> 'COGS_USENG'

So not A#xxx.tree but it should get you there. However, if you set a filter that returns no values it will return all. It must be a filter that returns data.