Skip to Content
0
May 29, 2018 at 07:24 AM

In WebI, exporting to csv fetches all the columns from query.

346 Views

Hi Experts,

We using SAP BOBJ 4.2 SP3 Patch 12. When i export the report to csv with data selection, it brings out all the columns from query which are not in the report.

Initially, when we export to csv with data selection, we got the columns only used in reports without considering the filter. To resolve this, i tried to apply filter in report query, then i got below error

Error:

The following database error occurred: Failed to execute MDX query. Reason: Invalid MDX command with UNSUPPORTED: > 50 CHARACT.. For information about this error, please refer to SAP Knowledge Base Article 2054721 on the SAP Support Portal. (IES 10901) (Error: INF )

The workaround for above error is to have only 50 characteristics in a query. So i have reduced the objects to 50 and executed the report. This time when we export to csv, it is fetching all the columns from query. Kindly share your thoughts on this.

Thanks

Gowrishankar