Skip to main content
S
ssmith-nova
February 16, 2026
Question

Export Cubeview with only the columns defined

  • February 16, 2026
  • 2 replies
  • 2 views

Hi All,

I am trying to export a cubeview using FdxExecuteCubeView, but I get every dimension even though my cubeview only shows 4 dimensions.  What is the best way to export a cubeview to retain its view.  I want to export multiple cube views and load them to a table so that I can have all of the cubeview data exported through one Data Adapter call via the rest API. 

Right now, I export one view I get 3 million rows, but when I aggregate it to the level in the cubeview I end up with 28,000 rows.  I'd like to avoid exporting 12 million rows if possible. 

Thanks,

Scott

2 replies

D
DanielWillis
Employee
February 16, 2026

I don't think this is my experience with FdxExecuteCubeView. I get extra columns but they're limited to what I requested it in my CV pov/rows/columns. Is there some additional logic within the CV that is perhaps throwing it off?

S
ssmith-novaAuthor
February 16, 2026

I don't see anything in the Cubeview.  When I export the cubeview to Excel, I get 136500 rows in excel.

Terms & ConditionsAccessibility statement