I'm trying to understand what forms the value expression of a KPI can take.
All the sample I've seen so far have been very simple, like a simple measure
expression, e.g.
[Measures].[Internet Sales Amount]

I've also had success specifying a simple tuple, e.g.
([Measures].[Internet Sales Amount], [Product].[Product Model Lines].[Model
Name].&[Bike Wash])

But what if I want something more a little more sophisticated? For example,
what if I want to include two model names in the product slice - say, [Bike
Wash] and [Cable Lock]. Or include a range of dates. Or a sliding date
window (say, the previous month). Any examples of more sophisticated KPI
value expressions available somewhere?

According to Mosha's blog, one consideration for KPI MDX expressions is
that the calculated measures created for KPI's will be executed after
all other calculations in the MDX Script. Therefore, to retain control
over order of execution, the intended KPI calculation can be created in
a separate MDX script calculation:

http://www.sqljunkies.com/WebLog/mos...005/12/31.aspx
Therefore, one can (perhaps even should) create all the calculations in
the MDX Script (where they really belong in the first place), and
resolve all the precedence rules there using power of MDX Scripts.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***