We have been building OLAP cubes over SunSystems for some time now and more and more the realisation dawns in people's heads that process and performance are just two different ends of the same spectrum. I have blogged on this topic before and won't torture you with any more on that (yet).
What I will do is offer interested parties a free - yes, that's right, gratis and for nothing - SQL script that you can run against your SunSystems MS SQL database to build a little Microsoft Analysis Services OLAP data warehouse.
You will then need a snazzy viewer to allow you to look at your data in a way that you have never seen it before and truly turn it into "information". We recommend Executive Viewer - it is one of those user display tools that just blows people's socks off - and it does exactly what it says on the box - lets executives view their data in a browser (without doing any damage) and allows them to dream up almost any spontaneaous (crack pot) way of wanting to view the data without having to come back to system support to get a report written.
So - do you want a free SunSystems cube builder? What I will need from you is your company name, an email address and your SunSystems serialisation number, then I can make the magic happen.
By the way, this comes with no formal support because once you start tinkering with the script (and I know you, you will!) all bets are off - if you break it, call somone who cares! (I'm not that heartless actually, come back to me and I can give a little help around the edges).
09 Nov 2006 update - While I'm at it, I'll give away a Time @ Work cube builder for those interested - same deal as with the SunSystems one.
Respond to this post in confidence - I won't publish the recipients.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment