This course focuses on building an OLAP cube with drilldown hierarchies so that the user can dynamically analyze the data, then surfacing the cube in Enterprise Guide. Much attention is given to knowing and understanding the data tables and building the hierarchies from them. The functionality of the cube can be extended by using the MDX language (Multi-dimensional Expressions).
3-4 Days/Lecture & Lab
This course is intended for Data Modelers or people who:need to create dynamic reports with drill-down capabilityneed to maintain hierarchiesperform the role of Data Modeler