Configuring thread usage for cube reloads

You can use threading during cube reloads to improve performance during fact row processing, after dimensions have been processed. By default, one thread is used for a cube reload, but you can configure the cube reload to use up to four.

  1. In the Administration Console, select Analytics.
  2. Double-click the cube to configure.
  3. Specify a value between 1 and 4 in the Reload Threads field.
  4. Click Save.
  5. To configure more than four threads or to disable threading:
    1. Select Configuration Parameters.
    2. Click Create.
    3. Specify this information:
      Predefined Component
      Analytics
      Predefined Name Key
      Specify MaxReloadFactRowThreads to configure more than four threads, or DisableReloadFactRowThreading to turn off threading.
    4. If you specify MaxReloadFactRowThreads, specify the maximum number of threads to use during cube reload in the Value field. The maximum value is 10.
    5. If you specify DisableReloadFactRowThreading, set the Value field to true to turn off threading.
      Note: Use DisableReloadFactRowThreading only if recommended by Customer Support.
    6. Click Save.
    After reloading cubes, you can check the reload log screen for the Duration HMS values to compare run times across reloads and to asses the impact of threading. The operation performed during a reload is detailed in the Results section and the distribution of fact rows across each thread is detailed in the Statistics section.