FDXExecuteCubeView cannot export annotation columns

martharany
New Contributor

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.

 

1 ACCEPTED SOLUTION

sameburn
Contributor

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

 

 

View solution in original post

2 REPLIES 2

sameburn
Contributor

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

 

 

Thanks for your solution @sameburn