Displaying limited number of columns in csv output in BI Publisher
SummaryDisplaying limited number of columns in csv output in BI Publisher
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.