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,472 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
5 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
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,034 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,865 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
4 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
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
12 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
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,795 reads
Blogs
Microsoft Build event announcements
By James Serra
There were a number of data platform announcements at Microsoft Build yesterday that I...
Data is not immutable
Information — in the form of data — usually stored as binary 1s and...
Daily Coping 25 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
SQL Server Data Discovery and Classification - times out...
The powers that be have commanded that we implement data classification because... well, to...
How to Navigate through folders to find .zip file
Is there any script task in SSIS to find the zip files under each...
Ask SSC