A private dimension is a regular database dimension, i.e. created in the
Dimensions collection for the database (DSO.MDStore). But the name of the
dimension when you add it to the database must be prefixed with "<cube
name>^". E.g. (in VB6),
Set dsoDim = dsoDB.Dimensions.AddNew("MyCube^private1", sbclsRegular)
Then set the properties on the dimension and create the necessary level(s).
And then add the dimension to the cube, e.g.
(See the topic "Dimension Interface" in SQL Books Online, DSO section, for
Can anyone tell me how to add (using VB) a private time
dimension to a cube via the DSO interface?
The data source for the cube is a single fact table with
time dimension data (a datetime) in the first column and
time correlated (by row) data in the remaining columns.