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,820 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
35 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
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....
2014-01-08 (first published: 2014-01-05)
2,169 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,918 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
19 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
16 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
37 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
13 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,864 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Forums
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers