Database Reference
In-Depth Information
FI g u R e 7-14
Connection dialog items and values tabs
The result is a fully functional filtering of a
PerformancePoint object using a PerformancePoint
filter. Other comparable connections are con-
figured in a similar fashion, and all support the
capability to pass values to and from different
dashboard objects in order to support advanced
capabilities.
Time Intelligence expressions and MDX queries
can be used as expressions within connection
formulas. When using Time Intelligence expres-
sions, the Simple Time Period Specification (STPS)
syntax is required for defining the expression. STPS syntax and examples were
provided earlier within this chapter's “Mapping the Time Dimension” section.
MDX queries used as expression will include monikers included within double
angled brackets. The following MDX expression example uses the MDX non-
empty values function combined with the Sourcevalue moniker to map to the
value being passed by a source using the connection:
FI g u R e 7-15
Analytic chart with year filter connection
NONEMPTY(EXISTS([Dimension].[Hierarchy - Dimension].[Level number].
members,<<SourceValue>>,'Measure Group'))
