Re: FROM date TO date

Tech-Archive recommends: Fix windows errors by optimizing your registry

yops...Friday...Thank you Man!
Alex

"Darren Gosbell" wrote:

> The definition you had in your calculated member returned a set, to get
> it to return a value you would need to use the AGGREGATE or SUM function
> over the set of dates.
>
> eg.
>
> with member [date].[hrchy2].[kpifromDateToDate] as
> 'SUM([date].[hrchy2].[date name].[2004-04-03T00:00:00]:
> [date].[date name].[2004-04-08T00:00:00],[measures].[total checks])'
>
> select [date].[calendar date].[kpifromDateToDate]
> on 0,
> ([organization].[hrchy1].customer)
> on 1,
> from [cube]
> where organization.customer.delta
>
> --
> Regards
> Darren Gosbell [MCSD]
> Blog: http://www.geekswithblogs.net/darrengosbell
>
> In article <940722ED-5DC7-4229-8C41-EE4E8DA0774F@xxxxxxxxxxxxx>,
> AlexDeiden@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> > How to create calculated member when all date members like
> > '2005-12-03T00:00:00' to slice by 'FROM DATE TO DATE' period.
> >
> > That is the 'PROTOTYPE' OF MDX that I need to have:
> >
> >
> > with member [date].[hrchy2].[kpifromDateToDate] as
> > '{[measures].[total checks],([date].[hrchy2].[date
> > name].[2004-04-03T00:00:00]:
> > [date].[date name].[2004-04-08T00:00:00])}'
> >
> > select [date].[calendar date].[kpifromDateToDate]
> > on 0,
> > ([organization].[hrchy1].customer)
> > on 1,
> > from [cube]
> > where organization.customer.delta
> >
> >
> >
> >
>
.

Relevant Pages