…brew your own Business Intelligence

Archive for April 2014

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 […]

Read more

SSAS Memory Configurations for Common Architectures

Earlier this week I was working with a client to configure the server-level memory configuration properties for one of their SSAS servers and the discussion drummed up enough thoughts to prompt this blog post. Below are the primary SSAS server-level memory configuration properties (along with the descriptions from TechNet BoL) […]

Read more