Pinned topicPerformance issue when using Lag or parallelPeriod function in chart

‏2013-02-07T07:58:51Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

Dear all,

I create a query to compare the value for each month of current year and last year.
I use lag function to get the same month of last year.
I found that it work fine when I use crosstab to display result.
But, the performance is slow when I use line chart to display result. (as attached)
After check, it's lag function to slow down chart display. Even I change the lag function to parallelPeriod function.

Does anyone have same problem as me? Do we have alternative way to solve this performance issue.

Attachments

Re: Performance issue when using Lag or parallelPeriod function in chart

‏2013-02-07T14:56:45Z

This is the accepted answer.
This is the accepted answer.

It's kinda cool what you are doing here. I have created a similar report and I do not exprience any performance issue when introducing the chart. Which makes sense to me as the chart and crosstab would create a very similar query.

Could you please post your actual spec and confirm which data source you are using.
Also, if you could generate and post the MDX from Report Studio tools menu for the crosstab and chart query.

Re: Performance issue when using Lag or parallelPeriod function in chart

It's kinda cool what you are doing here. I have created a similar report and I do not exprience any performance issue when introducing the chart. Which makes sense to me as the chart and crosstab would create a very similar query.

Could you please post your actual spec and confirm which data source you are using.
Also, if you could generate and post the MDX from Report Studio tools menu for the crosstab and chart query.

Sorry, when I create the same crosstab and chart based on the same query, I still get instant results, regardless of what the query cache setting is set to.
How often does your data source get updated to warrant turning the query cache off?

If you would like me to help further, please post the items requested earlier.