In the previous chapter, you learned how to write simple MDX statements; in this section, we will use that knowledge to extend the
FirstCube cube that you have worked on. As covered before, MDX is a language that is used when querying cubes, but it can also be used to define objects in your cube.
In the cube designer you a have tab called Calculations; here you can add different types of calculations such as measures, named sets, and time calculations.
To create a simple calculated measure such as a margin (the difference between revenue and cost) calculation, perform the following steps:
[Margin]and add the following ...