Skip to main content
M
martharany
April 26, 2024
Solved

FDXExecuteCubeView cannot export annotation columns

  • April 26, 2024
  • 1 reply
  • 2 views

Hi All,

I want to ask about my issue on FDXExecuteCubeView. It cannot export annotation columns or columns with text even I have put the parameter includeCellTextCols to True.

Here's the annotation column member filter : 


martharany_0-1714106351812.png

Fyi, the annotation appears in cube view but not in data table result from FDXExecuteCubeView.

 

Thanks for your help.

 

Best answer by sameburn

Hi martharany 

Try removing V#Annotation from your Column Nested Member Expansion 2.  You can enable the standard V# member from POV or equivalent here and the FDX BRApi can invoke (all) annotation columns to your datatable based on the cube view you pass in and setting the includeCellTextCols boolean to True e.g. 


sameburn_1-1714379215386.png

 


sameburn_0-1714379066000.png

 

 

1 reply

S
sameburnAnswer
April 29, 2024

Hi martharany 

Try removing V#Annotation from your Column Nested Member Expansion 2.  You can enable the standard V# member from POV or equivalent here and the FDX BRApi can invoke (all) annotation columns to your datatable based on the cube view you pass in and setting the includeCellTextCols boolean to True e.g. 


sameburn_1-1714379215386.png

 


sameburn_0-1714379066000.png

 

 

M
martharanyAuthor
April 30, 2024

Thanks for your solution sameburn 

Terms & ConditionsAccessibility statement