Table of Contents

Introduction
What's New In Prism?
Offline (PDF) Version of this Guide
Before You Start
Connecting To Data
Managing Data Sources
Browsing Data
Creating Prism Applications
Creating Reusable Groups and Filters
Creating Reusable Custom Measures and KPIs
Sharing, Distribution and Security
Exporting
Widgets
PrismFAQ

Creating Measures from a Dimension		Send comments on this topic.
See Also

Since Dimensions and Measures both correspond to fields in a table, you can easily use Dimensions to create new Measures. To create (or hide) a Measure directly from a Dimension, right-click the Dimension node in the Data Browser and navigate to Show/Hide Measures and check the Measure(s) you need.

The types of aggregations you can apply on a Dimension depend on the type of Members it contains:

Dimension Type	Icon	Applicable Aggregations
Text		Count and Count Duplicates
Numeric		Sum, Average, Minimum, Maximum, Count and Count Duplicates
Calendar		Count and Count Duplicates

Once created, the new Measure(s) will appear under the Measures node ( ) in the Data Browser. Typically, it will be named by a combination of the aggregation applied and the Dimensions’ name.

See Also