PowerPivot and the Slowly Changing Dimensions

Posted by AlbertoFerrari on SQL Blog See other posts from SQL Blog or by AlbertoFerrari
Published on Wed, 09 Feb 2011 07:00:00 GMT Indexed on 2011/02/09 7:30 UTC
Read the original article Hit count: 654

Filed under:

PowerPivot

Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse has a type 2 SCD in the DimProduct table. It can be easily checked for the product code “FR-M94S-38” which shows three different versions of itself, with changing product cost and list price. This is exactly what we can expect to find in any data...(read more)

PowerPivot and the Slowly Changing Dimensions

Posted by AlbertoFerrari on SQL Blog See other posts from SQL Blog or by AlbertoFerrari
Published on Wed, 09 Feb 2011 07:00:00 GMT Indexed on 2011/02/09 15:31 UTC
Read the original article Hit count: 653

Filed under:

PowerPivot

Slowly changing dimensions are very common in the data warehouses and, basically, they store many versions of the same entity whenever a change happens in the columns for which history needs to be maintained. For example, the AdventureWorks data warehouse has a type 2 SCD in the DimProduct table. It can be easily checked for the product code “FR-M94S-38” which shows three different versions of itself, with changing product cost and list price. This is exactly what we can expect to find in any data...(read more)

Related posts about PowerPivot

PowerPivot Workshop: new announcement and early bird expiring soon #ppws #PowerPivot

as seen on SQL Blog - Search for 'SQL Blog'
As always, I am a bit later than Marco in producing news. Nevertheless, I am very excited to tell you the new date for the Frankfurt workshop on PowerPivot: February 21-22, 2011 . Save the date and find all the relevant information on www.powerpivotworkshop.com , where you can also register… >>> More
Installing SharePoint 2010 and PowerPivot for SharePoint on Windows 7

as seen on SQL Blog - Search for 'SQL Blog'
Many people like me want (or need) to do their business intelligence development work on a laptop. As someone who frequently speaks at various events or teaches classes on all subjects related to the Microsoft business intelligence stack, I need a way to run multiple server products on my laptop with… >>> More
Difference between LASTDATE and MAX for semi-additive measures in #DAX

as seen on SQL Blog - Search for 'SQL Blog'
I recently wrote an article on SQLBI about the semi-additive measures in DAX. I included the formulas common calculations and there is an interesting point that worth a longer digression: the difference between LASTDATE and MAX (which is similar to FIRSTDATE and MIN – I just describe the former, for… >>> More
We are hiring (take a minute to read this, is not another BS talk ;) )

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I really wanted to wait until our new website was out to blog about this but I hope you can put up with the ugly website for a few more days J. Tellago keeps growing and, after a quick break at the beginning of the year, we are back in hiring mode J. We are currently expanding our teams in the United… >>> More
Tellago is still hiring….

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Tellago 's SOA practice is rapidly growing and we are still hiring. In that sense, we are looking to for Connected Systems (WCF, BizTalk, WF) experts who are passionate about building game changing solutions with the latest Microsoft technologies. You will be working alongside technology gurus like… >>> More

Developer IT