Hornet Dear Bernard

Dear, Dear Bernard

Posts Tagged ‘olap

MDX Function Reference (MDX)

leave a comment »

MDX Function Reference (MDX).

All the MDX functions that SQL Server supports

Written by bernardhornet

June 14, 2011 at 10:20 am

Posted in Uncategorized

Tagged with , , ,

Business Intelligence 2.0

leave a comment »

Business Intelligence 2.0:

Marketing term defined as:

Business Intelligence 2.0 (BI 2.0) is a term that refers to new tools and software for business intelligence, beginning in the mid-2000s, that enable, among other things, dynamic querying of real-time corporate data by employees, and a more web- and browser-based approached to such data, as opposed to the proprietary querying tools that had characterized previous business intelligence software.

Written by bernardhornet

March 7, 2011 at 3:01 pm

Posted in Uncategorized

Tagged with ,

Retrieving Data From Multiple Cubes in an MDX Query Using the Lookupcube Function

leave a comment »

Retrieving Data From Multiple Cubes in an MDX Query Using the Lookupcube Function:

Courtesy of Dustin Ryan, hitman/ ninja assassin for Pragmatic Works

Written by bernardhornet

March 7, 2011 at 2:56 pm

Posted in Uncategorized

Tagged with ,

One Cube vs Multiple Cubes

leave a comment »

One Cube vs Multiple Cubes :

Some interesting commentary by one of the authors of Expert Cube Development with SSAS 2008

Written by bernardhornet

March 7, 2011 at 2:56 pm

Posted in Uncategorized

Tagged with ,

MDX Query from two or more cubes???

leave a comment »

MDX Query from two or more cubes???:

A little history, and although not recommended, how to do it.

Written by bernardhornet

March 7, 2011 at 2:55 pm

Posted in Uncategorized

Tagged with ,