Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 13, 2011 at 11:40 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • Posted on Dec 14, 2011 at 10:00 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.