Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Dec 2, 2002

MSDN Webcast: OLAP for Developers Using SQL Server 2000 Analysis Service

By DatabaseJournal.com Staff

Live Event: December 2, 2002 - 1:00pm to 2:30pm Pacific Time / 4:00pm Eastern Time.

SQL Server 2000 has many new features for developers using OLAP (online analytical processing). OLAP databases are different than relational databases, so you execute queries against SQL Server 7 OLAP Services using a language other than SQL, specifically MDX (Multi-Dimensional eXpression). In addition, ADO and ADO MD (Multi-dimension) are related but separate object models.

ADO MD provides objects for retrieving multidimensional data and viewing multidimensional schema metadata so this session will look at how to use ADO MD and MDX for detailed drill through of OLAP cubes. We'll see how to create analysis services for web applications and the use of actions to allow users to act on cells within the cube.

We'll also use ADO MD to query an OLAP cube and manipulate the result set and use the DRILLTHROUGH statement to access detail rows. This session will also examine the ADO MD architecture, including the PivotTable Service and OLE DB for OLAP as well as the ADO MD object model, specifically concentrating on the Cellset and Axes objects.

Additional information for this Webcast is available at http://www.microsoft.com/usa/webcasts/upcoming/1300.asp.

Back to Database Journal Home

Database News Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM