Using the RefreshMdxHierarchy TurboIntegrator Function with Named Levels

After configuring or editing the named levels in the }HierarchyProperties control cube, use the RefreshMdxHierarchy function to update the MDX hierarchies in the TM1® server without requiring you to restart the server.

Procedure

  1. Create a new TI process.
  2. Enter the RefreshMdxHierarchy function on the ProLog tab using the following format:
    RefreshMdxHierarchy(dimensionName)

    where the optional parameter, dimensionName, can either specify a specific dimension to update or can be blank to update all dimensions.

    For example, to update all dimensions:

    RefreshMdxHierarchy('');

    To update only the customers dimension:

    RefreshMdxHierarchy('customers');
  3. Run the TI process.