February 2009 - Posts

• SSAS: Reference materialized dimension might produce incorrect results

  Reference dimensions let you create a relationship between a measure group and a dimension using an intermediate dimension to act as a bridge between them. In the Adventure Works demo, for example, they are used to link reseller sales and orders to the Read More... Posted Wednesday, February 25, 2009 3:59 PM by AlbertoFerrari | 13 Comments Filed under: Dimensional Model, SQL Server, SSAS

• Measure Tool – Making SSAS measures physical to apply security

  The security model of SSAS prevents us to apply security limitations to calculated members. We can hide physical members but we have no means to hide calculated members to any role. By preventing access to the physical measures, the user will not be able Read More... Posted Thursday, February 05, 2009 12:18 PM by AlbertoFerrari | 7 Comments