Context Aware And Customised Drillthrough
Recently, I have just come across a requirement to make a drillthrough to return better column names. This drillthrough would be generated from an area in the Pivot Table that is connected to SSAS Multidimensional Model. Then, the extension to this requirement is to create a separate drillthrough that filters the dataset to be context aware. As an example, if a user accesses the drillthrough on "Quality Reason" measure for Internet Sales, it should provide all the internet sale transactions that are associated to "Quality Reason" sales.
Read more...Tags: design, drillthrough