Luis Cazares (7/27/2015)

---

Hi Sam,

Thank you for reading the article and commenting. You're absolutely right, there's an error with the generation for the sample data. There shouldn't be a many to...

Hi Luis,

Interesting technique, thanks for sharing.

I must admit I'm surprised the CTE results were so much larger.

I'm trying to understand the rules that exist in the sample data using the...

+1 that this is almost certainly a terrible idea.

If the trigger has a lock on the table and you have a source(/destination?) component reading the same table it could be...

Thanks to everyone for their input.

I'm happy to see that you're all recommending decimal which is what i meant by 'numeric'. I thought the two were interchangeable?

Vedran Kesegic (10/11/2012)

---

Look here...

My understanding is that there's no way to use *, instead generate a list of columns and use that.

Modifying the CTE requires recognising how the ROW_NUMBER/PARTITION BY works.

Your code:

WITH DUPLICATES...

I recognised the attempt to insert null and hence picked 2,0 because that's what the two select statements return: 2 and 0. It's the insert statement that fails.

emiddlebrooks (9/13/2012)

---

So with all words being same length

VALUES ('apple'), ('Apple'), ('applx')

If I did character by character "a" being before "A" should be apple, applx, Apple. But you get apple, Apple,...

Thanks for your response, Hugo.

Hugo Kornelis (8/27/2012)

---

In short, I...

Firstly, "I have two stored procedures" suggested to me that the scripts we were executing were the actual stored procedures not necessarily the create scripts depicted.

This may well be a...

Turns out i'm still a local admin so therefore I'm still a SSAS server admin.

I believe the issue is that I didn't pay proper attention and set the impersonation option...

Ok,

After deleting the old NQ and saving, then adding back the NQ and saving.

The view was missing from the dimension. I had to add it again and redo the mappings...

The actual errors are:

"The following system error occurred: Logon failure: unknown username or bad password."

"Errors in the high-level relational engine. A connection could not be made with the DateSourceID of...

There's plenty of information on google. I think Kimball touches on it.

Here's one article that looked promising:

http://hubdesignsmagazine.com/2007/10/10/ten-best-practices-for-master-data-management-and-customer-data-integration/

Master Data Services is microsofts product, their information can be found here: http://www.microsoft.com/sqlserver/en/us/solutions-technologies/enterprise-information-management/master-data-management.aspx

This is an option you may want to look into: http://sqlparallelboost.codeplex.com/

I don't know much about it myself though.

In lieu of reading the Kimball book, this design tip discusses the Kimball approach:

http://www.kimballgroup.com/html/07dt/KU95PatternsAvoidHeader-LineItem.pdf

As Koen says, you can aggregate the case table up to the grain of you current fact...