Data Warehouse Engineering
Representation, Modeling and Design

Panos Vassiliadis and Timos Sellis. A Survey of Logical Models for OLAP Database. National Technical University of Athens. SIGMOD Record, Vol 28, No 4, Dec 1999.

Andreas Maniatis and Panos Vassiliadis and Spiros Skiadopoulos and Yannis Vassiliou. CPM: A Cube Presentation Model for OLAP. National Technical University of Athens. Springer Verlag DaWaK 2003, LNCS 2737, pp 4-13.

S. Luján-Mora and J. Trujillo. A Data Warehouse Engineering Process. In Proceedings of the 3rd Biennial International Conference on Advances in Information Systems (ADVIS’04), Lecture Notes in Computer Science, Izmir, Turkey, October 2004. Springer-Verlag.
S. Luján-Mora and J. Trujillo. A Comprehensive Method for Data Warehouse Design. In Proceedings of the 5th International Workshop on Design and Management of Data Warehouses (DMDW’03), pages 1.1–1.14, Berlin, Germany, September 2003.
Bhaskara, Reddy, Mool. A Probabilistic Multidimensional Data Model and Algebra for OLAP in Decision Support Systems.  Wonder Technologies Corporation. Proceedings IEEE SoutheastCon 2003.
E. Pourabbas, M. Rafanelli, Characterization of Hierarchies and Some Operators in OLAP Environment, Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
A. Mackenzie, M. Pidd, J. Rooksby, I. Sommerville, I. Warren, M. Westcombe. Wisdom, decision support and paradigms of decision making, Elsevier - European Journal of Operational Research 170 (2006) 156–171.

S. Luján-Mora, J. Trujillo, and I. Song. Extending UML for Multidimensional Modeling. In Proceedings of the 5th International Conference on the Unified Modeling Language (UML’02), volume 2460 of Lecture Notes in Computer Science, pages 290–304, Dresden, Germany, September 2002. Springer-Verlag.

S. Luján-Mora, J. Trujillo, and I. Song. Multidimensional Modeling with UML Package Diagrams. In Proceedings of the 21st International Conference on Conceptual Modeling (ER’02), volume 2503 of Lecture Notes in Computer Science, pages 199–213, Tampere, Finland, October 2002. Springer-Verlag.

S. Luján-Mora, P. Vassiliadis, and J. Trujillo. Data Mapping Diagrams for Data Warehouse Design with UML. In Proceedings of the 23rd International Conference on Conceptual Modeling (ER’04), Lecture Notes in Computer Science, Shanghai, China, November 2004. Springer-Verlag.

J. Trujillo and S. Luján-Mora. A UML Based Approach for Modeling ETL Processes in Data Warehouses. In Proceedings of the 22nd International Conference on Conceptual Modeling (ER’03), volume 2813 of Lecture Notes in Computer Science, pages 307–320, Chicago, USA, October 2003. Springer-Verlag.
Francisco Javier Lucas Martínez, Ambrosio Toval Álvarez A Precise Approach for the Analysis of the UML Models Consistency Enterprise Modeling and Information Systems Architectures 2005.
Sergio LujánMora,  Juan Trujillo. Physical Modeling of Data Warehouses using UML. Department of Software and Computing Systems University of Alicantenn.
Common Warehouse Metamodel (CWM) Extending UML for Data Warehousing and Business Intelligence. A Slide Presentation.
Olivier Teste, Towards Conceptual Multidimensional Design in Decision Support Systems, Université Paul Sabatier - IRIT/SIG, Toulouse, France
E. Bertino, E. Ferrari, G. Guerrini, A Formal Temporal Object-Oriented Data Model, University of Milano, University of Genova.

A. Mendelzon, A. Vaisman, Temporal Queries in OLAP University of Toronto, University of Buenos Aires

 

MDX - Multi-dimensional Query Language

Key Concepts in MDX Multidimensional expressions  Microsoft Corporation MSDN Library.
William Pearson   MDX at First Glance: Introduction to SQL Server MDX Essentials tutorial Series at Database Journal 2002.
Below are download files, save first, then view
Microsoft Office Web Component VB Reference
Microsoft Office Chart Component Help
Microsoft Office PivotTable Component Help
Microsoft Office Spreadsheet Component Help
Microsoft Office Spreadsheet Function Help
 

Text Book Support Pages

George M. Marakas. Decision Support Systems In the 21st Century 2/e. Companion Web.
Efraim Turban et al. Decision Support Systems and Intelligent Systems, 7/e. Companion Web.