This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - What are Actions in SSAS and How to Make a Reporting Action

SQL SERVER – What are Actions in SSAS and How to Make a Reporting Action

June 6, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

SSAS actions let users open a report, a web page or drill through from cube data. Here is what actions are and how to build a Reporting Action step by step.

Read More
SQL SERVER - What is SSAS Tabular Data Model and Why to Use It - Part 2

SQL SERVER – What is SSAS Tabular Data Model and Why to Use It – Part 2

May 7, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

Part 2 of my SSAS Tabular Data Model series: define measures in your tabular project and then analyze the results in Excel, step by step.

Read More
SQL SERVER - What is SSAS Tabular Data Model and Why to Use it

SQL SERVER – What is SSAS Tabular Data Model and Why to Use it

April 8, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

Tabular mode is new in SQL Server 2012 Analysis Services. Here is what the SSAS Tabular Data Model is, why to use it over multidimensional and how to start one.

Read More
Two empty baking tins on a floured bench, a deep square one and a long shallow one, a hand reaching for the long tin.

SSAS Tabular vs Multidimensional: Choosing for a New Project

September 22, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL Analysis Services, SQL Server

Compare Tabular vs Multidimensional for SSAS projects, including storage, relationships, write-back, team skills, and model checks.

Read More
A brass tuning fork on a piano lid, with a violin, a cello and a guitar leaning on chairs nearby in a rehearsal room.

Tabular Models for the SQL Developer

June 25, 2011
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL Analysis Services, SQL Server, SQL View

Tabular models for the SQL developer add relationships, measures, security, and reusable semantics above SQL tables; learn when a view is enough.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com