Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Sherry Li's BI Corner

Always wanting to publish novels, but having the fortune to work in the data warehouse corner of technology, Sherry Li started to write the mysteries of the Microsoft Business Intelligence. She writes everything from T-SQL to MDX, ETL to Expressions to Scripting, Reporting to Cubes. You can find her writings at bisherryli.wordpress.com.

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, 366 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, 423 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, 464 reads

Posted in Sherry Li's BI Corner on 7 October 2012