Hello,

Over the past several weeks and months, I had several interactions with IBM support on issues around exporting and importing data and elements, all in PAW.

Meaning that, an export does not happen, or it gives a CSV file with only the header line (dimension names). Or the export takes place but the import of that same file in the same cube on development does not finish. Sometimes the data is prepared but the file is not downloaded. Etc.

This topic is just to let you know that a number of these tickets lead to known defects and IBM are correcting them. First have a look at known defects before spending too much time or creating new support tickets.

Hi Wim,

The CSV export feature that we added is generating an MDX query and pushing the results of that query to a file.  One possible reason why a valid MDX query might fail is the MaximumViewSize parameter in TM1 being set too low.  We are working on some improvements to detect when the query failed and properly indicate the failure to the user.

We are still working on functionality in PAW books that will allow action buttons to be used to run a TI process and download the results.  The significant difference between using MDX and TI processes to export is model security (TI processes ignore security). 

Hello,

Over the past several weeks and months, I had several interactions with IBM support on issues around exporting and importing data and elements, all in PAW.

Meaning that, an export does not happen, or it gives a CSV file with only the header line (dimension names). Or the export takes place but the import of that same file in the same cube on development does not finish. Sometimes the data is prepared but the file is not downloaded. Etc.

This topic is just to let you know that a number of these tickets lead to known defects and IBM are correcting them. First have a look at known defects before spending too much time or creating new support tickets.

Hi good afternoon

Old thread, I know, but problems are always fresh.

AWS PAaaS here.

Is it possible to export a real large view? I mean - a view which potentially will generate a 2~4gb csv file? It looks that the 'export data' has some limitations on size, is possible to tweak them?

I looked for the maximumviewsize parameter on v12 in order to change it. I haven't found it under configuration tab on Admin. Is this parameter supposed to be shown? Is there some tricky way to show it?

Can I expect that real large views will export to csv?

Thanks

Márcio

Hi Wim,

The CSV export feature that we added is generating an MDX query and pushing the results of that query to a file.  One possible reason why a valid MDX query might fail is the MaximumViewSize parameter in TM1 being set too low.  We are working on some improvements to detect when the query failed and properly indicate the failure to the user.

We are still working on functionality in PAW books that will allow action buttons to be used to run a TI process and download the results.  The significant difference between using MDX and TI processes to export is model security (TI processes ignore security). 

Hello,

Over the past several weeks and months, I had several interactions with IBM support on issues around exporting and importing data and elements, all in PAW.

Meaning that, an export does not happen, or it gives a CSV file with only the header line (dimension names). Or the export takes place but the import of that same file in the same cube on development does not finish. Sometimes the data is prepared but the file is not downloaded. Etc.

This topic is just to let you know that a number of these tickets lead to known defects and IBM are correcting them. First have a look at known defects before spending too much time or creating new support tickets.

Your best bet is definitely the Bedrock TI process - bedrock.cube.data.export.pro is specifically designed for large data exports and bypasses the UI limitations entirely, curious if this will help you out if you have not tried this approach. 

Hi good afternoon

Old thread, I know, but problems are always fresh.

AWS PAaaS here.

Is it possible to export a real large view? I mean - a view which potentially will generate a 2~4gb csv file? It looks that the 'export data' has some limitations on size, is possible to tweak them?

I looked for the maximumviewsize parameter on v12 in order to change it. I haven't found it under configuration tab on Admin. Is this parameter supposed to be shown? Is there some tricky way to show it?

Can I expect that real large views will export to csv?

Thanks

Márcio

Hi Wim,

The CSV export feature that we added is generating an MDX query and pushing the results of that query to a file.  One possible reason why a valid MDX query might fail is the MaximumViewSize parameter in TM1 being set too low.  We are working on some improvements to detect when the query failed and properly indicate the failure to the user.

We are still working on functionality in PAW books that will allow action buttons to be used to run a TI process and download the results.  The significant difference between using MDX and TI processes to export is model security (TI processes ignore security). 

Hello,

Over the past several weeks and months, I had several interactions with IBM support on issues around exporting and importing data and elements, all in PAW.

Meaning that, an export does not happen, or it gives a CSV file with only the header line (dimension names). Or the export takes place but the import of that same file in the same cube on development does not finish. Sometimes the data is prepared but the file is not downloaded. Etc.

This topic is just to let you know that a number of these tickets lead to known defects and IBM are correcting them. First have a look at known defects before spending too much time or creating new support tickets.