So had a bad today and need to vent…..
When doing a project there are a few things we do as a matter of course and are what we call Optimal Practices (as part of our OptimalBI company), these include:
- Reconciling each level of the data warehouse to ensure data consistency
- Use of symantic layer for all end user reporting
- Regular user workshops throughout development to ensure good user engagement and feedback
- Use of Wiki to enable interactive documentation
- Monitoring of the Production and Development servers to monitor and report performance and assist with capacity planning
So with the last one in mind we purchased SAS ITRM to enable us to monitor the SAS Servers on one of our projects.
We run a multi (n) tier architecture, so dedicated Web tier, Metadata Tier, Application Tier (Workspace/Stored Processes Servers) and Data Tier.
So ITRM being a SAS Solution, based on SAS 9.1 and utilises DI Studio and Web Report Studio, multi tier install here we go.
We apparently no.
It seems ITRM uses a custom metadata repository and as such required Web Report Studio etc to be installed/deployed separately.
In addition it comes with some prebuilt DI Studio jobs to read the adapters/log files (i.e SAR,BMC Patrol) but you have to build your own Performance Data Mart and Reports (in version 3.x that is as the old version 2.7 had lots of these out of the box).
So best practise is apparantley to install it on its own server and then build your own.
Not impressed.
Here end the rant
ps. as per my previous post I explicitly deny permission for Microstrategy to reproduce any content from this blog
pps. as if they would be reading my blog!


Recent Comments