Hi,

I have a cube with my sales data. I'd like user to have the posibility to
use a "Today Sales", a "This Week Sales". How can I do this?
I thought of somehow using a dimension member property but I don't know how.
My source for the time dimension is a relational table that has 3 extra
columns name Current Date, Current Week and Current Month all of them are
datetime columns populated on the specific rows Like the CurretDate field is
always populated on a single record that shows wich day is today and so on.
Can I use this?

Thanks

Try this code as the default member in the time dim.

Tail(Filter([Time].[Month].Members, NOT
IsEmpty(Time.CurrentMember)),1).Item(0)

Is this the kind of thing your looking for?

"Miguel Salles" wrote:

Almost there!

My cube is populated with future data (like something that we will sell
tomorrow) so the default member is now on september 2005 (last registered
sale)!!! This is why I wanted to use a member property on this matter, can
you help me?

Thanks a lot


"HWUK" wrote:

Try the following

StrToMember("[Time].[Month].[" + Format(Now(), "mmmm ") + "]") and click ok.

Now I know not all time dimensions are built the same way, in fact at one
place I had to use the following - StrToMember("[Month].[Year].&[" +
Format(Now(), "yyyy") + "].&["+ Format(Now(), "mmm") + "]")

So for October 2004 the resulting MDX value looked like this -

StrToMember("[Time].[Month].[" + Format(Now(), "mmmm ") + "]") =
[Time].[Month].[October]

StrToMember("[Month].[Year].&[" + Format(Now(), "yyyy") + "].&["+
Format(Now(), "mmm") + "]") = [Month].[Year].&[2004].&[10]

If the MDX doesn’t match your dimension it shouldn’t take long to figure the
syntax.

Hope this helps.

Howard.

Related forum
-http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=139979



"Miguel Salles" wrote:

It Works!!!

Thanks a lot, my syntax is a bit different however I got the Idea, so I can
now build my own default member!

Thanks again


"HWUK" wrote:

Thanks from me too. Works well, and it has got the flexibility I neede.


"HWUK" wrote: