MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
2019-05-07
6,224 reads
olap
Build an OLAP Cube in SSAS using an ADO.NET Data Provider
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 […]
2019-04-30
3,197 reads
Create First SSRS Report with SQL Server Analysis Services OLAP Cube
Mubin M. Shaikh outlines how to create SSRS Report on SSAS OLAP Cube. If you don't have much prior knowledge of SSRS, just follow the steps and to have your first report ready on OLAP Cube.
2014-08-01
12,428 reads
Columnstore Index Changes in SQL Server 2014
SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?
2014-07-24
7,167 reads
Day 327: From Prototype to Production
In November of 2012, I embarked on a Quixotic attempt at building a BI prototype in 7 days. I dubbed the experiment ‘OLAP Sprint’...
2013-10-10
2,550 reads
MDX Guide for SQL Folks: Part III - Advanced Analysis
Learn everything about MDX drawing only on your T-SQL knowledge in this series. Frank Banin continues talking about Calculated Members, Named Sets, and more in part III.
2013-02-14
7,827 reads
MDX Guide for SQL Folks: Part II - Hierarchies and Functions
Learn everything about MDX by drawing only on your SQL knowledge.
2012-12-18
10,845 reads
Day 7 of The OLAP Sprint
The final day of Simon's journey to improve his OLAP knowledge and build a prototype cube.
2012-11-16
992 reads
2012-11-15
838 reads
Day 5 of The OLAP Sprint
Day 5, the first real day of the Summit. Amir Netz' session and a little cube work.
2012-11-14
981 reads
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers