Return parent from cubemember

[Ken Puls]

Ken... not sure what went wrong with the above rendering... looked fine until I posted it but the formatting seems to get all screwed? Seemed to be working fine yesterday

Not sure, Will. I haven't changed anything since I installed Tapatalk 3 days ago. The WebApp tags I posted about last night have actually been in place for over a week...

Appreciate your diligence in attempting to make it work. I'll have to look into this some more...

[Jesse]

Thanks for looking Will. I'm not using PPVT, just the cube functions pulling from OLAP in Office 2007. Being able to return parent would remove the last vestige of static reference in my reporting other than the single set of location numbers.

Clearly some MDX education is in my future. Can you recommend any good online resources?

Jesse

[Will Riley]

Thanks for looking Will. I'm not using PPVT, just the cube functions pulling from OLAP in Office 2007. Being able to return parent would remove the last vestige of static reference in my reporting other than the single set of location numbers.

Clearly some MDX education is in my future. Can you recommend any good online resources?

Jesse

I'm curious then - the code I gave you should have worked based on an SSAS cube (as per the AdventureWorks example I gave)

Good online resources - look up the following
Chris Webb's Blog
Mosha Paumansky's blog
BillPearson did a good MDX series on SQLServerCentral.com
SSAS-Info.com

And buy this book by George Spofford
http://www.amazon.co.uk/MDX-Solution...der_0471400467

Will