Daily Archives: October 29, 2011

How to hide Calculated Members in MDX SSAS

Posted on October 29, 2011 by MikeDavisSQL

With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used. For example: Aggregate(YTD([Date].[Calendar].CurrentMember),[Internet Sales Amount]) This calculation only works in the Date.Calendar Hierarchy. I wanted to show the end users … Continue reading →

Posted in mdx, SSAS, Syndication | Tagged , | 4 Comments