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)
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