Answer»
- Measure groups : These measure groups can contain different dimensions and be at different granularity but so long as you MODEL your CUBE correctly, your users will be able to use measures from each of these measure groups in their queries easily and without worrying about the underlying complexity.
- Creating multiple measure groups : To create a new measure group in the Cube Editor, go to the Cube Structure TAB and right-click on the cube name in the Measures pane and select ‘New Measure Group’. You’ll then need to select the fact table to create the measure group from and then the new measure group will be created; any columns that aren’t used as foreign key columns in the DSV will automatically be created as measures, and you’ll ALSO get an extra measure of aggregation type Count. It’s a good idea to delete any measures you are not going to use at this stage.
- Measures : Measures are the numeric values that our users want to aggregate, slice, dice and otherwise analyze, and as a result, it’s important to make sure they behave the way we want them to. One of the fundamental reasons for using Analysis Services is that, unlike a relational DATABASE it allows us to build into our cube design business rules about measures: how they should be formatted, how they should aggregate up, how they interact with specific dimensions and so on.
|
