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….
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…
SharePoint 2013 – Creating a data source to an SQL Server Analysis Services (SSAS) OLAP Cube
Below are the details when using SharePoint 2013 when you want to collect to an SQL Server Analysis Services (SSAS) OLAP cube, instead of only being able to use the SSAS Tabular. Example: · In our example we are going to connect to our Adventure Works DW 2012 SSAS 1. Go into your SharePoint 2013 website and then…
SSAS – Configuring the Slice Partition in your cube.
After recently going through an online video, I realized that I had not set the Slice option on the partition on a larger cube that I had. And by putting in the slice details this would then enable me to get faster queries when people were accessing the data. Below are the steps that I did in order to…
DAX – Comparing a specific Product Average against the average of ALL products
I had a situation when one of my fellow workers wanted to create a report where they wanted to compare one product’s sales and how it was doing when compared to the average of ALL the product sales. In our example below we want to extract from the AdventureWorksDW2012 Analysis Services Database You can get a copy of…
SCOM (Systems Center Operations Manager) Cube and Data warehouse
What I have done is I have found that it is very handy having all our SCOM data in a data warehouse and then having it in a SSAS (SQL Server Analysis Services). Within the zip file which can be located here below it has all the details for the following: · SCOM Data Warehouse and OLAP Documentation.docx o This…