Geeks With Blogs
James Rogers BI from the trenches... February 2008 Entries
Every Data Warehouse Solution Needs one of these
I have had the pleasure (or pain, depending on your point of view) of working on several large data warehousing projects over the years and I have found that there are many key ingredients to a successful project. Most of these are well documented by Ralph Kimball and Bill Inmon so I won't reiterate those here. However, as an architect I have come to really value the role of the Business Analyst in these projects. It is a no brainer that the Business Analyst is the go-to person for requirements but ......

Posted On Wednesday, February 13, 2008 10:45 PM

Performance, Named Sets, Calculated Measures, PerformancePoint and ProClarity
Many legacy Analysis Services (or OLAP Services) implementations use ProClarity as a querying tool and publishing framework. The server infrastructure of ProClarity allows crafty implementers to push much of the customization in KPI’s and additional measures into the “Presentation” layer of the infrastructure. This is easier to manage and change in many cases than creating named sets and calculated members in the cubes as this generally takes a SSAS administrator. With Microsoft purchasing ProClarity ......

Posted On Wednesday, February 13, 2008 10:15 PM

Copyright © James Rogers | Powered by: