MS SQL Server OLAP - How can we have a "last 7 days" member in a time dimension or other means to achieve dyna

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]

Author

How can we have a "last 7 days" member in a time dimension or other means to achieve dyna

Ron

2006-01-26, 4:58 pm

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.

Sponsored Links