COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: jessechan on 09 Sep 2019 11:32:30 PM

Title: Performance Tuning
Post by: jessechan on 09 Sep 2019 11:32:30 PM
The following is my expression:

1. [Paper -ve Yield1]/[ProductSales] = running time 1 min

2. average(total([Paper -ve Yield1]/[ProductSales]for[StoreNo],[YearMonth]) for [YearMonth],[MainStorePriceTier],[IsMcCafe],[Sales Range]) = running time 9 min


So, I dont know why it takes long time to run if I added "for" expression.
Is there any way the minimize the running time for expression 2?
Title: Re: Performance Tuning
Post by: manjunathgowda on 11 Sep 2019 12:45:39 PM
Hi,

why cant you create same logic in FM!!!
try it once, use it in report later