Topic
  • 3 replies
  • Latest Post - ‏2013-02-07T19:54:28Z by DanielWagemann
SystemAdmin
SystemAdmin
1959 Posts

Pinned topic Performance issue when using Lag or parallelPeriod function in chart

‏2013-02-07T07:58:51Z |
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.

BTW, I use cognos 10.1.1

The code for "Last Period" => tuple(lag(currentMember(Sales Actual Shipment.Time (Month).Time),12),Shipment Amount)
Updated on 2013-02-07T19:54:28Z at 2013-02-07T19:54:28Z by DanielWagemann
  • DanielWagemann
    DanielWagemann
    850 Posts

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

    ‏2013-02-07T14:56:45Z  
    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.
  • SystemAdmin
    SystemAdmin
    1959 Posts

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

    ‏2013-02-07T16:27:30Z  
    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.
    Hi, you can use the standard sample model to test it. Once, you change the 'Use Local Cache' of your query to 'No'.
    You will find that it's very slow to use lag or parallelPeriod function in chart.
  • DanielWagemann
    DanielWagemann
    850 Posts

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

    ‏2013-02-07T19:54:28Z  
    Hi, you can use the standard sample model to test it. Once, you change the 'Use Local Cache' of your query to 'No'.
    You will find that it's very slow to use lag or parallelPeriod function in chart.
    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.