|
Home > Archive > MS SQL Data Warehousing > March 2006 > Calculated Member
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Bill Walo 2006-03-05, 8:24 pm |
| Hello All.
I am using AS 2000 and would like to create a calculated member that shows a
calculated value back to a particular month regardless of year.
Here is an example.
I am looking at data for the month of July, 2005 and I want my calculated
member to show a calculated value for the month ofo December, 2004.
I would like this to be not dependant on the year. So if I am looking at
data for July, 2004, it will calculate the member for December of 2003. The
month that I am looking for backwards from where I am is always going to be
December of the previous year.
I hope I am being clear about this.
Bill
| |
|
| if you have only year and month levels and if the december month is the last
month of the year this formula will return the last december:
time.currentmember.parent.prevmember.lastchild
you can create a more generic formula (using ancestor function) and there is
other way to do this job (likeusing parrallelperiod, closingperiod...).
"Bill Walo" < williamwalo@nvgenera
l.com> wrote in message
news:A105A356-BA58-4726-806F- FFFBE2E72752@microso
ft.com...
> Hello All.
>
> I am using AS 2000 and would like to create a calculated member that shows
> a
> calculated value back to a particular month regardless of year.
>
> Here is an example.
>
> I am looking at data for the month of July, 2005 and I want my calculated
> member to show a calculated value for the month ofo December, 2004.
>
> I would like this to be not dependant on the year. So if I am looking at
> data for July, 2004, it will calculate the member for December of 2003.
> The
> month that I am looking for backwards from where I am is always going to
> be
> December of the previous year.
>
> I hope I am being clear about this.
>
> Bill
>
>
|
|
|
|
|