Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Time Intelligence (Previous Year & Month to Date) Expand / Collapse
Posted Friday, July 6, 2012 3:30 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 10, 2012 10:37 AM
Points: 1, Visits: 9
Hello, this is a question regarding Time Intelligence in a PerformancePoint Dashboard.

In the data connection of my Dashboard Designer i have defined a Time Dimension.

I created also a Time Intelligence Filter to add these options:

Day: Today
Day - 1: Yesterday
Month: Current Month
Month - 1: Last Month
Year: Current Year
Year - 1: Last Year
Monthtodate: Month to Date
Yeartodate: Year to Date

This KPI was created with two records:

Actual: In which the measure is a regular sum measure of one of my columns of my fact table ([Measures].[Total Consumptions])

Previous Year: This is related to a calculated measure in my SSAS Cube with this formula:

(ParallelPeriod( [Dim Calendar].[Year - Month - Date].[Year] ), [Measures].[Total Consumptions])

These KPI are my two columns of a Scorecard.

In the Dashboard I linked the Time Intelligence Filter and the Scorecard.

The Scorecard works good except when I select Month to Date or Year to Date in my filter because my Previous Year shows an error.

I am sure my problem is in my Calculated Measure but I don't know how to correct it. Do you have any thoughts?

Thanks in advance,

Post #1326334
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse