Subscribe to this blog
Sherry Li's BI Corner
Archives: October 2012
MDX #19 – There is more to do to concatenate row values into column
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 adding a count… Read more
0 comments, 75 reads
Posted in Sherry Li's BI Corner on 19 October 2012
SSAS #28 – Setup to Learn SSAS Stored Procedures
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 chance to identify scenarios to justify… Read more
0 comments, 99 reads
Posted in Sherry Li's BI Corner on 16 October 2012
MDX #18 – Easy to concatenate row values into column in MDX
Concatenating row values (within groups) into column in SSRS and TSQL
Concatenating row values into column is a never ending topic for report developers. It should be a simple task. That is, if the rows are not within groups. If the rows you are about to concatenate are customers in… Read more
0 comments, 104 reads
Posted in Sherry Li's BI Corner on 7 October 2012