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
1,472 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
2,753 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
989 reads
2012-11-15
834 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
976 reads
Day 4 of The OLAP Sprint
Day 4 is the halfway point. Another pre-con, this one from Peter Myers that looks at Power View and Matrix reports.
2012-11-13
1,108 reads
2012-11-12
1,577 reads
2012-11-09
1,569 reads
2012-11-08
3,185 reads
2012-11-07
910 reads
Blogs
Reviewing 2019 Career Goals
By Steve Jones
According to this post, I rate 2019 as a Failure. Of the books I...
ASF 029: Tomaz Kastrun interview
By Kamil
Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...
Schema Filtering in SQL Prompt
By Steve Jones
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...
Forums
Can we use DC SQL Cluster Role name in DR Site (Same name Both Site)
Hi I have SQL Server FCI running in my DC site following are cluster...
error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE
Hello experts, A client is reporting the following error when his application tries to...
Connectivity to Oracle 12.2 instance via OLE DB ?
I installed Oracle 12 on Windows 10 in all possible ways/configurations, including the defaults....
Ask SSC