Page 2 of 2 FirstFirst 1 2
Results 11 to 13 of 13

Thread: Return parent from cubemember

  1. #11
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    1,742
    Articles
    76
    Blog Entries
    14


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Will Riley View Post
    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...
    Ken Puls, CPA, CMA, FCMA, MS MVP (Excel)

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  2. #12
    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

  3. #13
    Seeker Will Riley's Avatar
    Join Date
    Mar 2011
    Location
    Solihull, United Kingdom
    Posts
    8
    Articles
    0


    Register for a FREE account, and/
    or Log in to avoid these ads!

    Quote Originally Posted by Jesse View Post
    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

Page 2 of 2 FirstFirst 1 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •