Report Portal

OLAP Query Log and Subcube Vectors

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:

Read more...

Tags: management

 

2007-2015 VidasSoft Systems Inc.