November 2004 - Posts

• Typed member properties and MDX .Properties function

  After my previous post I got some questions about whether it will be possible to use .Properties MDX function in AS2005 in order to get true data type of the property and not the string. While it is easy to give a simple answer to this question (yes, Read More... Posted Saturday, November 13, 2004 8:43 PM by mosha | 0 Comments

• Comparing Levels in MDX and CONDITION vs. SCOPE in cell calculations

  A follow up to the “ Comparing Members in MDX ” blog (archived here ). I just run across a thread on OLAP forum hosted at sql.ru, where someone makes a suggestion to exclude level from calculation by applying this formula: [Products]. CurrentMember.Level.Name Read More... Posted Tuesday, November 09, 2004 1:57 PM by mosha | 0 Comments

• Converting Strings to Numbers in MDX or StrToValue vs. Val

  In Analysis Services 2000 there often a need to convert string to number. Usually it happens when there is a level which has member property, and the values for that member property represent some number. For example, in the FoodMart 2000 sample database, Read More... Posted Tuesday, November 09, 2004 10:23 AM by mosha | 1 Comments

• Comparing members in MDX

  Often I run across MDX expressions which require to apply different formulas based on whether or not current member is some hierarchy is equal to some particular member. For example, we may need to check whether current time member is the very first month, Read More... Posted Thursday, November 04, 2004 10:14 AM by mosha | 2 Comments