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.

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...

2014-11-14 (first published: 2014-11-11)

9,168 reads

MDX #44–How to find all the calculated measures

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Calculated measures are visually identifiable
If you have access to a cube, it’s quite easy to find all the calculated measures.
The...

2014-11-13

1,462 reads

MDX #43–Find a MDX Calculation Script

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure...

2014-11-12

1,342 reads

Book Review: Why You Should Read Expert Cube Development With SSAS 2012 Cover to Cover

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Expert Cube Development with SSAS 2012 Multidimensional Models was published earlier this year by Packt Publishing. It’s the second edition...

2014-06-15

831 reads

MDX #41–Remove employees with less than $100,000 sales

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Table of contents
Need to remove employees who have zero sales amountCreate a calculated measure with the IIF() function The NON...

2014-05-30

1,484 reads

SQL #54–Casting numbers with white spaces as Integer will fail

by Sherry-Lis-BI-Corner

Sherry Li's BI Corner

Table of contents
IsNumeric() funciton is too forgivenUse Pattern Matching with LIKE keywordLIKE keyword in T-SQL doesn’t support regular expressionReplace white...

2014-05-30

1,533 reads