Thursday, May 24, 2007

Questions and Answers about Using Local Cubes to Improve Browsing Speed Performance

 

How can I create local cube files?
There are two ways to create local cube files in Analysis Services 2005. The easier way is to use a command called CREATE GLOBAL CUBE. A more complex (and more flexible) way is to use Analysis Services Scripting Language (ASSL). CubeSlice 9 supports two forms of ASSL – one that uses the Analysis Server cube as the data source and the other that uses the relational data source. The CubeSlice Relational ASSL usually offers more flexibility in creating local cube files.
For more information on the creation of local cube files, download the document Using Local Cubes with Microsoft SQL Server 2005 Analysis Services from this website.

Source: Questions and Answers about Using Local Cubes to Improve Browsing Speed Performance

No comments: