Convert a dynamic set to static

You can convert a dynamic set to a static set in the set editor. When you convert to a static set, the MDX expression that generated the dynamic set is deleted and the set contains only the members that are present at the time of conversion.

About this task

Converting a dynamic set to a static set is useful when you added a calculation to a dynamic set, but want to control the positioning of the calculation in the set. When you add a calculation to a dynamic set, the position of the calculation in the set is determined by the MDX expression and the position cannot be changed. When you convert to a static set, you can move the calculation to any location in the set.

Procedure

  1. Open the dynamic set in the set editor.
  2. In the Current set pane, click Convert to static.
    Convert to static option is in the toolbar of the Current set pane
  3. Click Apply.