Book Review – Expert Cube Development with SSAS Multidimensional Models
http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book This book is a must read if you are looking for some useful and practical information in your SSAS Multidimensional models. But it must be noted that this is not an introduction into SSAS Multidimensional modelling, rather practical real world examples. I found that the book is a wealth of information that can be applied to your working environment….
SSIS (SQL Server Integration Services) – Using the Lookup Transformation and cache and how to handle NULL Values
I had a situation where I was using the Lookup transformation and then loading this into the SSIS Cache, but I wanted all rows to be inserted using the SSIS Cache, even if there was a NULL Value. Below explains how I overcame this. Example: · In our Source data we have Products, but they might not be in…
SSAS (SQL Server Analysis Services) – Securing Measures in Measure Group for specific Roles
What I had to do today for the first time is to only show specific measures in the measure group for particular Roles (Users or AD Groups) · The reason that this was required is because we had sensitive information that was not for everyone’s eyes. NOTE: From my recent review and read through from the following book, http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book…
Excel – User Input for Custom MDX query using VBA and Pivots
I had a requirement where I wanted to do the following for a particular Power User · Give them the ability to put in a Date as a parameter in an Excel Workbook. · Once I have this date, is to the have a custom MDX query, which will then go and get the required data for the date. o …
SSAS – Error – Value cannot be null. Parameter name: rootComponent
I got the following error as shown below, when I was adding rows into the XML file for the Data Source View. NOTE: The reason that I was using the XML file was because I had added a whole lot of partitions to my Data Source View, so I did not want to create all the relationships manually but rather…
SSAS – Using the SUM Function within a Measure Group to display a Distinct Count with SSAS (SQL Server Analysis Services)
Whilst completing my review on the Expert Cube Development with SSAS Multidimensional Models, I came across the Distinct Count Measure within SSAS and how this can affect query performance as well as processing performance. You can find the reference on page 114 And here is a link to the actual book that I am reviewing: http://www.packtpub.com/expert-cube-development-with-ssas-multidimensional-models/book What I wanted…
Win Free Ecopy of new book on SSAS
Readers would be pleased to know that I have teamed up with Packt Publishing to organize a Giveaway of the Expert Cube Development with SSAS Multidimensional Models And two lucky winners stand a chance to win ecopy of their new book. Keep reading to find out how you can be one of the Lucky Winners. Overview: …
Online Review of Expert Cube Development
I thought I would quickly post that I have been asked to complete an online review of Expert Cube Development which is a new book released by Packt and written by Chris Webb, Alberto Ferrari and Marco Russo. I have to say that so far I am really enjoying the book and find it really interesting and enjoy that it…
SSIS – Running single SSIS packages in Parallel to get faster performance for multiple data loads
What we are going to show you below, is that by using ONE SSIS package, we can re-use this one SSIS package multiple times to get data from multiple sources, possibly from different databases hosted in different locations around the world. So in effect we are loading our data from one SSIS package in parallel. NOTE: By completing the…
SSIS – Getting Partition Names for the past 12 months
I had a situation where I was using a conditional split, so that when data was coming in from my source tables it would dynamically go into the correct partitioned table. Below is the script that I used, as well as for reference the conditional split — ================================================================================================================== — What we are doing here is to create a…