MDX Training

Does anyone know of any good instructor-led (DC, MD, VA) or e-learning classes on MDX? I have read Fast Track to MDX (Whitehorn et al) but I need a knowlegeable source to guide me. Also, this book was based on SQL 2000. The one vendor listed through "Find a Course" on Microsoft training website is currently not offering it because not enough people are asking for it. Also I cannot find training on SQL 2005 MDX. I really need course. Thanks I appreciate it.I'm the MDX trainer at u2u, and I have students in my classroom from time to time :-) So if you would like to have your course in Europe (we're based in Brussels but we also go on-site, courses are in English), check out www.u2u.be|||

I'm literally just finishing writing an MDX course for Solid Quality Learning and it should be up on their website (http://learning.solidq.com ) within a matter of days. It will certainly be available as a private course in the US and Europe and I guess there will be some public courses scheduled soon too.

Chris

|||Does Solid Quality Learning have locations in MD, VA or DC?|||

No, unforunately not, but they specialise in private classes which can be tailored exactly to your needs and run wherever you want.

Chris

|||

Those who are interested in attending an upcoming MDX on AS2005 course should contact Jean Reeves at Solid Quality Mentors asap. She is working on scheduling one in Dallas, Tx., based on the course authored by Christopher Webb.

e-mail: jreeves@.solidq.com

telephone: (813) 645-1646

Regards,

Daniel Upton

MDX Training

Does anyone know of any good instructor-led (DC, MD, VA) or e-learning classes on MDX? I have read Fast Track to MDX (Whitehorn et al) but I need a knowlegeable source to guide me. Also, this book was based on SQL 2000. The one vendor listed through "Find a Course" on Microsoft training website is currently not offering it because not enough people are asking for it. Also I cannot find training on SQL 2005 MDX. I really need course. Thanks I appreciate it.I'm the MDX trainer at u2u, and I have students in my classroom from time to time :-) So if you would like to have your course in Europe (we're based in Brussels but we also go on-site, courses are in English), check out www.u2u.be|||

I'm literally just finishing writing an MDX course for Solid Quality Learning and it should be up on their website (http://learning.solidq.com ) within a matter of days. It will certainly be available as a private course in the US and Europe and I guess there will be some public courses scheduled soon too.

Chris

|||Does Solid Quality Learning have locations in MD, VA or DC?|||

No, unforunately not, but they specialise in private classes which can be tailored exactly to your needs and run wherever you want.

Chris

|||

Those who are interested in attending an upcoming MDX on AS2005 course should contact Jean Reeves at Solid Quality Mentors asap. She is working on scheduling one in Dallas, Tx., based on the course authored by Christopher Webb.

e-mail: jreeves@.solidq.com

telephone: (813) 645-1646

Regards,

Daniel Upton

|||Hitachi Consulting is a leader in MDX training and has offered expert MDX courses for over three years. You can find a full range of MDX classes and other Hitachi Consulting offerings throughout the United States at
www.unitedtraining.com/hitachi

MDX Training

Does anyone know of any good instructor-led (DC, MD, VA) or e-learning classes on MDX? I have read Fast Track to MDX (Whitehorn et al) but I need a knowlegeable source to guide me. Also, this book was based on SQL 2000. The one vendor listed through "Find a Course" on Microsoft training website is currently not offering it because not enough people are asking for it. Also I cannot find training on SQL 2005 MDX. I really need course. Thanks I appreciate it.I'm the MDX trainer at u2u, and I have students in my classroom from time to time :-) So if you would like to have your course in Europe (we're based in Brussels but we also go on-site, courses are in English), check out www.u2u.be|||

I'm literally just finishing writing an MDX course for Solid Quality Learning and it should be up on their website (http://learning.solidq.com ) within a matter of days. It will certainly be available as a private course in the US and Europe and I guess there will be some public courses scheduled soon too.

Chris

|||Does Solid Quality Learning have locations in MD, VA or DC?|||

No, unforunately not, but they specialise in private classes which can be tailored exactly to your needs and run wherever you want.

Chris

|||

Those who are interested in attending an upcoming MDX on AS2005 course should contact Jean Reeves at Solid Quality Mentors asap. She is working on scheduling one in Dallas, Tx., based on the course authored by Christopher Webb.

e-mail: jreeves@.solidq.com

telephone: (813) 645-1646

Regards,

Daniel Upton

mdx question

I have 2 dimension tables :students and classes related through a fact table that contains the keys of these tables in addition to other keys such as academic year and other stuff. the classes dimension has an attribute called class_department.

what is the statement in mdx to get the class_department for a student in students table?

thanks

Christina

I guess you want the MDX query? Since I don't know the naming of your dimensions/members/measures, I will just give it a shot with some similar names. I assume that you have one measure in your fact table - a count measure.

SELECT {[Measures].[Count]} ON 0,

{[Classes].[Class_department].members} ON 1

FROM [YourCube]

WHERE {[Student].[Student Name].[John Doe]}