Skip to main content
S
Sergey
December 28, 2022
Solved

FdxExecuteCubeView but just with rows & columns headers ?

  • December 28, 2022
  • 1 reply
  • 0 views

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 output :

 

Cube Entity Local Scenario Time YTD Account None Top None None None None None None None None None 22.86874 21.68644 1.182297 5.451777

 

while my cube view is only showing accounts in rows and time in columns. One of the problem here is that I don't get the columns headers for the values ...

So my question is : is there a way to get an data extract in a form of a data table directly from a cube view with the same rows & columns headers only ?

 

Many thanks and happy holidays !

Best answer by BeauReynolds

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)

1 reply

B
BeauReynoldsAnswer
February 23, 2023

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)

Terms & ConditionsAccessibility statement