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,137 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,137 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,936 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,430 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,556 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,323 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,163 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
411 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
526 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,525 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,355 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers