As seen in the previous recipe, Analysis Services supports attribute-based histograms by design. All it takes is a distinct count measure and we're set to go.
This recipe illustrates how to implement more complex type of histograms — histograms over non-existing hierarchies.
The complexity comes from the fact that the hierarchy on which we'd like to base the calculation on does not exist. That's a very big issue when a multidimensional cube is concerned.
OLAP cubes operate on predetermined structures. It is not possible to build items on-the-fly. In other words, it is not possible to create a new hierarchy based on a calculation and use it the way we would use any other ...