12-12-2023 07:30 AM - last edited on 12-12-2023 08:30 AM by JackLacava
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.
Solved! Go to Solution.
12-12-2023 08:10 AM
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).
12-12-2023 08:10 AM
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).
12-13-2023 04:41 AM
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?
12-13-2023 04:45 AM
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.
12-13-2023 05:03 AM
Thank you for that. But in this case we have three account members.
12-13-2023 05:05 AM
Never tried before but you could try: Account IN ('123', '456', '789')
Or you could try Account = '123' OR Account = '456' OR Account = '789'
01-18-2024 11:47 PM
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.
12-12-2023 08:57 AM
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
or here (oddly) : https://dzone.com/articles/onestream-fast-data-extracts-apis
Regards,
01-18-2024 09:52 AM
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.