I apologize for the erroneous post I just made


I am trying to set the default member to the current date in a time
dimension

Right now it is hard-coded to Sept 16,2003

[Reporting Date].[Year].&[2003].&[9].&[20030916]

Can I build this somehow to just be the current date?

Joe

Yes, you can use an MDX expression that formulates the date as a string,
then use StrToMember function to convert it to a member. If you search this
group you will find examples.

tom @ the domain below
www.tomchester.net


"Joe Genshlea" <joegensh (AT) yahoo (DOT) com> wrote

Thanks,

I can not find any good documentation, nor can i even find a function that
returns the system date in MDX. Could you please explain, again I am new at
this.

Joe

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

http://www.google.com/groups?hl=en&l...r%3D%26hl%3Den


tom @ the domain below
www.tomchester.net


"Joe Genshlea" <joegensh (AT) yahoo (DOT) com> wrote

Thanks, I didn't know that google archived old articles, I use outlook
expres for newsgroups.

Anyhow, the VBA thing doesn't work. What is the name of the library? Does
it install with SQL server 2000 automatically? Do I need to install Office
2000 on the server for the library to load?

Thanks


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

"Joe Genshlea" <joegensh (AT) yahoo (DOT) com> wrote

Joe,

I thought something like this should work, but its not testing out for
me. I know I've done what you are trying to do, but then had to back
it out because I'm using ProClarity and it messed up my prebuilt
views.

TAIL([Time].[Month].[Day].Members,1)

Anyway, be aware this is not a System date kind of solution, but is
dependent upon the last data value in your cube. So, you need to take
into account how often the time dimension in your cube is refreshed.