I should be able to discretize (bucket) any of the measures dynamically. and the discretized labels should appear in the dimensions. So there should be something like 'calculated dimensions'.
Hi Will, Thanks for the review. There are many articles on Discretisation written by prominent Tabular Gurus. Being able to dynamically bucket aggregate data is of vital importance. Even in SSAS - Multidimensional this was available, but the buckets could not be controlled by a user interface. For example if I want to know all my customers who purchase in the range 0-1000, 1000-2000, etc.. it is not possible to do this without a lot of acrobatics. However bucketing leads to 'exception' reporting which is the most important way in which exceptions can be highlighted. We did some work on this, for example if a customer has purchased less than previous year, we tagged as 'Reduced', if he has purchased more, we tagged as 'Increase' etc.. But these tags come in the data area of the pivot. What I need is a mechanism by which such tags can be available in the dimension area. The discretization should not be linked to any specific dimension, but it should work across any selected dimension. let me know if you need more details on this.
