setFilter hitting the DB
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!!
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).