locked
Cache Reports with multiple Multi Params RRS feed

  • Question

  • Hi All,

    We have few reports with 50 K records with multiple Multi Parameter reports.

    Caching: We have enabled caching for the reports where ALL the options are selected by default. So, the initial load of the report is quick.

    Problem: As I said there are multiple multi valued parameters, the reports slows down when we change any of the options (Parametr values) in the parameters and click on 'View Report' button. Configuring Cache for ALL combinations of ALL Parameter Options IS NOT a solution as the options of the Parameters is dynamic :-(

    Is there a way to fix this problem?

    Thanks in Advance,

    Prawin


    Prawin

    Sunday, June 16, 2013 6:20 PM

Answers

All replies

  • Hi Prawin,

    As per my understanding, you can create multiple linked report, and change the default parameter value of it and then enable caching for the linked reports.

    Reference:

    Hope this helps.

    Regards,


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Charlie Liao Thursday, June 27, 2013 1:23 AM
    Saturday, June 22, 2013 3:38 AM
  • Hi Charlie,

    Thanks for the reply.

    Yes, it is possible, but, the I have 5 dropdows with each drop down options are dynamic so definitely configuring cache for different combinations is practically impossible :-(

    So, any alternate solutions?

    Thanks,

    Prawin


    Prawin

    Saturday, June 22, 2013 4:06 AM
  • Hi Prawin,

    If this is not you want, I am afraid there is no other approch to work around this issue.

    Thank you for your understanding.

    Regards,


    Charlie Liao
    TechNet Community Support

    Saturday, June 22, 2013 5:45 AM