I want to show a count of orders banded into different amount ranges., ie <1k, 1k-5k,6-10k, etc. The cube (SSAS 2008 r2 enterprise) has a reporting currency dimension so I need to do the banding dynamically as each order amount
is converted into the selected currency before being grouped into the appropriate band. I also want to filter by other dimensions such as product or region. Given this, it is not viable to do the banding calculation in the underlying
data source and I assume a calculated measure is most appropriate.
Your help on what this would look like would be greatly appreciated.
View Complete Post