Sage MAS Intelligence

[rveuger]

One of our clients is using SMI and hoping to utilize it as a replacement to FRx.  We have applied the Performance Update and we are not seeing a significant increase in performance when running against a large set of data.

We are running the standard "FRinancial Reports 2-0 (MAS)" report..  The report is taking an hour plus to generate.  Files sizes are below:

GL period posting = 316,080 records

GL Budget Detail = 314,933 records

GL Account = 4,516 records

The workstation is Windows 7 64-bit with 8GB of memory

It appears to move throught the intial steps of the execution in less than a minute but once it starts to execute  the query...it just seems to take forwever.  It has been running for an hour+ and still not done.  This just seems like a CRAZY long time.  I must be missing something...do we need to modifiy containers to limit the fical year data being cached?  SOme other settings? Any pointers are appreciated!!

Thank you,

Rebekah Veuger

Sabre Solutions

San Diego, CA

[accountingnerd]

Hi Rebekah,

Check out Craig Juta's post on his blog about creating aggregated reports. His tests show a significant decrease in time for rendering data in Excel -- somthing like 90 minutes of render time reduced to 6 minutes.

Good luck!

[stephencoull]

Hi Rebekah,

As SMI pulls through every GL account at a balance level, some people have had some success in running the aggregated version of the financia reports which have been included in a PU or can be found on Craig Juta's BI Blog at http://bxintelligence.wordpress.com/2011/03/16/mas-90200-aggregated-financial-report/

Hope this helps.