Database Reference
In-Depth Information
AS CASE
WHEN
[Date].[Calendar].CurrentMember.Level.Ordinal
= 0 THEN "N/A"
WHEN
ISEMPTY(([Date].[Calendar].CurrentMember.PrevMember,
measures.[Internet Order Count]))
THEN NULL
ELSE
(([Date].[Calendar].CurrentMember,
measures.[Internet Order Count]) -
([Date].[Calendar].CurrentMember.PrevMember,
measures.[Internet Order Count]) )/
([Date].[Calendar].CurrentMember.PrevMember,
measures.[Internet Order Count])
END,
FORMAT_STRING = "Percent",
VISIBLE = 1 , ASSOCIATED_MEASURE_GROUP =
'Internet Orders' ;
3. Navigate to the
KPIs
tab, right-click on the
KPI Organizer
tab (found in
upper left-hand corner), and choose
New KPI
. Rename the KPI to
Internet
Order Growth
, and set
Associated measure group
to
Internet
Orders
.
4. Enter the newly created measure
[measures].[internet order count
growth]
as the
Value Expression
.
5. Define the
Goal Expression
for each level within the
Calendar
hierarchy
using the following MDX query:
Case
When
[Date].[Calendar].CurrentMember.Level Is
[Date].[Calendar].[Calendar Year]
Then .20
When
[Date].[Calendar].CurrentMember.Level Is
[Date].[Calendar].[Calendar Semester]
Then .10
Search WWH ::
Custom Search