Scheduled WebI Report / Document is not generating .csv format file for report data, but creating csv file with data providers (queries) data

Scheduled WebI doc is not generating .csv format file for report data, but creating csv file with data providers (queries) data and its behavior of Webi report from beginning. Meaning CSV format always generate complete data providers data not the formatted / calculated report data. Save As/Schedule to CSV will give the raw data of data providers; whereas, Save As Excel/PDF/Txt will give the report data.

You can achieve this when you upgrade to BI 4.1. In 4.1, scheduler has “Plain Text” which will give you report data as expected.

There are some workaround to convert Excel file to CSV using VB macro.

How to Convert All Excel Sheets to CSV With Macros

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.