Lessons in Cube Design. Does your cube support your users reporting needs?. Andrew Wiles: iT-Workplace Limited. Biography of an Olap Dinosaur. “Precambrian period - Practitioner” Data warehousing and reporting at Rolls-Royce (System W, APL, SAS PROC Summary)
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Lessons in Cube Design
Does your cube support your users reporting needs?
Andrew Wiles: iT-Workplace Limited
Reporting needs don’t affect database design
Systems analysis actively factors out
“derived data”. Only unique data fields
are captured within the warehouse.
If the user perceives that it is taking too long/is too complicated to use the tools provided then they will copy the data to Excel and create a new data island
The scientific foundation, both in terms of data and methodology, for a user-centred approach to design; knowledge and methods that aim to develop product and environment to fit the user’s capabilities and to promote user safety
The tendency, particularly when under time pressure, to choose the solution that is perceived to be the quickest and easiest.
Make the “right way” the “easy way”
Cubes should have at least 2 time dimensions!
Implement a Subject dimension instead
Just make life easy...
Re-usable, maintainable solution