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
Sergey
OneStream Employee
OneStream EmployeeFdxExecuteCubeView but just with rows & columns headers ?
Dear Community,
For one of my project I need to get the values of a given cube view as a data table within my business rule. I can fairly use the FdxExecuteCubeView which will give me this kind of ...
There are a could of options to get the column headers. Do you need them for the extract or for reference when looping through the data?
The options for useStandardFactTableFields parameter in the FdxExecuteCubeView should enable you to export will change the column names.
True will return
Cube,Entity,Parent,Cons,Scenario,Time,View,Account,Flow,Origin,IC,UD1,UD2,UD3,UD4,UD5,UD6,UD7,UD8,RowHdr0ParentName, V2022M1(Amount)....
False will return:
PovCubeName,Pov00EntityName,Pov01ConsolidationName,Pov02ScenarioName,Pov03TimeName...
I usually have some log commands to help figure it out.
Dim colList as List(of String) = BRApi.Import.Data.FdxGetCubeViewOrDataUnitColumnList(si, timeMemFilter, isTimePivot, useGenericTimeColNames)
There are a could of options to get the column headers. Do you need them for the extract or for reference when looping through the data?
The options for useStandardFactTableFields parameter in the FdxExecuteCubeView should enable you to export will change the column names.
True will return
Cube,Entity,Parent,Cons,Scenario,Time,View,Account,Flow,Origin,IC,UD1,UD2,UD3,UD4,UD5,UD6,UD7,UD8,RowHdr0ParentName, V2022M1(Amount)....
False will return:
PovCubeName,Pov00EntityName,Pov01ConsolidationName,Pov02ScenarioName,Pov03TimeName...
I usually have some log commands to help figure it out.
Dim colList as List(of String) = BRApi.Import.Data.FdxGetCubeViewOrDataUnitColumnList(si, timeMemFilter, isTimePivot, useGenericTimeColNames)