Analysis Services (SSAS)

SQLServerCentral Article

Browsing SSAS Instance over the internet

  • Article

Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]

5 (3)

2019-12-31

5,942 reads

Stairway to SSAS Tabular

Stairway to SSAS Tabular Level 7: Time Intelligence

  • Stairway Step

Time Intelligence is a common methodology in Dimensional Modeling that allows for calculations of measures based on relative dates. These include “To-Date” measures like Year to Date or Quarter to Date as well as Previous Period comparisons. Once these are created within a model, other DAX functions can be used for metrics like Year over […]

2019-07-10

4,799 reads

SQLServerCentral Article

Build an OLAP Cube in SSAS using an ADO.NET Data Provider

  • Article

SQL Server Analysis Services (SSAS) is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications, such as Power BI, Excel, Reporting Services reports, and other data visualization tools. When paired with ADO.NET data providers, you can create cubes from external data […]

5 (1)

2019-04-30

3,197 reads

Blogs

SQLServerCarpenter Tools

By

Over the past couple of years, I’ve developed several tools that I’ve been using...

usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON

By

/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...

A New MVP Led Training Initiative – Cloud Formations

By

Hello Readers – I wanted to make sure those who follow my blog have...

Read the latest Blogs

Forums

SQL Server 2014 Question

By kazana

So I have inherited an older SQL 2014 Server and have been working on...

Removing UNION and getting the same result

By azdeji

Hi, I need to update my sql script and remove the UNION but get...

SQL Server 2019 HA

By celigo

Looking for a HA solution for SQL server for our branch offices. Current setup...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers