Forum Discussion

ssmith-nova's avatar
ssmith-nova
Contributor
1 day ago

Export Cubeview with only the columns defined

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

Data Integration

2 Replies

  • ssmith-nova's avatar
    ssmith-nova
    Contributor
    23 hours ago

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

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    1 day ago

    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?