Object Names in Schema Rowsets

OLE DB Programmer's Reference

All object names are strings. That is, the _NAME and _UNIQUE_NAME columns in the schema rowset are strings.

Each schema rowset deals with a particular object in the multidimensional data model: catalog, schema, cube, dimension, hierarchy, levels, members, or properties. Many schema rowsets contain columns of the following types: _NAME, _UNIQUE_NAME, _CAPTION, and DESCRIPTION. These four concepts are related but not identical.

Consider the entry in the MEMBERS rowset for the city of Portland, Oregon. The MEMBER_NAME column will contain "Portland". The MEMBER_UNIQUE_NAME column has "USA.Oregon.Portland". The qualification is necessary because just the name "Portland" is ambiguous—there is another Portland in the state of Maine. However, a provider is not required to generate a unique name by the qualification. It is free to generate it in any way. The only requirement is that it must be unique. The MEMBER_CAPTION column is anything that the DBA considers to be a displayable name: For instance, it could be "Portland" or "Portland, the city of roses." The DESCRIPTION column is a string that literally can be anything. Consumers typically use the CAPTION column for display. The UNIQUE_NAME column is used for querying and for restricting other schema rowsets.

The concept of UNIQUE_NAME applies to all multidimensional schema objects except the catalog, schema, and cube names. For these objects, the consumer is required to provide the qualification, if needed.

Note   For providers that generate unique names using qualification, each component of a UNIQUE_NAME should be delimited. For more information, see "Delimited Identifiers" in Chapter 22: OLE DB for OLAP Concepts.

The schema rowset of the schema object (from dimension on down) contains columns for the UNIQUE_NAME values of all its ancestor objects (up to and including the dimension, but not the cube, schema, or catalog). It has a column for its name (NAME) and for the display caption (CAPTION).

1998-2001 Microsoft Corporation. All rights reserved.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net