All

I posted a few weeks ago and i got help with the requirement by using the
Tom Chester calc dim example..

this worked fine for YTD and LastPeriods stuff for rolling months etc..

However, I could not get same period last year/month to work - the MDX
parsed but the cube (viewed in AS mgr) had no values at all or oocasionally
(happened intermittently) had #ERR - the error complained about something
that 'didn't match' - most times though thew values were blank..

i used..

(ParallelPeriod([Time].[YEar], 1), [Measures].currentmember) and placed this
in the Calcdim dimension - the 'special' new one used in Tom Chesters
example...the theory of this dimension is great as I dont need to create a
YTD, Same vs last year etc for each of the 10 measures..

My time dim has 2 levels - e.g 2004, Jan 2004 are typical members.. I was
thinking of splitting the year and month dims out to allow cross tab but
this won't help me i'm sure..

any thoughts most appreciated! Need it in and tested by monday!

DD

Hi,

give me your e-mail and I can send you a nice power point on how to create
shell/calc dimension.

Bye,
Andrej



"Darren Drysdale" <darrend (AT) hotmail (DOT) com> wrote

Hi andrej

drysdaledarren (AT) hotmail (DOT) com

cheers

Darren


"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> wrote

Check you're e-mail!

Andrej


"Darren Drysdale" <darrend (AT) hotmail (DOT) com> wrote

many thanks Andrej

I've looked through the PPoint slides.. the P Period example is useful
but..i'm not sure it's exactly what i'm after.. the Shell dim idea is what
I'm using (great idea whoever thought of it!) but I don't want to specify a
particular date (e.g. Time.Quarter 1 in the slides).. is this possible?
Ideally the function will calcualte the previous value for a year (if the
user selects 2004 for example they see 2003) or month (user selects Jan 2003
for example and they also see jan 2002) - for ALL/any measure.. I also then
need the % difference/growth figure (the slides do have one of these!)

thanks again

Darren


"Andrej Hudoklin" <andrej.hudoklin (AT) add (DOT) si> wrote

Why don't you post it here so anyone can see it?
I think that exactly why exist this newsgroup.

"Darren Drysdale" <darrend (AT) hotmail (DOT) com> wrote

Hi Ovidiu,

the problem is with sending files to newsgroup, thats why.

Andrej


"Ovidiu" <ovidiug70 (AT) msn (DOT) com> wrote