Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 69

multiple fact tables, the cube will include a separate measure group for each
of them. Let's only check FactResellerSales and click on Next :
6. You can choose the measures you wish to include in the cube on the follow-
ing screen. The wizard automatically preselects all the numeric columns, but
this may or may not be the desired outcome. For example, although Revi-
sion Number is indeed a numeric column, exposing it as a measure would
not add any value to reseller sales analysis, so let's uncheck it. The revision
number is not additive; also, we cannot add revision numbers across orders
to obtain any meaningful value. However, metadata items such as revision
number (or invoice number) can indeed be useful for reporting and could be
included in fact dimensions, as you will learn later in this chapter.