Skip to Content
0
Former Member
May 29, 2007 at 09:25 PM

Exporting cube data in Excel or csv format

546 Views

Hi Guys,

I am trying to export data in cube to local directory in Excel spreadsheet or .CSV format. The cube contains close to one million records. Is there any best way to export the data. Is there any limit on number of records in csv format

In cube manage, in menu i see export spreadsheet option. But i think it will limit to 65535. I am trying to export in batches.

Is there any best way so that I can export as many records as possible?

Thank you