Blog Archives

Calculate Last Year (WTD, MTD & YTD) based on Adventure Works DW 2008 R2

Prerequisites: Download Adventure Works Databases – 2012, 2008R2 and 2008 (in my case I used 2008 R2) http://msftdbprodsamples.codeplex.com/releases/view/93587 Download AdventureWorksDW2008R2 cube for SSAS 2008 R2 http://msftdbprodsamples.codeplex.com/downloads/get/461461 Changes: After implementation of Last Year (WTD, MTD & YTD) when verifying the data

Posted in SQL BI

Refresh BI Data through MDX Query

1. To refresh the BI data you need to create a job & schedule accordingly 2. Go to SQL Server Agent –> Jobs –> Right Click & Select “New Job…” 3. Fill the information for each Page. Below is for

Posted in SQL BI

Add Role/Security to SQL BI Cube

Please read my Post “SQL BI Demo with sample data”  http://wp.me/p2oyUE-3h 1. Select Role, Right Click & Select “New Role” 2. Select Permission base on your requirement. for users only select “Read Definition” 3. Go to “Membership” Tab & assign

Posted in SQL BI

Connect and Explore Cube through Excel

Please read my previous post SQL BI Demo with sample data  http://wp.me/p2oyUE-3h 1. Open Excel –> Data –> From Other Sources –> From Analysis Services 2. Enter information i.e. Server Name, Log on credentials. Click “Next >” 3. If your

Posted in SQL BI

SQL BI Demo with sample data

For this demo i am using SQL Server 2005 Analysis Services. 1. Open BIDS 2. Create New project 3. Select “Analysis Service Project” & Fill Project Name, Location and Solution Name etc and Press “OK“   4. BIDS Development Studio

Posted in SQL BI