cancel
Showing results for 
Search instead for 
Did you mean: 

xi31 SDK IWebiFormatOptions doesn't support CSV format for output format

Former Member
0 Kudos

Hello,

We are using the XI3 SDK for a custom java application. Our BOE version is 12.36. We are attempting to set the format for a Web Intelligence Report to .CSV. From the API documentation for Interface IWebiFormatOptions.CeWebiFormat, it does not appear that .CSV is supported. However the XI4 SDK for BOE version 4.0 does support it and we are able to set the format to .csv without issue. The constant value is 4 (see below) as documented in the XI4 Api doc.

public static final int CSV 4

So in our BOE 3 environment, we attempt to set the value (eg: setFormat (4) but this results in an SDKException:

"The argument has an invalid value 4".

We also noticed that when setting the default format setting to .CSV for the WebI Report, when retrieving the report, the default format returned is WebI, which is incorrect. Clearly CSV format is not supported. The corresponding SDK jar is: biplugins.jar

Does anyone know whether there is a corresponding hot fix or any work-around?

Thank you.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185028
Active Participant
0 Kudos

Hello Bobby.

A chart that shows the supported views in which it is possible to view DocumentInstances or DataProviders or Report data can be found in the Report Engine SDK Java API documentation. This is shown in the SupportedViews interface in the com.businessobjects.rebean.wi package. A link to this class for XI R3.1 can be found at the following link:

Link:[SupportedViews Interface|http://help.sap.com/javadocs/boe/xi31/re/en/com/businessobjects/rebean/wi/SupportedViews.html]

In this documentation, it shows that in XI R3.1, CSV is only available for ViewModeType = DataProviders and DataProvider.

As far as workarounds go... I'm not completely sure of any workarounds, but I suppose you could export to Excel and then from Excel, create a CSV representation of it. But that part would be beyond the scope of what SAP BusinessObjects has control over.

Regards.

- Robert

Former Member
0 Kudos

Ok, thanks for the confirmation.

former_member185028
Active Participant
0 Kudos

Hello Bobby.

You are correct, the .CSV format is not supported in XI R3.1. If you would like to suggest changes to a particular product version, you can submit your ideas to the SAP idea place website at the following URL:

Link: [Idea Place|https://ideas.sap.com]

The owner of the product will assess how popular verious ideas are when deciding what enhancements to include in future releases.

Regards.

- Robert

Former Member
0 Kudos

Thank you for the quick response. So this is the official word from SAP. .CSV is not supported in XI3.1 SDK and there is no work-around? I just want to make sure as I have a customer who is requesting the feature.

Thanks.