SSAS Tutorial: OLAP CUBE

What is SSAS?

Key Features of SSAS:

  • Ease of use with many wizards and designers
  • Data model creation and management is flexible
  • OLAP handling from scalable architecture
  • Customize application from extensive support
  • Speed
  • Shared metadata
  • Security
  • Multidimensional analysis
  • Avoid resource contention with the source system
  • Consolidate from multiple sources

What is OLAP Cube? Uses of OLAP Cube.

  • Open SSMS 2008
  • Connect the database engine
  • Open new query editor
  • Paste the SQL script here
  • Press F5 to run the script
  • It will create and populate the “Sales_DW” database.
  • Select the SQL server name where we created the data warehouse
  • Select server authentication mode
  • Enter your username and password to connect SQL Serve
  • Select database Sales_DW
  • Test connection –> OK.
  • Product Name Drag & Drop into Column
  • Full Date UK Drag & Drop into Row Field
  • FactProductSalesCount drag and drop this measure in Detail field

--

--

--

Big Data,ios,android,Spark

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

How to install Local by Flywheel on Windows 10

Microsoft First Fully Managed Communication Platform “Azure Communication Services”

Explore the possibilities with hundreds of domain extensions — {link} -

B2B vs B2C (From a B2B Perspective)

Reduce Cost and Increase Productivity with Value Added IT Services from buzinessware — {link} -

Airflow’s best kept secrets: How to track metadata with Airflow Cluster Policies & Task Callbacks

Apache Airflow metadata tracking

Stimulsoft Reports 2018.2.3 released

Tears, Sweat and Server Migration

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
MultiTech

MultiTech

Big Data,ios,android,Spark

More from Medium

The Best Way to Know What Is React

What is an API?

Control Flow with Conditionals and Loops in JavaScript

My experience learning stacks in Data structure