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,936 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
3,997 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,084 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,464 reads
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything...
2012-12-03
668 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,061 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
656 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,353 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,160 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,438 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...