After completing this chapter, you will be able to:
Assemble expressions employing constants, tuples, members, and sets
Explain the concept of expression context
Successfully employ context to build dynamic expressions
Although Analysis Services is highly efficient at storing and retrieving values, the ability to calculate new values—values difficult to derive from the relational data warehouse—is where Analysis Services really shines. Expressions provide this capability.
The subject of expressions is very broad in nature. In this chapter, you focus on a particular type of expression known as a calculated member. Calculated members are frequently employed for calculating new values in Analysis Services cubes and ...