Not sure if this helps, but you could try using the 'char' function.  It would appear that the default format is US date format.

Char(X,F)

Returns the string-representation of a date, time...

Not knowing what the range of possible values are whenthe measure is numeric (ie can they go negative), the following might work for you.

If you can change you string measure...

You could try out the following tool, not supported by MSft but (co-)written by one of the MSft guys who co-wrote the performance and Ops guides (Dave Wickert).  It basically...

You're relly talking about the process buffer size when looking at processing cubes.  Check out Appendix C in the same document for instructions on how to tune it - basic...

Assuming (which is always bad ) that your periods belong to years, can't you set the level (and dim) types so that the...

the following article could possibly help (it's about using AS and RS, look towards the end re: actions) but will depend a little on how dynamic you need to query. ...

in psuedo code, for a calc membr in the measures dim, you could use something like

time.currentmember + time.currentmember.lag(-3) + time.currentmember.lag(-6) + time.currentmember.lag(-12)

but this will cause you problems at levels...

Have you looked at the parallelperiod function?  Using appropriate params you can use this to pick out 'same month last year', or even 'same month next year', s you really...

Have you tried using the built-in drill through functionality?  I'm assuming that the fact and dims are all on the same server (server2).  When setting up drill through in the...

Chris,

this should do what you want, but is likely to not produce the exact output you'll want if yo start wanting to crossjoin on the columns (ie measures, in this...

the information should be there, it probably depends a little on the querying tool as to how it is displayed.  Assuming you're using the mdx sample app, if you dbl-click...

The things I would be most concerned about are

• contention over RAM.  not so much a problem if everything you're doing is really small, but if you start to push...

If you take a look at this previous post -> http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=97151 you may find some answers there.  One thing that has changed since I posted in that thread is the...

It is the Edition of MS AS that you're running, most likely Standard Edition (do a search for 'Features Supported by the Editions' in BOL to see what each edition...

have you thought of doing either calculated cells or a custom rollup?  Calc cells will let you specify a subset of the cube (eg anything under and including devolution) and set...