How to compare months between years ?

#1

Hi,

I want to compare same months of different years (or even same quarters).
p.e. June 2004 vs June 2005 and show difference and %Change.
How this can be done for SQL Analysis server 2000 ?

Thank you
D.E.

#2

Check the parallel periods function. You can use it to calculate measure
values a year ago based on the currentmember.

Something like:
([Measures].[Value], [Time].currentmember) --- value od measure in current
time
([Measures].[Value],ParallelPeriod([Time].[year],1,[Time].currentmember)) ---
a year ago

MC

"D.E." <dimitris (AT) add (DOT) gr> wrote

Quote:

Hi,

I want to compare same months of different years (or even same quarters).
p.e. June 2004 vs June 2005 and show difference and %Change.
How this can be done for SQL Analysis server 2000 ?

Thank you
D.E.

#3

Thank you

"MC" <marko_culo#@#yahoo#.#com#> wrote

Quote:

Check the parallel periods function. You can use it to calculate measure
values a year ago based on the currentmember.

Something like:
([Measures].[Value], [Time].currentmember) --- value od measure in
current time
([Measures].[Value],ParallelPeriod([Time].[year],1,[Time].currentmember))
---
a year ago

MC

"D.E." <dimitris (AT) add (DOT) gr> wrote in message
news:%23QakE73QGHA.1728 (AT) TK2MSFTNGP11 (DOT) phx.gbl...
Hi,

I want to compare same months of different years (or even same quarters).
p.e. June 2004 vs June 2005 and show difference and %Change.
How this can be done for SQL Analysis server 2000 ?

Thank you
D.E.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to compare months between years ?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

How to compare months between years ? - 03-09-2006 , 07:37 AM

Re: How to compare months between years ? - 03-09-2006 , 08:21 AM

Re: How to compare months between years ? - 03-20-2006 , 05:05 AM