December 2005 - Posts

• Default members, MDX Scripts, Security, KPIs and Perspectives

  What happens to the cube after the processing is complete but before cube is ready for the querying ? There are actually quite a few steps that should be taken in order to prepare the cube, like create calculated members and named sets, apply security, Read More... Posted Saturday, December 31, 2005 12:00 AM by mosha | 3 Comments Filed under: ssas

• Performance of multiplication in MDX

  What can be simpler then the expression A*B. Yet there is enough interesting staff going on around it to warrant an article. By investigating this simple expression we will get an insight into Analysis Services MDX query optimizer, discuss performance Read More... Posted Tuesday, December 06, 2005 7:11 PM by mosha | 3 Comments Filed under: mdx

• Analysis Services 2005 protocol - XMLA over TCP/IP

  It has been widely publicized that Analysis Services 2005 uses XML for Analysis 1.1 (XMLA) as its only network protocol for communication between client and server. XMLA is standard public protocol defined by XMLA council and full description can be found Read More... Posted Friday, December 02, 2005 1:48 AM by mosha | 2 Comments