Create Display Sub Folder for Tabular SSAS Measures
If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may...
2014-05-13
4,267 reads
Create Display Sub Folder for Tabular SSAS Measures
If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may want to group specific measures into display sub-folders. Display...
2014-05-13
3 reads
MDX Root Function
This week I discovered an incredibly useful MDX function, the function is called Root. Full documentation can be found here....
2014-01-08 (first published: 2014-01-05)
2,031 reads
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents,...
2014-01-07
1,860 reads
SharePoint 2010 Excel Services and SSIS
As increasing amounts of data are stored in SharePoint in various formats such as lists, Excel documents and Word documents, gaining access to this data is an on-going challenge...
2014-01-07
2 reads
MDX Root Function
This week I discovered an incredibly useful MDX function, the function is called Root. Full documentation can be found here. In the past, I have encountered scenarios where I...
2014-01-05
7 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In my prior blog post, I discussed...
2014-01-01 (first published: 2013-12-24)
1,791 reads
MDX Implementing Logical AND On Members of the Same Hierarchy
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...
2013-12-24
3 reads
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In MDX, when two or more members...
2013-12-19 (first published: 2013-12-15)
1,554 reads
MDX Implementing Logical OR On Members of Different Hierarchies
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In MDX, when two or more members of the same set are placed on a...
2013-12-15
5 reads
Blogs
2020 Advent of Code–Day 1
By Steve Jones
This series looks at the Advent of Code challenges. I started the Advent of...
Server Review Essentials for Accidental and Junior DBAs—Setting Up (Part 2)
By Kevin3NF
Welcome back to my Server Review Essentials for Accidental and Junior DBAs series. Last...
One Chart at A Time Video Series
Jon Schwabish over at PolicyViz has created great initiative called the One Chart at...
Forums
Interesting bug in SQL 2016 CHOOSE
While trying, in SQL 2016 (13.0.5850.14), to see if CHOOSE allowed an inline query...
String Shrinking
Comments posted to this topic are about the item String Shrinking
Ask SSC