When designing ETL solution for a data warehouse, it is very important to make sure your ETL process is optimized. We usually Extract data from one or more data sources, Transform the data by applying data transformations and then LoadMore…

Calling a sub-report when user clicks on detail row cell of a Tablix control is straight forward. You can right click on the detail cell, select textbox properties. Select Action and then select ‘Go to report’ option. Select the reportMore…

Loading Dimensions Using SSIS Packages This blog is continuation of my previous blog Migrating Data From Hyperion to Analysis Services – Part 1. In this blog we will discuss how to load dimensional data into the Warehouse database. The dimensionMore…

On 2nd day of PASS Business Analytics Conference, Microsoft announced a new 3D analytics tool “GeoFlow” for Excel 2013.  GeoFlow is a powerful 3D visualization tool which used data from PowerPivot or Excel data model to plot up to aMore…

Extracting data from Hyperion Essbase I recently did a project where we moved dimension and fact data from Hyperion Essbase to SQL Server Analysis Services. In general we cannot use an OLAP cube as a data source for another cube.More…

I came across an interesting scenario to troubleshoot in Analysis Services. When I was browsing cube, I was not getting any values for any of the measures. I looked into the data source view and checked all relations. I checkedMore…

SQL Server 2012 developers training kit is an excellent resource for developers and administrators to get familiar with new features and key improvements in SQL Server 2012. It has technical presentations, demos, hands-on labs and videos to implement database andMore…

Microsoft TechNet has many e-books available to download for free. The topics include ASP.Net, Office, SQL Server, Windows Azure, SharePoint and other technologies. There are several white papers and community& partner content also available for free. See the following linkMore…

Last week, I was waiting for somebody to provide me Analysis Services solution files to update some SSAS cubes. I updated those cubes when I got solution files but later I found out a simple way to reverse engineer andMore…

Few days ago, we got complaint from a client that one of their SQL query is taking too long to execute. Query was long and complicated with several joins and sub queries. The indexes and joins were already optimized butMore…