on 05-29-2015 4:05 PM
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:
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.