|
|
-
|
|
Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often used in telling family stories. Except ascendants. I never really understand what this word means until I ran into this wor...
|
|
-
|
|
I’ve blogged about the Properties() function before. MDX #11 – How to get number of cars each customer owned using Properties() function? MDX #12 – Do not forget the TYPED flag in the Properties() function The Properties() function ...
|
|
-
|
|
Slicer, Axes and Calculations Can All Filter Data in MDX Every developer with SQL background knows how the WHERE clause works. You put some condition in the WHERE clause, such as TheDate = Yesterday (pseudo code), and it will only return data for yeste...
|
|
-
|
|
Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression Many of the MDX functions, such as NonEmpty(), Filter() and Exists(), seem to be easy enough to use, but they present quite a challenge for people with T-SQL background....
|
|
-
|
|
Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface design, so this pretty useful feature stayed hidden from me until version 2008. Even in SSRS 2008, I did not pay much atten...
|
|
-
|
|
I often think that I am lucky to work in a profession that I enjoy very much. It makes everything I do a fun thing to do. Majority of the fun comes from the fact that I have my hands in almost every aspect of building a data warehouse. From business ana...
|
|
-
|
|
ParallelPeriod() function is very useful when we need to present data side-by-side for two parallel periods ParallelPeriod() function is often used when we need to present data side-by-side for two parallel periods, such as in the example below where d...
|
|
-
|
|
Need to check the last time when our ETL processes ran successfully Data warehouse developers routinely query the last data date (the last date when we have fact data) to check the last time when our ETL processes ran successfully. It’s not hard to d...
|
|
-
|
|
Continuing from MDX #18 – Easy to concatenate row values into column in MDX. I have not accomplished the goal of concatenating the set of top resellers in each country. Count() function can count the number of tuples in a set In this query, I am add...
|
|
-
|
|
Having worked with SSAS for a while and done some reporting with MDX queries, I started to explore opportunities to write SSAS “stored procedures”. I stumbled on a few blocks along the way to even set up the development environment properly before I got...
|
|