Slowly Changing Dimensions handling in PowerPivot (and BISM?)

Posted by Marco Russo (SQLBI) on SQL Blog See other posts from SQL Blog or by Marco Russo (SQLBI)
Published on Thu, 10 Feb 2011 14:06:00 GMT Indexed on 2011/02/10 15:31 UTC
Read the original article Hit count: 255

Filed under:

DAX

|

PowerPivot

During the PowerPivot Workshop in London we received many interesting questions and Alberto had the inspiration to write this nice post about Slowly Changing Dimensions handling in PowerPivot. It is interesting the consideration about SCD Type I attributes in a SCD Type II dimension – you can probably generate them in a more dynamic way in PowerPivot (thanks to Vertipaq and DAX) instead of relying on a relational table containing all the data you need, which usually requires a more complex ETL process....(read more)

© SQL Blog or respective owner

Related posts about DAX

Optimize SUMMARIZE with ADDCOLUMNS in Dax #ssas #tabular #dax #powerpivot

as seen on SQL Blog - Search for 'SQL Blog'
If you started using DAX as a query language, you might have encountered some performance issues by using SUMMARIZE. The problem is related to the calculation you put in the SUMMARIZE, by adding what are called extension columns, which compute their value within a filter context defined by the rows… >>> More
DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

as seen on SQL Blog - Search for 'SQL Blog'
The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that… >>> More
Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions

as seen on SQL Server Central - Search for 'SQL Server Central'
Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series… >>> More
Stairway to PowerPivot and DAX - Level 3: The DAX DISTINCT() Function and Basic Distinct Counts

as seen on SQL Server Central - Search for 'SQL Server Central'
Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot… >>> More
Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

as seen on SQL Server Central - Search for 'SQL Server Central'
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs. Save 45% on our top SQL Server database administration tools. Together… >>> 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
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
Back from Teched US

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
It's been a few weeks since I last blogged and, trust me, I am not happy about it :( I have been crazily busy with some of our projects at Tellago which you are going to hear more about in the upcoming weeks :) I was so busy that I didn't even have time to blog about my sessions at Teched US last… >>> More