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

Understanding crossjoin, set, tuples with help of SetToStr function

MDX cross join function returns the cross product of two sets. For example, we have two sets A = {1,2} and B = {x,y}. After crossjoin, we get, A X B = {(1,x),(1,y),(2,x),(2,y)}. (1,x), (1,y) are individual tuples. The resultant … Continue reading

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

How to run MDX/Create local cubes from SSIS

Just drag an Execute SQL Task and double click to open SQL Task Editor. Under the SQL Statement section, you will find the slot for Connection. Click on New connection and you will see the Configure OleDb connection Manager window. … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube, SSIS (SQL Server Integration Service) | 3 Comments

Market Share Calculation in MDX based on AXIS

Below is the MDX which will calculate market share at runtime/dynamically. It always reads data from the parent axis. iif  (   Axis(1)(0)(Axis(1)(0).Count – 1).Dimension.CurrentMember.Parent is null,   null,    (      [measures].[x]      /      (     [measures].[x],Axis(1)(0)(Axis(1)(0).Count -1).Dimension.CurrentMember.Parent    )   )   … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | 2 Comments

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