Displaying limited number of columns in csv output in BI Publisher

_IshanAgarwal

Summary

Displaying limited number of columns in csv output in BI Publisher

Content

Hi,

I have the requirement wherein the data model sql query is fetching around 15 columns from the table but in the layout we only want to display 10 columns. We want the output in CSV format so we have developed a etext layout for this.

But when we are generating the report in CSV format, we are getting all the 15 columns instead of just 10 columns which we have mentioned in the layout.

Can you please provide a way by which I can generate the report output in CSV format with only the limited number of columns. The data model is an existing one and we can not remove the unwanted columns from it, so we have to restrict the columns at the layout level only.

Thanks & Regards,

Ishan

Vani-R

whatever columns you specify in your etext layout, only those appear. Please check some samples which are available in BI Publisher installed directory. i.e. for ex:- C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\eText templates

Smanikandan65

csv output format doesn't pick it from template. It directly pulls from SQL data.

You were correct to use eText template to limit the number of columns.

If you use eText template then you have to generate the output in Text format and not csv.

Use "," comma delimiter in your eText template so that when you export Text output then you can manually change the .txt extension to .csv which will convert the output.

To make it automated, try bursting option and use "File" method to deliver the output and make sure you provide "output_name".csv extension.

Vani-R

whatever columns you specify in your etext layout, only those appear. Please check some samples which are available in BI Publisher installed directory. i.e. for ex:- C:\Program Files (x86)\Oracle\BI Publisher\BI Publisher Desktop\Template Builder for Word\samples\eText templates

User_MC37Q

Hi,

we require CSV report output in e-text template format. we tried manually but user wants automated. so we tried using File Method But getting error that output Failed.

Bursting query we used is :

SELECT  1 KEY,
       'FND LOOKUPS VALUES' TEMPLATE,
       'en-US' LOCALE,
       'ETEXT'  OUTPUT_FORMAT,
       'FILE' DEL_CHANNEL,
       'Desktop' PARAMETER1,
       'testUpload.csv' PARAMETER2

 FROM DUAL      

 Please let us know if anything needs to change in bursting query to make it work Or Is there other possible  ways to make automated other then two ways mentioned above . 

Regards

Rashmi Rao