Documentation

This article provides an overview of selecting and analyzing data using metric sets.

Overview of the main elements of the data model and how the different types of files you can create work together.

This article describes the purpose of slicers, columns, rows, and measures in the Data Analysis Panel.

This article demonstrates how to use automatic joining and hierarchies to combine related data together.

Add relationships between tables to facilitate automatic join functionality and hierarchy creation.

The ability to add and modify data within the application is built-in, with data then stored in its warehouse data storage area.

This article shows you how to use the expand and collapse functionality to see more detailed breakdowns or step back to a summary view.

This article demonstrates how to create a ragged, unbalanced, or self-referencing hierarchy.

This article shows you how to format numbers, dates or times, or other data when displayed as text. Formats can be set in the metric set or by using placeholder keywords in a data visualization's properties.

You can set up states on a metric set to display some data differently when it falls within that state based on comparisons with other values.

This walkthrough shows you how to add a period over period (or date offset) comparison.

This walkthrough shows you how to apply different filter values to a measure and compare the results together.

A contextual measure lets you enter your own values to augment existing data in your metric set.

This article shows you how to add a count measure to display the number of records or values behind each row or column.

This article explains how to group multiple values into one when working with a metric set.

Filter your metric set to display the top or bottom 'N' number of items, or group the smallest or largest items together into an 'other' group.

Each project includes a time dimension ready to use with your data for filtering, sorting, grouping, and drill down. You can customize it or create new ones.

This article shows you how you can handle null values and missing data in your metric sets.

How to use a custom total calculation in measure subtotals or totals.

Auto-generated metric sets and data cubes allow you to analyze any data quickly from any screen, then optionally promote your work for reuse and sharing.