Blogs from Wise Owl on KPIs and hierarchies in SSAS tabular

How to create and use hierachies in Analysis Services tabular model

Posted by Andy Brown on 11 February 2016

Hiearchies allow you to group related columns together, to make for prettier pivot tables and happier users. This blog shows you how to create and use hiearchies in SSAS Tabular, considers whether they're worth it, and also looks at the specific case of how to model parent-child hierarchies.

How to create absolute and relative KPIs in SSAS Tabular

Posted by Andy Brown on 28 January 2016

You can create key performance indicators (KPIs) within Analysis Services Tabular, but there a couple of foibles that you need to be aware of, as shown by this blog.