This project has moved and is read-only. For the latest updates, please go here.

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.

metadata.png

Last edited Dec 4, 2014 at 3:11 AM by dgosbell, version 3