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