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. Click on the New button. Now , you will find the window called Connection Manager. Click the … More How to run MDX/Create local cubes from SSIS
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 ) ) * 100 )
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 the current month is Jun’2011, MAT1 will be the months from Jul’2010 to Jun’2011. MAT2: … More MAT (Moving Annual Total), YTD (Year to date) calculation using BottomCount, Tail, Properties function in MDX
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 you are suffering from the following reasons: The calculated measure is using another measure inside … More Measures Disappear in Local/Offline Cube
Zahid's blog on Data Engineering and BI 