Sort data in exported csv files

[#1]

Hi,

We're able to sort data in reports, but when we schedule the reports to create .csv files, the sorting is lost. Does anyone know how to apply sorting to scheduled exports without modifying the generated query?

Thanks,

Sue

[Former Member]

HI,

only data retrieving by query can be exported as csv i.e data as in Data tab.No logics/functionality applied in report will get export to csv .

if your backend is RDBMS , you can use order by clause in key figures and add the sort key figure as first column when webi query is created  to get the data sorted to webi report .

Or

you can save excel out of webi and then convert that as .csv using windows scripting .

thanks

[Former Member]

Yes this is correct.

Also when you use the Excel as output all the formatting and number  formatting those were applied in webi will not be available there.

[Former Member]

We're not using Excel, just uploading csv files into another system.  Is there a way to sort if you don't want the sorted field to be first? Or is you need the contents sorted by multiple fields?

We need to follow the requirements of 3rd party software vendors, so we have no control over the field order in the files.

Thanks,
Sue

[Former Member]

Also, when you say "If your backend is RDBMS , you can use order by clause in key figures", can you please tell me how to do this?  It's a SQL Server database.

I need to be able to sort without customizing the generated query.

Thanks,

Sue

[Former Member]

In your webi report you have to update the webi query by writing customized sql to put sort by clause into. Below is the screen show will help you in getting into customized SQL option in webi query.

[Former Member]

Yes, I wanted to do that, but my organization doesn't want us customizing the query.  We need to use the generated queries,

Thanks,
Sue

[Former Member]

Hi Sue ,

we can do the same in Universe .

If your org don't allow ,then there is no way I could think of.

I believe, even after you providing data the 3rd party tools can manipulate . Check from their end too.

Thanks