Nice demo. Thanks for taking the time and effort to publish this.

I used to use the ROW_NUMBER method in order to historically create type-2 slowly changing dimensions in an environment...

I just hurt myself 😀

Koen Verbeeck (3/11/2014)

---

Great question.

Although the IDENTITY property doesn't always transfer:

When an existing identity column is selected into a new table, the new column inherits the IDENTITY property, unless one of...

Evil Kraig F (3/11/2014)In my experience, however, when a load fails you reload it from scratch, even something this large. The reason being you can't be sure what's missing...

Have you attempted the non-empty crossjoin of the 3 attribute hierarchies? If so, how was your performance?

One of my favorites: http://demoserver.entsoftsol.com/biportal/

SSAS monitoring tools on this site as well.

For some reason, I...

Finally, I can say.....easy peasy!

Are you saying that each month column needs to show data for the current month AND the previous 11 months; or, does the number of "previous months of data to...

I agree with Koen. The KimballGroup states that 5 to 15 dimensions is usually the most common range and that is at the PHYSICAL LEVEL. The only thing...

Sometimes I like to get the point of view from the original folks, Melomed, Gorbach, Berger, and Bateman. Sometimes it is good to hear from the original creators, but I...

Agreed (if that is what the question represents--a rollup of a chart of accounts).

I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my...

Whatever you folks do, don't forget to set the correct attribute relationship types (rigid for type 2 dimension columns and flexible for type 1 and type 3 columns). ...

Are you trying to create a conditional sum?