Hello

Can I create a calculated member in the time dimension that will always
represent the current date or current date - 1?

Thank You

Assuming that your Time dimension already has [Day] members for the
current date, you can use the VBA Now() function:

http://groups-beta.google.com/group/...rver.olap/msg/
d10acbc0713a7de8?hl=en
From: George Spofford <geo... (AT) dsslab (DOT) com>
Date: Tue, 28 Jan 2003 08:00:11 -0500

Subject: Re: Find Current Date

By using the VBA!Now() function (part of the VBA library).

To use it to look up a time member whose name is something like "Jan 28,
2003", try:

StrToMember ("[Time]." + VBA!Format (VBA!Now(), "\[mmm dd, yyyy\]"))

HTH

naseer78 wrote:

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Everyone's concept of "current" tends to vary an it's often not the
current date, but rather the most current data in the cube. I usually
use the most recent time period of some level that has data in the
fact table. Something like this...

Tail(NonEmptyCrossJoin([MyTimeDim].[MyTimeLevel].Members)).Item(0).Item(0)

Replace...[MyTimeDim] with the name of your time dimension...and
replace [MyTimeLevel] with the name of the level in that time dimension
that you want to return for your concept of current (current year,
current month, current day, etc).


Deepak Puri wrote: