Microsoft KB Archive/323048

= INF: Using Data Definition Language with SQL Server 2000 Analysis Services Client Applications (White Paper) =

PSS ID Number: 323048

Article Last Modified on 6/9/2002

-

The information in this article applies to:


 * Microsoft SQL Server 2000 Analysis Services SP1

-



This article was previously published under Q323048



SUMMARY
SQL Server 2000 Analysis Services Service Pack 1 (SP1) greatly expands the capabilities of client applications to provide local online analytical processing (OLAP) and data mining functionality while simplifying the data definition language (DDL) syntax that client applications need to incorporate such functionality.

This white paper has two parts: The first part describes the basic concepts with which you should be familiar when you are using the DDL for Analysis Services, such as slicing and derived dimensions, and it provides detailed examples that demonstrate each concept by using the new and enhanced DDL syntax. The second part describes the changes and additions to the DDL for Analysis Services, with each statement described in a separate section that also includes usage considerations and examples.

This white paper also includes an appendix that contains examples of the CREATE CUBE and CREATE GLOBAL CUBE syntax, which demonstrate the differences between the two statements. All examples in this white paper use the FoodMart 2000 sample database (FoodMart 2000.mdb) that is provided with Analysis Services.

To see this white paper, please visit the following Microsoft Web site:

Using Data Definition Language with SQL Server 2000 Analysis Services Client Applications

Included in this document:
 * Data Definition Language Concepts
 * Slicing
 * Derived Dimensions
 * Statement and Function Reference
 * CREATE GLOBAL CUBE Statement
 * CREATE SESSION CUBE Statement
 * ALTER CUBE Statement
 * VisualTotals Function
 * DROP VISUAL TOTALS Statement

Additional query words: whitepaper

Keywords: kbinfo kbwhitepaper KB323048

Technology: kbAudDeveloper kbOLAPSearch kbSQLServ2000ASSP1 kbSQLServ2000Search kbSQLServSearch

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© 2004 Microsoft Corporation. All rights reserved.