I’ve blogged about the Properties() function before.
MDX #11 – How to get number of cars each customer owned using Properties() function?
MDX...
2013-02-28 (first published: 2013-02-21)
1,950 reads
Slicer, Axes and Calculations Can All Filter Data in MDX
Every developer with SQL background knows how the WHERE clause works....
2013-02-08
4,003 reads
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression
Many of the MDX functions, such as NonEmpty(),...
2013-01-17
17,089 reads
Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...
2013-01-04
11,475 reads
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...
2012-12-03
680 reads
Almost every tool we learned has some sort of “Hello World!” tutorial lesson.
So here comes the “Hello World!” lesson in...
2012-12-03
1,073 reads
Need to check the last time when our ETL processes ran successfully
Data warehouse developers routinely query the last data date...
2012-11-22
660 reads
ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods
ParallelPeriod() function is often used...
2012-11-22
1,357 reads
A reader asked me to share a C Sharp script I used in this post, SSIS #114 – How many ways...
2012-11-03
1,167 reads
Continuing from MDX #18 – Easy to concatenate row values into column in MDX.
I have not accomplished the goal of concatenating...
2012-10-19
1,443 reads
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
By Steve Jones
One of the features we advocates have been advocating for is a better way...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
Comments posted to this topic are about the item Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers