Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> SQL Server Analysis Services

Comparing 2005 with 2004 YTD

Hi,

I would like to compare current YTD (2005) with 2004 YTD, how do I do that using MDX? ParaLLELPERIOD (Year) and PERIODSTODATE(Year) ?

[140 byte] By [Larra] at [2008-2-24]
«« Intrasystem transportabilty of serialized database ?
»» ACTIVATION CODE FOR SECOND INSTALATION
# 1
I am not an MDX expert, but I believe something like this should resolve it.

(parallelPeriod([Accounting Week Calendar].[Accounting Year]),[Time Series Analysis].&[1])

Time Series Analysis is a dimension itself, with one record with a field called OLAP (it can be anything) and the value is set to 1.

Thanks
Sutha

SuthaThiru at 2007-9-9 > top of Msdn Tech,SQL Server,SQL Server Analysis Services...
SQL Server
SQL Server Analysis Services

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified