Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

6.9. Summary

You traversed the Cube Wizard for a second time in this book, but also at a different level of granularity and hopefully with more understanding of what was going on. You learned how to create calculated members and set properties concerning the display of those members; for example, different color foregrounds and backgrounds. And finally, you learned how to create and browse perspectives and translations. In the real world of business, you will have additional enhancement requirements to meet after running the Cube Wizard. These requirements may include creating calculated members on dimensions, creating cube scripts containing complex MDX expressions to meet your business needs, and adding Key Performance Indicators (KPIs), which will graphically represent the state of your business in real time. The Cube Designer contains additional tabs for KPIs and Actions. These features help enhance your cubes for business analysis. In addition to that, the Cube Designer helps in partitioning fact data, and defining aggregations, which in turn help you achieve improved performance while querying your UDM. These are covered in Chapter 9, with additional coverage in other chapters as well. In the next chapter you learn how to manage your Analysis Services databases using the SQL Server Management Studio.