OLAP Query Log and Subcube Vectors
User Rating: / 1
Written by Bill Anton   
Tuesday, 29 April 2014 18:15

The OLAP Query Log is a table that collects details of queries executed against the SSAS database. To be more precise, the records in this table represent the details of storage engine requests fired off by the Analysis Services engine during query execution - the often missed implication being that a single MDX query might generate multiple subcube requests. It's a SSAS server-level configuration option that I've already covered in a bit of detail in this post. The records in this table contain a field named Dataset which contains weird binary-looking string of 1's and 0's like what you see below:




XL Cubed