Skip to main content
Newcomer
Apr 26, 2024 4:43 AM UTC
Solved

FDXExecuteCubeView cannot export annotation columns

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.

 

sameburnAnswer
Employee - Advisor
Apr 29, 2024 8:27 AM UTC

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

 

 

2 replies

sameburnEmployee - AdvisorAnswer
Employee - Advisor
Apr 29, 2024 8:27 AM UTC

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

 

 

Newcomer
Apr 30, 2024 3:20 AM UTC

Thanks for your solution sameburn