cancel
Showing results for 
Search instead for 
Did you mean: 

BEX Query not refreshed

Former Member
0 Kudos
473

Hi Folks,

I run a query. Result is returned. I keep Excel open for a while. Meanwhile a new load was done to the BW.

But when I press refresh it is not reflected in the query.

Is this because the query is cached ?  What settings to change? Or can I manually force a "refresh by passing cache" in BEX Analyzer?

Thanks for all replies in advance,

Axel

Accepted Solutions (0)

Answers (3)

Answers (3)

umashankar_poojar
Active Contributor
0 Kudos

Hi Axel,

         There is an option under 'workbook settings' named 'Refresh Workbook when opens'. Could you please check the option and try executing the report?

Let me know if it solve your problem.

Thanks,

Umashankar

Former Member
0 Kudos

How about making a workbook with a refresh button?

This will fix your problem

Cheers!

Former Member
0 Kudos

Hi Axel,

Since your query is open, it has hit the OLAP cache and hence the refresh didn't happen.

Sequence would be OLAP cache followed by aggregates if any, and then to underlying infocube/infoprovider.

I'm pretty uncertain whether you can control the way the system hits the infoprovider instead of OLAP cache, cos your filter condition is same before and after the data load.

Br,

H