Summary

As you have seen in this chapter, Analysis Services has the ability to easily model complex business relationships and measures. A lot of the functionality is also available either through simple-to-run wizards or through templates that will help you with most of the code. You have also seen the benefit of perspectives that can help users by simplifying the cube structure. Translations is a useful feature in international environments where the end user needs to be able to browse the cubes in different languages. You have extended your cube using actions in order to either drilldown in the cube or even access the relational database or a line-of-business application. Lastly, you have created a budgeting solution using the write-back capabilities in Analysis Services.

In the next chapter, we will have a look at how security works in Analysis Services and how you can build a security model that is easy to maintain.