| Peter Yang [MSFT] 2006-01-26, 4:58 pm |
| Hello Yoni,
You may want to consider using Lastperiods function to get the members you
want in MDX.
MDX Essentials - MDX Time Series Functions, Part III: The LastPeriods() and
ParallelPeriod() Functions
http://www.databasejournal.com/feat...10894_3073581_2
How To Obtain the Current Day with a MDX Query or Expression in SQL Server
2000 Analysis Services
http://support.microsoft.com/defaul...kb;en-us;301537
Implementing special time periods in your data mart
http://weblogs.sqlteam.com/timg/articles/3754.aspx
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
>From: "Ron" <ron@newsgroups.nospam>
>Subject: How can we have a "last 7 days" member in a time dimension or
other means to achieve dynamic time based on the current date (now()) ?
>Date: Wed, 25 Jan 2006 12:22:57 -0800
>Lines: 13
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
>X-RFC2646: Format=Flowed; Original
>Message-ID: <u8api0eIGHA.528@TK2MSFTNGP12.phx.gbl>
>Newsgroups: microsoft.public.sqlserver.olap
>NNTP-Posting-Host: 209-77-216-34.utopy.com 209.77.216.34
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.olap:66581
>X-Tomcat-NG: microsoft.public.sqlserver.olap
>
>Hello,
>
>We use AS 2005. We have a standard time dimension based on a pre-populated
>time table. Some of our reports can be emailed to recipient every morning
>(time-based scheduling). We would like the analysis to run on the last 7
>days every time the report is executed. How do we go about achieving this
>dynamic time specification ? The user can specify as a parameter to the
>report values like "last 7 days","last 30 days","yesterday".
>
>Thank you,
> Yoni.
>
>
>
|