Banding

When building scorecards and dashboards with gauges and trend arrows it is often necessary to define different bands. A good way to do that is to use hidden measures or named sets in the cube that can be referred in more complex MDX statements. If the definitions are spread out in different web parts and formulas it could be a nightmare to change them.