Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

setFilter hitting the DB

Hi Gurus,

I was under the impression that when we render the data once from Database (DB), using "setFilter" selects the data from the posted value and does not hit the DB again.  But when I run a trace on HANA and execute my code, I see that it does hit the DB to fetch the same values again. 

In Datasource Initial View, i have set all the values to fetch data from result set and not hit the DB again.  Has anyone checked into this issue yet or we are just believing what SAP documentation says?

Love to get your comments on this!!


Former Member
Former Member replied

Hi Mustafa,

That might be because of the OLAP cache on the BW side, for design studio this is transparent, it will send the query to BW anyway (no cache here), then BW will decide from where it will send the results back (BW OLAP cache might be involved here).

Best regards,


1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question