Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Displaying limited number of columns in csv output in BI Publisher — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Displaying limited number of columns in csv output in BI Publisher

Received Response
33
Views
4
Comments
edited Sep 11, 2019 5:18AM in Oracle Analytics 4 comments

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!