How to create calculated member to get last 12 months value

#1

Hi,
I am trying to create a calculated member for the cube.
In this, I need to create a calculated member for last 12
months value.For example Last 12months sales

How to do that?
If anybody knows pls reply.

#2

Tell us a little bit more about your time dimension
Bob
"Vanchi" <gvanchi (AT) hotmail (DOT) com> a écrit dans le message de news:
083601c3a378$fec85250$a601280a (AT) phx (DOT) gbl...

Quote:

Hi,
I am trying to create a calculated member for the cube.
In this, I need to create a calculated member for last 12
months value.For example Last 12months sales

How to do that?
If anybody knows pls reply.

#3

Something like this:

Sum(LastPeriods(12, Time.CurrentMember), Measures.[MyMeasure])

tom @ the domain below
www.tomchester.net

"Vanchi" <gvanchi (AT) hotmail (DOT) com> wrote

Quote:

Hi,
I am trying to create a calculated member for the cube.
In this, I need to create a calculated member for last 12
months value.For example Last 12months sales

How to do that?
If anybody knows pls reply.

#4

Thanks Tom.
It works.
Vanchi

Quote:

-----Original Message-----
Tell us a little bit more about your time dimension
Bob
"Vanchi" <gvanchi (AT) hotmail (DOT) com> a écrit dans le message de
news:
083601c3a378$fec85250$a601280a (AT) phx (DOT) gbl...
Hi,
I am trying to create a calculated member for the cube.
In this, I need to create a calculated member for last
12
months value.For example Last 12months sales

How to do that?
If anybody knows pls reply.

.

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

How to create calculated member to get last 12 months value

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

How to create calculated member to get last 12 months value - 11-05-2003 , 03:44 AM

Re: How to create calculated member to get last 12 months value - 11-05-2003 , 05:54 AM

Re: How to create calculated member to get last 12 months value - 11-05-2003 , 10:22 AM

Re: How to create calculated member to get last 12 months value - 11-06-2003 , 03:36 AM