IsTemporary (Dimension Interface)
Note
This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.
The IsTemporary property of the Dimension interface indicates whether an object is temporary. Temporary objects are local to the session in which they are created, cannot be saved, and are not available to other users. To create a temporary dimension object, preface the name with the tilde (~) character.
Applies To:clsAggregationDimension, clsCubeDimension, clsDatabaseDimension, clsPartitionDimension
Data Type
Boolean
Access
Read-only
Remarks
A temporary object is not stored in the repository and is not available to other users. Temporary objects persist only during the session in which they are created, unless they are renamed or cloned to another object that has the same class type. Objects that are subordinate to a temporary object, such as levels for a dimension, internally inherit the IsTemporary setting of the parent object.
Note
Only temporary objects can be renamed by changing the Name property. Removing the tilde character from the name of a temporary object means that it is no longer temporary and prevents any subsequent renaming of the object. Also, executing the Update method of a temporary object has no effect. The object is not saved to the repository until it is renamed without the tilde prefix.
Example
Use the following code to create a temporary dimension and then make it permanent:
' Assume an object (dsoCube) of ClassType clsCube exists.
Dim tmpDim As DSO.Dimension
' Create a temporary dimension, using the tilde character in
' the dimension name.
Set tmpDim = dsoCube.Dimensions.AddNew("~MyDim")
' Add levels, add member properties, process, and so on.
' If you want to save the dimension permanently,
' drop the tilde prefix.
tmpDim.Name = "MyDim"
' Update the dimension.
tmpCube.Update