Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image Close it
Select File

Vishal Pawar is workin in The Most Group as MSBI Solution Architech
Browse by Tags · View All
sql 103
Query 58
#BI 32
Link 31
SQL Server 31
BI 30
#SQL Server 28
brh 21

Archive · View All
August 2011 36
June 2011 25
July 2011 21
December 2011 17
October 2011 12
September 2011 11
April 2012 7
November 2011 7
March 2012 5
January 2012 5

Vishal Pawar's Blog

MSBI # 17– SSAS # 3 Lets Get Start with SSAS ,Features and Project Start up– (SQL Server Analysis Services)

Aug 8 2011 2:24PM by Vishal Pawar   

Continuing from my previous SSAS post on : MSBI # 8– SSAS # 2- Get familiar with BIDS–SSAS ? – (SQL Server Analysis Services).

In this Post , we will develop an Analysis Services solution using the Business Intelligence Development Studio, an environment based on the Microsoft Development Environment shell.

Before Direct head start towards cores SSAS development lets get familiar with some of important features of SSAS






Important aspects of Analysis Services:

1.SQL Server 2005, Analysis Services provides a unified and integrated view of all your business data as the foundation for all of your traditional reporting, online analytical processing (OLAP) analysis, Key Performance Indicator (KPI) scorecards and data mining.

2. Provides business semantic model, referred to as a Unified Dimensional Model (UDM) that defines business entities, business logic, calculations, and metrics. The UDM is a central place that serves as the single version of truth for all reports, spreadsheets, OLAP browsers, KPIs, and analytical applications.

3. Maintains a highly compressed and optimized Data Cache called Proactive Caching that is maintained automatically as the data in the underlying source databases changes. The cache provides superb query performance and isolates back-end source systems from the load of the analytical queries.

4. XML for Analysis (XML/A) is the native, standards-based protocol for communication with the Analysis Services server. Applications that integrate analytics with operations in real time that can access the data from any platform and any language.

5. The Key Performance Indicator (KPI) framework provides a rich centralized repository defining key metrics and scorecards. The KPI framework in Analysis Services lets you easily build balanced scorecards and other types of business performance management applications.

6. Translations provide a simple and centrally managed mechanism for storing and presenting analytic data to users in their preferred languages.

7. Multidimensional Expression (MDX) Scripts are the new mechanism for defining calculated members, named sets, and cell calculations.

8. Semi-Additive Measures is a new measure aggregation type for advance data modeling includes last-nonempty, last-child, first-child, average-of-children, and even by-account-type.

9. 2005 Analysis Services (SSAS) provides tools for Data Mining with which you can identify rules and patterns in your data, so that you can determine why things happen and predict what will happen in the future – giving you powerful insight that will help your company make better business decisions.

We will create Analysis Services projects in Business Intelligence Development Studio by using the Analysis Services Projects template. The Analysis Services project helps you organize and manage the items that are required to build, debug and deploy an Analysis Services database.

Now moving ahead Lets Start with creating solution project from scratch

Task 1: Create an Analysis Services Project

1. Click Start | All Programs | Microsoft SQL Server 2008/Microsoft SQL Server Denali CTP 3 | Business Intelligence Development Studio.

2. Click File | New | Project.

3. In the New Project dialog box, in the Project Types pane, click the Business Intelligence Projects folder.

4. In the Templates pane, click the Analysis Services Project icon.

5. In the Name text box, type AS Exercise 1.

6. In the Location text box, enter D:\Development\Demo

7. Uncheck the Create directory for Solution checkbox. The New Project dialog box should now look like Figure 1.

8. In the New Project dialog box, click OK.


New Project Dialog in Business Intelligence Development Studio

now we have now created a new Analysis Services project. The project is created in a new solution and the solution is the largest unit of management in the Business Intelligence Development Studio environment. The solution contains one or more projects and you can view the solution and its projects in the Solution Explorer pane on the right hand side in the Business Intelligence Development Studio. If the Solution Explorer is not visible you can view it by View | Solution Explorer from the menu bar (or the keyboard shortcut <Ctrl + Alt + L>)

An Analysis Services Project is a group of related files containing the XML code for all of the objects in an Analysis Services database, and your next task is to create a Data Source.

We will have some more post based on Hit Start for SSAS Development in upcoming post.

One of the great thing about this post is location where I am giving this post is nothing but .net blogger Ganesh very sweet and cool village.

For more interesting links and daily update please subscribe our link resource website

Todays link are follows:

Link Resource # 12 August 3 – August 4 « Dactylonomy of Web Resource

Tags: BI, #BI, DBA, SSAS,

Vishal Pawar
24 · 7% · 2239



  • Hi,

    Could you please tell me how to do following senario:

    sample table:

    Year Amount Year growth ------- ---------- -------- 2010 100 0 2011 110 10 2012 120 10 2013 130 10

    My Cube measure will have Year and Amount but I need to calculate Year growth i.e. the difference between the Amount of two different years. How do I do it in Cube Measure.

    commented on Sep 26 2012 6:54AM
    Sreehari Katageri
    800 · 0% · 37

Your Comment

Sign Up or Login to post a comment.

"MSBI # 17– SSAS # 3 Lets Get Start with SSAS ,Features and Project Start up– (SQL Server Analysis Services)" rated 5 out of 5 by 1 readers
MSBI # 17– SSAS # 3 Lets Get Start with SSAS ,Features and Project Start up– (SQL Server Analysis Services) , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]