Data provider with uniserve based on Excel is not refreshed.

[former_member203533]

Hello Guys,

I'm here again beucase sometimes BO issues are really tricky, and hard to understand its behaviour.

So here we go, the scenario that I have is:

• BO Version: BO4 SP1
• A connection was created based on a excel sheed (JavaBeans 'driver')
• Then a (stored procedure) universe was created with this connection.

    

• It is possible to use the universe in a Web Intelligence report, data appears. So far, so good.

But the problem:

After the report is created and the data is captured from the data provider, the data from the excel will never be refreshed again.

I mean, we push the "refresh" button on the report, but the old data remains there.

Even if I delete the excel file, the old data from the very first execution will remain there.

I was thinking about some parameters that manage cache in both services (servers) and Universe, but I found none.

In fact there is no possibility to change parameter for that stored procedure universe: the fields are disabled.

So, do you know how can I force the report to be refreshed when I'm using a stored procedure universe?

Note: I have the same behavior in both stand-alone and client-server universe.

Thank you very much in advance.

Marcos

Message was edited by: Marcos Morais

[former_member203533 · Accepted solution]

Hello Guys,

Maybe someone will face this issue in the future, so I will share the solution.

For me does not make sense, but the "Connection Pool Mode" must be "Disconnect after every transation" when you are using a universe based on Excel and if you want it to be refreshed on demand without any delays.

Cheers