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

Issue refreshing a report with Excel as the dataprovider in Infoview

Hi All,

We are using BO XI3.1.

I am designing a report based on data from Excel sheet. i'e I am using Excel sheet as a dataprovider.

The report in Deski or webi client works fine. But when I am trying to refresh the report from Infoview BO is throwing an error.

It says "The document contains one or more local data sources that can not be refreshed " (Err msg from Webi)

Deski Err msg: "Setprompts failed - The following dataproviders have not been succesfully refreshed DMA0007"

BO is installed on Solaris 10. And the excel data provider is on my local machine.

Please let me know if any one has some idea?

Thanks,

Naveen

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2009 at 07:24 AM

    Hi Naveen,

    When exporting a WebI document to Infoview, no link with personnal data providers like Excel files or text data files is kept. Data from these local data providers is then maintained in the report as static data, refresh from personal data providers is currently only supported with WebI Rich Client, hence the behavior you have (and also reason why you cannot create a document from a PDP in Infoview WebI).

    Hope that helps,

    David.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 10, 2009 at 07:55 AM

    Hi Naveen,

    You cannot use excel-sheet as a data source in the infoview.

    For using an excel data you need to create a universe on the top of the excel sheet. Also the excel sheet needs to be store at server.

    or

    You can create a mdb file very similar to e-fashion universe at the server and then build the universe on top of it.

    Regards,

    Rohit

    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.