Skip to main content

Model Metadata

Tabular Analysis Services models and PowerPivot models have the ability to be queried from multi-dimensional and tabular clients. This feature displays the metadata in a Tabular format and when you double-click or drag items off the metadata pane onto the query pane you will get the tabular name format.

As of version 2 Hierarchies and KPIs are supported. In tabular terms a hierarchy is basically a collection of levels and a KPI is a container which holds 3 different measures (one each for Actual, Target and Status) there are no special DAX functions for dealing with hierarchies and KPIs.