April 2005 - Posts

• Improvements to dimension security in Analysis Services 2005

  What changed with respect to dimension security in Analysis Services 2005 ? A lot ! I will try to touch on most important changes. Attribute based instead of hierarchy based. This is perhaps the most important change. The concept of UDM goes across entire Read More... Posted Sunday, April 10, 2005 12:30 PM by mosha | (Comments Off) Filed under: security

• To quote or not to quote (in expressions of MDX calculations)

  When you write MDX statements to create calculated members, named sets or cell calculations - do you use quotes around the expression or not ? Let's compare the following two statements. CREATE MEMBER Sales.[Measures].[Profit] AS ' [Measures].[Sales] Read More... Posted Saturday, April 02, 2005 1:02 PM by mosha | 1 Comments Filed under: mdx