Get multiple time period in FDX

[ResmiKR]

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. 

[MarcR · Accepted solution]

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).

[ResmiKR]

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?

[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.

[ResmiKR]

Thank you for that. But in this case we have three account members.

[MarcR]

Never tried before but you could try: Account IN ('123', '456', '789') 

Or you could try Account = '123' OR Account = '456' OR Account = '789'

[ResmiKR]

Hi,

On adding to this pivot time function, is there any way to get multiple time under which i should have account column as well. 

[Sergey]

Hello,

You might probably need FDXExecuteCubeView, where you can get as an output all the data in a specified cube view, whatever time periods you use 🙂

You can find a few examples in this community : 

https://community.onestreamsoftware.com/t5/Rules/FdxExecuteCubeView-Function/td-p/7394

https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/FDX-methods-like-FdxExecute...

or here (oddly) : https://dzone.com/articles/onestream-fast-data-extracts-apis

Regards,

[ResmiKR]

Dear Community, 

On adding to this pivot time function, is there any way to get multiple time under which i should have account column as well.