Hi there

Hope some can help. I currently have about 70 calculated
cells. I have just changed one of the dimensions in the
cube and instead of going through each of these calculated
cells I would like to know the tables/datafiles where this
information is stored so that I can write a routine to
update all this information in one go.

Thanks

Garron

You can retrieve and update Calculated Cells definitions
through the DSO Command object. There is a Commands
collection associated with each Cube, which you can use to
cycle through the definitions (not all Commands will be
Calculated Cells, though). See the DSO documentation for
details. By the way, the definitions are stored in the
repository, but you certainly don't want to directly
update this data.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html