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,095 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,095 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,910 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,409 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,522 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,295 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,500 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,325 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
I have had a hard time to understand how to use EXISTS. I Always...
Dears, We are using Azure Data factory pipes to run some stored procedures against...
Hi, I have SQL Server 2019 installed and when go the Clear Trace database...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers