Updates one or more properties of the specified dimension.
Update Dimension
Properties(ApplicationName, DimensionName, PropertyName)
Values('Comma', 'C_Entity', 'Validation');
ApplicationName—The name of an existing application. Use #Shared to update a dimension in the Shared Library.
DimensionName—The name of an existing dimension.
PropertyName—The name of the property to update. (You can list as many properties as desired, however, you must include a valid value for the property.)
For Oracle Hyperion Planning, Fusion Edition applications, you can use the Update Dimension command to modify the dimension order to optimize application performance. For example:
Update Dimension
Properties(ApplicationName, DimensionName, Plan1PerfOrder)
Values('myApp', 'Account', '1');Plan1PerfOrder—The dimension order for Plan 1, where Plan1 is Plan1, Plan2, or Plan3.