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: February 2013

MDX #26 – SSN can only be referenced as a member property in MDX

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 is used to explore the attribute relationships in a dimension.

If… Read more

0 comments, 528 reads

Posted in Sherry Li's BI Corner on 21 February 2013

MDX #25 – Slicer or Sub-Cube?

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 yesterday.

Not so straightforward in MDX. We… Read more

2 comments, 662 reads

Posted in Sherry Li's BI Corner on 8 February 2013

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog