Hi All,

Although this has been highly regarded by some users,

as a complete beginner to MDX I am finding the tutorials very difficult to follow.

That being said these tutorials are...

Thanks for the reply CapnHector,

I understand completely where your coming from, however, if i were to create this table and then reference MAX(JobStatusID), would this again pose the same problem,...

Thanks for the reply Sean,

Unfortunately due to data protection issues im unable to post any of my data or even samples of...

i have however found a work around,

Thanks for...

Dudes..calm down...

What i ended up doing is creating a table in Excel and imported into the datawarehouse from which created a join in my query

I'll keep playing around with Stored...

Yep this is the method ive decieded to use so thumbs up to everyone for helping out 🙂

Ok so my case statement should always read @jdt_jty_code?

Cool

Ok...ill get reading and will be in touch...

Thanks for all the advice 😀

I have been reading articles on SSC and i do find them extreemly well written and informative, however i need some form of structured learning.

Ive taught myself all i know...