So I was in this meeting at a client site yesterday, we talked about the progress of their DW upgrade and the dashboard/scorecard implementation that my consulting firm is tasked to do. During our discussion, one of the IT folks, actually a contractor indicated that the current DW (SQL Server 2000) hasn't an OLAP layer, namely cubes. All user reporting needs are satisfied through the relational DW database. As part of his assessment, he is putting together a series of proof-of-concept cubes based upon the data sitting in the current DW. Everything sounded good until we got further into our meeting and the following points were made by the other participants.
- Performance with reporting is not an issue.
- All canned reports are created in Excel and are being pushed directly to the users.
- All users are "causal." There are no "power" user requirements such as more complex analysis or ad-hoc query.
- No one in-house knows anything about cubes or multi-dimensional concept.
My inclination here is to ask, at least in the back of my mind, how much value the OLAP layer provides in this scenario. I can see the POC as showcasing the potential value the OLAP layer may offer in the distance future. Other than that, we are adding a whole new layer of technology to the DW framework which requires additional skill sets and resources to support and maintain. I maybe missing a bigger picture here but I am not seeing the ROI on this endeavor.