Category Archives: MDX, SSAS (Analysis Service), Cube

MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX

I was just trying to create two calculated memebers (MAT1, MAT2)¬†under period dimension in my cube and came up with this solution. First, I am trying to explain¬†MAT1 and MAT2. MAT1 : Last 12 months from the current month. If … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | 1 Comment

Measures Disappear in Local/Offline Cube

When u make a local cube from a server cube by executing the “Create Global Cube” statement, u often face a problem when a calculated measure does not show up in the local/offline cube. Whenever it happens, check out if … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | Leave a comment