Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts - Any idea what is the work around for this? While adding the cumulative calculation field in an straight table, my dashboard performance is degrading (takes 5 to 10 Mins to refresh). Plz Help.. Let me know if any other info is required?
Thanks!
Bharani
Can you cross check the RAM for that application in your Task Manager? And indicate us whether how many records are there? And explain the formula you used ??
Hi i see as below in mu Task manager... I would have loaded around 15 Lakhs rows.. and the formula for calculating cumulative i used was
rangesum(above(total sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000, 0, rowno(Total)))
and also tried below formula as well
above(sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000)+sum({<AGED_DAYS_SUMMARY_ID -= {'[6] NO RECEIPT'}>}USD_INV_DOLLARS)/1000000
Only 15 L, Then it won't problem. Could be problem with RAM size only. What was RAM ??
8GB RAM..
I even wonder - Why 5-10 Minutes occupied to fetch data? Does this getting stuck or some thing new? Because my specification are very lower than your and i am maintaining some around 2 M - 4 M Rows in my report. May be marcus_sommer has some insights
For a While, Could you try this for me. I don't recommend to use -= but this may useful for you
rangesum(above(total sum({<AGED_DAYS_SUMMARY_ID = E({<AGED_DAYS_SUMMARY_ID = {'[6] NO RECEIPT'}>}AGED_DAYS_SUMMARY_ID)>}USD_INV_DOLLARS)/1000000, 0, rowno(Total)))
Ok Sure .. i will give a try on this and keep you updated..
It is not getting stuck.. it is taking time to refresh.. with that Green Sleeping line...
So does using a simple expression like this too take the same time?
rangesum(above(total sum(USD_INV_DOLLARS)/1000000, 0, rowno(Total)))
Also as you are using a straight table why not use the in-built feature for accumulation using the below expression
sum({<AGED_DAYS_SUMMARY_ID = E({<AGED_DAYS_SUMMARY_ID = {'[6] NO RECEIPT'}>}AGED_DAYS_SUMMARY_ID)>}USD_INV_DOLLARS)/1000000
Even this is taking same amount of time to refresh
Full Accumulation is not working when we have more than 1 Dimension.. Not sure Why..