It is common practice to include both RowStartDate, RowEndDate, and RowIsCurrent. Here is Kimball Group's (Warren Thornwaite) thinking regarding "RowChangedReason" along with the code to do it:

http://www.kimballgroup.com/2006/06/01/design-tip-80-adding-a-row-change-reason-attribute/

Are you trying to remove the display of values from the rows in your pivot table; or, are you trying to do something else?

So, for each year, you would like to calculate that year's total divided by the previous year's total?

My team (Phillies) is still enjoying their fall from grace--and probably their Medicare checks as well! I just can't believe Ruben Amaro (a.k.a. Ruin T'Maro) still has a job. Almost...

LOL....strong word. Are you sure it is not MDX that...

I'm with Ron here regarding both the skill set volume and "cube anarchy". I can definitely understand different VERSIONS of a FEW cubes to avoid version collisions, but you will...

When new to a verticial industry, I like to go with the Naive Bayes algorithm to learn about the data. It is the least complex algorithm, but ALWAYS test with...

Tabular Performance: http://msdn.microsoft.com/en-us/library/dn393915.aspx

Deciding which model to pick: http://msdn.microsoft.com/en-us/library/hh994774.aspx

The short version of why to use Tabular.....if you want to do quick data profiling, proofs of...

You can also use the File Watcher Task on SQLIS.com if you are willing to go that route:

http://www.sqlis.com/post/file-watcher-task.aspx

Inventory measures are usually modeled based on:

1. A periodic snapshot fact table at a daily or monthly date grain and sometimes.....

2. An accumulating snapshot done for the current month.

A semi-additive...

Not sure if you are using the multidimensional (classic) or the tabular model. There is a separate performance guide for the tabular model of SSAS 2012, along with advice on...

For advice on administration check out the SSAS Operations and Performance Guide:

http://dennyglee.com/2012/06/28/microsoft-sql-server-analysis-services-multidimensional-performance-and-operations-guide/

Storing the current and previous day as metadata is also common practice (in some circles) with SQL Server Analysis Services (date dimension) and Powerpivot, and it is also demostrated in...

The re-writing of the 2005 engine was done by Microsoft, but yes, the original product was created in 1994 in response to a British Publishing Company's request to have an...

Great question. Great analysis. Great follow up.