June 2005 - Posts

• How to check if cell is empty in MDX

  Recently I was looking at cube from customer, which had hundrends of calculated members. I noticed, that many of them were simple ratios in the form of a/b. However the consultant who developed these calculated members wanted to avoid division by zero Read More... Posted Thursday, June 30, 2005 11:12 PM by mosha | 1 Comments Filed under: mdx

• Loading data from SAP BW into Analysis Services

  In this whitepaper Hermann Däubler he exlplains step by step how to load data from SAP BW into Analysis Services cube using SAP's Open Hub Services. To me SAP BW always looked like something very complex that I didn't even know how to approach, so I was Read More... Posted Monday, June 13, 2005 11:07 PM by mosha | (Comments Off)

• What is 'MDX Missing Members Mode' in Analysis Services 2005 ?

  There were many enhancements in Analysis Services 2000 to make MDX closer to SQL, both syntactically and semantically. After all, UDM is the model for both relational reporting and multidimensional analysis, and in order to support relational reporting Read More... Posted Thursday, June 09, 2005 9:28 PM by mosha | (Comments Off) Filed under: mdx

• Migration whitepaper from AS2000 to AS2005

  There is a new whitepaper titled " Analysis Services 2005 Migration " written by Michael Young for Proclarity. It really consists of three parts. First part is an overview of Analysis Services 2005 features such as attribute hierarchies, related Read More... Posted Wednesday, June 08, 2005 10:35 AM by mosha | (Comments Off)

• Analysis Services 2005 Brings You Automated Time Intelligence

  Rob Zare's and mine article " Analysis Services 2005 Brings You Automated Time Intelligence " is published in the June's issue of SQL Server Magazine. However it is accessible to everyone on the Web, you don't need to have subscription (Rob Read More... Posted Tuesday, June 07, 2005 10:19 AM by mosha | (Comments Off)