I have built a dimension in MSAS which has a ragged hierarchy, using the "Hide Member If" property. When I browse the data in Analysis Services it does exactly as I want.
However, when I view the same dimension using the Cube Analysis Excel Add-In for Excel, it gives me a plain old balanced...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.