The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Get multiple time period in FDX
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.
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).
8 Replies
- Sergey
OneStream Employee
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,
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).
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?
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.
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.
