Can Thermometer Analytic Show Previous Prvious Period Date?

[Former Member]

Dear Sir,

I need to show two Goal using Thermometer Analytics in one view.

One is from the last period to before 11 months.

Another is from the last last period to before 11 months.

for example.

A1: Thermometer Period is from Sep 2007 to Aug 2008. Defult show Aug 2008

A2: Thermometer Period is from Aug 2007 to July 2008. Default show July 2008

Any one has idea?

many thanks.

[Former Member · Accepted solution]

Hi YouXuan,

I don't think you would really achieve this, specially if you want to use a single value analytic like the thermometer. Values being displayed on dependant on the calendar, and even if you create seperate metrics to achieve this, it won't work as they both will start displaying at the same period i.e latest period...

I would attempt something more creative in the way of displaying the one thermometer analytic showing the latest data, and then create a webi report to navigate to from the analytic i.e Period Comparison using the CI_PROBE universe, then I would pass information to the report from the analytic such as the Analytic Name and the Period... then the report will display the period and the offset period either in a bar graph, or line graph etc... so that the comparison can be viewed.

Just a thought...

Jacques

[Former Member · Accepted solution]

Thank you for your quickly reply.

Acturally I am thinking about Prompt + hyperlink soluation

But one question is may I do any calculate in prompt parameter

like

add_months($END_DATE$,-2)

Regards,

[Former Member · Accepted solution]

Hi YouXuan,

No, this will not work. This will only cause the calcualtion of the metric to be performed for a specific date based on other dates....

I had an example in another thread but can't find it... anyway.

Your source data looks like this..

Date Value

2008-09-05 15

2008-09-06 10

2008-09-07 12

2008-09-08 14

So you are now at 2008-09-09 thus EPM will run the last period 2008-09-08. On a daily calendar, this date is passed to the SQL defined for the metric... the WHERE clause is...

Date between @prompt('BEGIN_DT'...) and @prompt('END_DT'...)

So the result is ??? 14

In the case of what you want to do with the dateadd -2... for both BEGIN & END...

The same date is passed to the SQL and the result is...?? 10

Then you need to know that if date displayed 2008-09-08 with value 10 is actually 2 days back... not good, and the users will never remember this...

Rather try the nagivation part...