Exporting large staging table as a CSV without admin access

ltomsu

Hello All,

I am currently facing the following challenge:

We are generating a drill-through that results in a table in Staging containing approximately 100,000 rows. I need to make this data available to a user as a CSV file. However, the user does not have access to EPM administration, and we are operating in a Cloud environment.

Initially, I considered using the AE function RepositoryCreateFile to save the result as a repository attachment. Unfortunately, it seems AE encounters difficulties handling strings of this size.

Creating a relational AS Studio report is also not a viable option due to the 2 million values limitation.

Is there any alternative approach, such as using an OS workflow or another method, to generate the CSV file from the staging table and make it accessible to a user who cannot export the table through EPM administration?

I would greatly appreciate your insights and suggestions.

Thank you,
Lukas

Robert Thomas

We've had success exporting large tables by putting the rows into a StringArray and only when all rows have been read to put them into a single string and then use RepositoryCreateFile.

Inside the row loop:
string sDetailRow = StringJoin(saColumnValues, sDelimiter);
Append(saDetailRows, sDetailRow);

When all rows read:
string sExportData = StringJoin(saDetailRows, "
");