Time Intelligence (Previous Year & Month to Date)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Performance Point » Time Intelligence (Previous Year & Month to...

Time Intelligence (Previous Year & Month to Date)

Rate Topic

Display Mode

Topic Options

Author

Message

gramos

Posted Friday, July 06, 2012 3:30 PM

Forum 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,

Gaby

Post #1326334

« Prev Topic | Next Topic »

Permissions