Analysis Services (SSAS)

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

2,878 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

2,178 reads

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

2,720 reads

Blogs

sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019

By

sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...

Actual Difference Between EXISTS(SELECT 1 …), EXISTS(SELECT * …), and EXISTS(SELECT column …)

By

Is EXISTS(SELECT 1 ...) better than EXISTS(SELECT * ...)? Who would know better than...

ANSI_WARNINGS = OFF can break update statements with some SQL features

By

Working on a SQL 2017 database where an external, non-Microsoft application has direct access...

Read the latest Blogs

Forums

SSMS Freezing when Editing SQL Agent Job Steps

By eclmam

I've spent several hours trying to overcome an odd technical bug on two SQL...

cardinality estimation

By MVDBA (Mike Vessey)

Just a quick question I'm putting in a new SQL 2019 server and an...

Attribute in the hierarchy display as one value

By Charmer

Hello Friends, I want to display the attributes in a hierarchy as one value...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Auto Rounding

See possible answers