BY TOPIC▼
SQL SERVER BLOGS▼
SSAS TABULAR BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on KPIs and hierarchies in SSAS tabular
Showing blogs 1-2 (out of 2)
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.