Unfortunately, this is about as far as I could tip-toe the fine line between security and flexibility......unless this challenge could be solved using a custom "security table" and driving the...

Nice!

Good article regarding loading of OLTP data and covering lots of ground. In a dimensional data warehouse the order of loading would be:

1. Subdimensions

2. Dimensions

3. Bridge tables (Fact-to-Dimension...

First off, please accept my apologies to everyone for bringing your brains to a screeching halt.

In breaking the QDC (Question Of The Day Cherry), I now feel like Henry Hill...

I screwed the pooch on this one by omitting the word "NOT". The purpose of the question was to bring to the developer's attention "the future deprecation of omitting...

This has gotten me out of some major SSAS jams with the caveat that it is fairily long:

http://www.microsoft.com/en-us/download/details.aspx?id=17303

It covers all tuning aspects from disk configuration (RAID 5 is...

The Kimball Group usually describes the application process as an event pipeline with predictible milestones. As such, if you were to design a data warehouse like structure for this...

Not sure how your shop is about open source software, but here are some nice tools for monitoring SSAS:

Monitoring Tool: ...

It would be nice if I told you where to go! Chapter 2: Project Plan List 🙂

One of my all time favorites (because it uses a football analogy):

http://www.kimballgroup.com/data-warehouse-and-business-intelligence-resources/data-warehouse-books/booksdwlt2/

Collapse whatever is too detailed. Also, Larissa Moss and Laura Reeves are two of the all...

For more on SSIS Expression Language, which is a goofy combination of T-SQL (mostly with the functions) and C (mostly with operators and the like), go here (for SQL Server...

YEAR( [Date Column] ) >= 2009 && YEAR( [Date Column] ) <= 2011

Would you say the trending is fixed (as in merely year to year)? Or, do the end users need to be able to compare any periods to any periods...

Is it important to go back in time and ask:

"What was the compliance status of the department back on 1/1/2009?"

Or, do your end users merely care about there "here and...

Simply put, your measurement events appear to be:

1. Getting consent (possibly)

2. Taking a course (definitely)

Those events give context to the employee (working in a dept that is part...