Drillthrough to Relational in SSAS 2005
I was asked twice recently about the new drillthrough architecture in MOLAP in SSAS 2005. For some business reasons, they wanted to implement the old drillthrough style.
Unlike 2000, if MOLAP partition is used, the drillthrough in 2005is no longer getting the data directly the relational model. Instead, the new style, the drilllthrough detail information must include in the cube. There is no more SQL statements sending over to the datasource to retrieve the detail data. if ROLAP, the drillthrough will query the datasource directly.
Tags: partition, drillthrough