cancel
Showing results for 
Search instead for 
Did you mean: 

OLAP Cache for Query Performance

Former Member
0 Kudos

Hi Experts,

I have below 2 Questions before we implement OLAP Cache for our Queries:

1) We have 15 imporatant queries - which do NOT have any variable/selection screen.

(question here is will it work for those kind of queries which dont have any selection screen/ variant ? ) --> client wants to prime the cache for few queries which dont have variable screen.

In this case, say if data is later filtered on any CHAR , will it take the data from Cache?

2) I have a query which initially will have few characteristics in the drill down when we first execute and users would be drilling down on many other characteristics after that. So if I want to fill OLAP cache for this query then what is the best way so that each drilldown in the query gets data from cache.

Thank you,

-Su

Accepted Solutions (1)

Accepted Solutions (1)

former_member209032
Active Contributor
0 Kudos

Hi,

FOr question 1 : Yes. For question 2 : In the query properties in RSRT set the read mode to A for your queries and then fill the cache.

Regards,

Raghavendra.

Former Member
0 Kudos

Hi Raghavendra,

Thanks for your response.

For first Question, Do you mean , even if we do not have any Selection varaibale on Query--we still can fill OLAP cache for it for its all values (i.e. No selection means "*") ?

If this is the case, then what we need to defile in General Precalculation (Variable assignment) while creating a new setting for the query.

Thanks,

-Su

former_member209032
Active Contributor
0 Kudos

Hi,

I have not tried precaching for queries with no selection screen, but what i think is if there is no selection screen then you can neglect variable assignment while creating settings for your query in IB. If it shows any error then plz let me know.

Regards,

Raghavendra.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

If you want change the cache setting for all the queries... Then goto tcode RSDIPROP ..

change the options depend on Clients requirements..

If you want to do it for individiual queries then you can change it in RSRT.

Regards,

Ranganath.