Hi chris, I have a kind of similar scena

Written by sri. Posted in Comments

Hi chris, I have a kind of similar scenario here with performance issue. - I created dummy columns in my named queries like "calc memb profit", "calc memb profit2", "calc memb profit3" etc.. with value as 0. (I have defined these in named query SQL, not used new named calculation wizard) - Then I calculated values for these columns through scope statement like this SCOPE ([MEASURES].[CALC MEMB PROFIT]); THIS = ; END SCOPE; this way i have created many calculated measures... and referred them in other calculated measures for example SCOPE ([MEASURES].[CALC MEMB PROFIT2]); THIS = iif([MEASURES].[CALC MEMB PROFIT] > x,0,[MEASURES].[CALC MEMB PROFIT1]-[MEASURES].[CALC MEMB PROFIT]; END SCOPE; some thing like ths... Now these calculations are doing fine, but they take really long time while retreiving results.. (more than 5 mins some times) Can some one suggest how can improve performace for these queries.