MDX # 39 – Find Default Measure using MDX Query
In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...
2014-04-23 (first published: 2014-04-15)
3,088 reads
In Chapter 1 of our book, MDX with SSAS 2012, we’ve devoted a section “Setting a default member of a...
2014-04-23 (first published: 2014-04-15)
3,088 reads
Correction
4/25/2014
Thanks to Chris Webb’s comment (see the comment section). I am making a correction on this blog.
The title of this...
2014-04-15
1,909 reads
While you are writing and testing MDX queries in Microsoft SQL Server management Studio (SSMS), how many times you find...
2014-02-12
1,406 reads
In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...
2014-02-07
2,520 reads
Using variables in SSIS packages can make your ETL process more dynamic and respond to different scenarios during runtime.
Not...
2014-01-29
9,292 reads
The book’s link is here, SQL Server 2012 Reporting Services Blueprints.
This book is a step-by-step, task-driven tutorial that goes straight...
2014-01-24
1,143 reads
The WordPress.com stats helper monkeys prepared a 2013 annual report for this blog.
Here’s an excerpt:
The Louvre Museum has 8.5 million...
2014-01-01
397 reads
In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...
2014-01-01
512 reads
Reader Query
My publisher recently forwarded me a question from a reader about the “Using the PROPERTIES() function to retrieve data...
2013-12-27
1,499 reads
A co-worker recently worked on a SSRS report and wanted to use a specific manager’s team for testing. The Manager...
2013-11-18 (first published: 2013-11-08)
2,323 reads
I know I can use extended events (xevents) in Azure SQL DB when in...
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
I'm working with someone whose client says "Yes, we have a data warehouse. But...
Hi Folks, I have been tasked with reviewing all the activity on a...