The Usage-based Optimization feature is alive and well within SQL Server 2005 Analysis Services (AS2k5). But by default, the QueryLog feature (which samples and records the queries sent to AS2k5 … Continue reading
Drillthrough functionality is quite different in AS2k5 vs. AS2k. The latter originally queries the SQL server directly when you want to drillthrough to the data. In AS2k5, the drillthrough data … Continue reading