Cube-formulas, Advanced

Link: ...


Two ways to define a simplified view:

1. Create a Hierarchy - SQL Server



2. Create a Perspective - PowerPivot




Link: DAX Studio

Master Data - Model, Semantics + Excel Add-in

Article, MasterData add-in (terminology).


Why Master Data Services is needed:

Link: background, Importance of Data quality,