Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Command
Download Now
This paper presents seventeen reasons why the Analysis Services Scripting Language (ASSL) is better than the Create Global Cube command in creating local cubes in Analysis Services for SQL Server 2005 (2008). Did you know that:
-
Local cubes created with ASSL can include features not allowed in cubes created with Create Global Cube, such as Distinct Count measures?
-
Local cubes created with ASSL can be much smaller and can be created much more quickly than local cubes created with Create Global Cube?
-
Local cubes created with ASSL can be encrypted, while Create Global Cube local cubes can not?
If you've had problems creating local cube files in the past, read this paper to learn how to create them effectively now.
Read this paper online in
HTML format.