MSBI # 5– SSAS # 1- What is SSAS ? – (SQL Server Analysis Services)

SSAS Is stands for SQL Server Analysis Services

Its is Analytical tool from Microsoft in BIDS

Design Scalable Solution with SSAS

•Productivity Enhancing Designers
– Optimized design experience
– Best Practice Design Alerts
– Dedicated aggregation designers
– Enhanced UBO
•Scalable Infrastructure
– Heterogeneous data Integration
– Scalable Backup
– Scalable shared databases
– Dynamic Management Views
•Superior Performance
– Market leading MOLAP Engine
– Real-time data access
– Subspace computation optimization
– MOLAP enabled write-back

•Productivity Enhancing Designers
– Optimized design experience
– Best Practice Design Alerts
– Dedicated aggregation designers
– Enhanced UBO
•Scalable Infrastructure
– Heterogeneous data Integration
– Scalable Backup
– Scalable shared databases
– Dynamic Management Views
•Superior Performance
– Market leading MOLAP Engine
– Real-time data access
– Subspace computation optimization
– MOLAP enabled write-back

Logical Cube Example :just for reference

image

Analysis Services Database

•An Analysis Services database is the top level container for other dependent objects:

•A database includes

   –Data Source

   –Data Source View

   –Cube

   –Dimension

   –Security Role

Basic Into

  • The basic idea of OLAP is fairly simple. Let’s think about that book ordering data for a moment.
  • Suppose you want to know how many people ordered a particular book during each month of the year. You could write a fairly simple query to get the information you want.
  • The catch is that it might take a long time for SQL Server to churn through that many rows of data.
  • And what if the data was not all in a single SQL Server table, but scattered around in various databases throughout your organization? The customer info, for example, might be in an Oracle database, and supplier information in a legacy xBase database.
  • SQL Server can handle distributed heterogeneous queries, but they’re slower.
  • This is where OLAP comes in.
  • The basic idea is to trade off increased storage space now for speed of querying later.
  • OLAP does this by precalculating and storing aggregates.
  • When you identify the data that you want to store in an OLAP database, Analysis Services analyzes it in advance and figures out those daily, weekly, and monthly numbers and stores them away (and stores many other aggregations at the same time). This takes up plenty of disk space, but it means that when you want to explore the data you can do so quickly.
  • Later in the chapter, you’ll see how you can use Analysis Services to extract summary information from your data. First, though, you need to familiarize yourself with a new vocabulary.

The basic concepts of OLAP include:

  • Cube
  • Dimension table
  • Dimension
  • Hierarchy
  • Level
  • Fact table
  • Measure
  • Schema
    We are going to provide you Detailed level of description in upcoming post covering all aspect of SSAS
    If you wan more interesting link please visit our link resource website 

Hope this helps !!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: