Hi

I am using Named Set in Analysis Server.
For Last 12 Months, I am using this Function "Tail([Issue Date].[Issue
Month].members, 12)"
I need for Current Year and Previous Year. Please Help me in how to create
Named Set


Thanks in advance

Srinivas

Assuming that [Issue Date] is a Time dimension with a [Year] level, then
try YTD() and ParallelPeriod():

Months to date for Current Year:
Same Months to date in Previous Year:
Tail([Issue Date].[Issue Month].members).Item(0)))

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deeepak,

Thanks for the help.

Months to date for Current Year did work.

But Same Months to date in Previous Year: did not work. it is giving error

Formula error - the function does not support ragged hierarchies - in the
ParallelPeriod function

Bascially , I need data for Previous year( 2004).

Please help me..

Thanks in advance.


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Then can you explain the design of the [Issue Date] dimension hierarchy
- is it not regular?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

Thanks for the reply.

[Issue Date] is a time dimension. it has 2 levels, One is [Issue year] and
other is [Issue Month].

When we need for Current Year, we use this formulae in named set.
"YTD(Tail([Issue Date].[Issue Month].members).Item(0))".
It returns 2005.

Now, what i need is for previous year. it should return me 2004.

Please provide me formulae which returns 2004.

Thanks
Srinivas


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Hi Deepak,


Thanks for the help.
Dimension [Issue Date] is a time dimension . the values range from 1980 to
current date.
It has 2 levels. One is [Issue Year] and other is [Issue Month]

when we want current year, we pass this formulae "YTD(Tail([Issue
Date].[Issue Month].members).Item(0))"

Then it returns 2005.

Now i need for Previous year. It should returns 2004.

Please provide me formulae which returns 2004.

Thanks

Srinivas


"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

If you need all months of the previous year, then:

[Issue Date].[Issue Month].Members).Item(0),
[Issue Date].[Issue Year]).PrevMember.Children

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

I just need Previous Year. ie 2004.
Please help me.
Thanks
Srinivas

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote

Previous year (if it exists) should then be:

[Issue Date].[Issue Month].Members).Item(0),
[Issue Date].[Issue Year]).PrevMember

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Hi Deepak,

For the Current Year , I am using "YTD(Tail([Issue Date].[Issue
Year].members).Item(0))". This returns the year '2005'

For the previous year, I am using "YTD(Tail([Issue Date].[Issue
Year].members, 2).item(0))". This returns the year '2004'

Please say whether the formulae for previous year is correct or not.

Thanks for the help.

regards,
Srinivas



"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote