leverage caching

[Lesio]

Wonder if there is a possibility to leverage caching in the following scenario:

In the model:
Sales Person -> Branch -> Region -> Channel

Report template has
- Channel and metric (on the channel level)
There is a prompt on Sales Person

Let's say John B. and Tom P. both belong to channel ABC.

I run the report for John B and I get the metric calculated for channel ABC, SQL goes against the warehouse

Then I run the same report for Tom P. and I want to be able to get this report from cache, since there is already report there with the metric I need for the same channel.

How can I do it ?

 

[reisw]

I don't think you will be able to pull it from cache the way you are trying to do it. By selecting the Sales Person you are caching at that level. And since the selections are different that is two different caches. If you had them select the Channel instead then you would have no problem. You could also cache the entire report and then have them page by Sales Person or use a View Filter.