SQL Server supports storing metadata as Extended Properties against
database objects such as columns, tables etc

Does anyone know whether it is possible to store Extended Properties
against OLAP objects (e.g. cubes, dimensions, measures etc) in the
same way?

It would be great to use DSO to extract all the info about OLAP
objects and include any user entered descriptions against dimensions,
measures etc. Does anyone know of any resources covering this?

BOL doesn't appear to say anything about extended properties on OLAP
objects.

I want make documenting my data warehouse as easy as possible and
storing object level documentation in the db seems that best way to go
for ease in keeping documentation up to date.

Thanks
Mark

I started down this path and created 85% of an Access database which reads
the
dimensions/cubes for the purpose of creating documentation and then got
sidetracked.
However I know you can use the description
field (which is on most objects) to store a paragraph about a level in a
dimension etc...
Except calculated measures don't have a description field (which is the main
place you need
a description).

I didn't look any further since that covered my needs.

Tom chester has a free Excel program that does some documentation. Also I
think there
are some pay services and other examples out there.

HTH,
Mark

"Mark Cottier" <mcottier (AT) igrp (DOT) co.uk> wrote