Comparison between ETL and ELT

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 Load data into data warehouse. This ETL approach works fine but in certain situations or scenarios it does not works well. Let’s [...]

, ,

1 Comment

Calling Sub-Reports Based On Row or Column Group

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 report you want to call as a sub-report, add the parameters and you are done. I [...]

No Comments

Migrating From Hyperion to Analysis Services – Part 2

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 dimension extract files from Outline Extractor only extract the actual data without any keys. I created [...]

No Comments

GeoFlow – New 3D Mapping Tool for Excel 2013

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 a million rows of data visually on Bing maps. For details go to SQL Server Blog [...]

No Comments

Migrating data from Hyperion to Analysis Services (Multi-dimensional) – Part 1

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. In this series of blog, I will explain all the steps and challenges faced while [...]

1 Comment

Calculate Command Missing

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 checked the dimension usage tab and processed each dimension separately. I did not get any error [...]

No Comments

SQL Server 2012 Developers Training Kit

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 and BI solutions. Download SQL2012DevTrainingKit.Setup.exe file, extract it and run the default.aspx page to browse the [...]

No Comments

Free E-Book Gallery for Microsoft Technologies

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 link and don’t forget to share it with colleagues and friends. http://social.technet.microsoft.com/wiki/contents/articles/11608.e-book-gallery-for-microsoft-technologies.aspx

No Comments

Creating Analysis Services Project Using an Existing Analysis Services Database

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 and create exact same source code files based on an existing Analysis Services database. To reverse [...]

No Comments

Using Joins in Update and Delete statements

Sometimes you need to update or delete records based on matching records in another table. You may use sub-query for this but there is a better approach by using Joins in your update and delete statements. Following is an example of how to implement it in your code. Update d Set d.Department = Deptt.SEGMENT4_DESCRIPTION From [...]

No Comments