Subscribe to Windows IT Pro
October 23, 2002 12:00 AM

Analysis Services Interfaces

SQL Server Pro
InstantDoc ID #26678
Rating: (0)

Analysis Services has three programmatic interfaces that you can use from your analysis application. The first two interfaces are client-side interfaces: ADO MD and OLE DB for OLAP. Both of these programming interfaces offer functionality for data exploration, metadata exploration, write-back capabilities, and read-only analysis functions. Only the write-back capabilities affect the contents of the cube that other users in the system share. If you want to make other types of changes to Analysis Services data programmatically, you have to use the administrative programming interface Decision Support Objects (DSO). DSO lets you create and alter cubes, dimensions, and calculated members and use other functions that you can perform interactively through the Analysis Manager application.

Related Content:

ARTICLE TOOLS

Comments
  • stephen clark
    8 years ago
    Apr 27, 2004

    I was expecting to see more detail.
    For example, pros and cons of each, code samples...However, I'm at best a want to be analysis service developer and its good not to be nipped in the bud.

You must log on before posting a comment.

Are you a new visitor? Register Here

advertisement

advertisement

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.