"As Is" vs "As Was" Reporting Using Type 2 Dimensions
Mark Rittman has a real good writeup on some dimension modeling scenarios, which are always nice to keep in your toolbox.
Reminds me a little of the classic HR Schema (explained by Ralph Kimball), where the Employee Dimension has as many rows as the Fact table, with the benefit of knowing exactly how theings looked at any point in time in the past.

16 Comments:
I give your blog an A+ with a Gold Star! I really enjoy your content and will be back very frequently! I enjoyed the information you had on business intelligence as well. I actually have an business intelligence blog with all kinds of cool things in it. May I put a link to this blog of yours on mine?
This blog is awesome! If you get a chance you may want to visit this inventory management software site, it's pretty awesome too!
I found a new submit article to magazine. Post your Articles, Get Free Content. submit article to magazine
You must get a lot of traffic with a blog this nice! I'll be back for sure. Hey, look at my site over here: handheld instant messaging device. As you can tell, it has to do with handheld instant messaging device! I trust your judgment. What do you think?
This blog is awesome! If you get a chance you may want to visit this download site myspace.com site, it's pretty awesome too!
Informative blog. I have a xhtml css editor blog.
Hi i am totally blown away with the blogs people have created its so much fun to read alot of good info and you have also one of the best blogs !! Have some time check my link to !!Financial freedom realty services
Hi there, Nice little blog you've got going on there. Keep it up! This might interest you if you're after some increase web traffic The contents of this site will explode your increase web traffic
Great Blog, check out this business. This is the Goose that lays you Golden Eggs! business business home home make make money money online online successforfreedom.com
Submit your Articles and get lot of backlinks: http://articles.for-your-website.com/
-----------------------------------------------------------------------------------------------------------------
It's been really great looking and reading your Blog. Any fresh ideas on targeted internet marketing are always welcome to folk like me. You may also be interested in some incredible software that I've seen that really helps in the area of targeted internet marketing.
It can drive thousands of targeted links back to your website or Blog. Well worth looking at.
Hi,
I liked your blog. I found many interesting information here.
I also give free info about affiliate marketing. You can seen it on my affiliate marketing site.
If you have time please visit my web site to get some free affiliate marketing information.
Kind regards,
Nick
To do your marketing for your business you can Marketing with the ebook at Marketing Go and check it out.
Good Posts, Keep on Blogging.
Be sure to visit
Advanced Business Marketing
Expensive Marketing Secrets Free.
Thanks for the info, I added you to my favorites.
If you are interested in home based business insurance
, I have a home based business insurance
site.
Feel free to drop by and tell me what you think.
Hey, you have a great blog here! I'm really enjoying business
I have a internet mortgage lead business site/blog. It pretty much covers internet mortgage lead business related stuff.
based business home idea service
Post a Comment
Links to this post:
Create a Link
<< Home