CompleteStopMessage

First section

The first section of the CompleteStopMessage provides this information about the execution:

  • The name of the cube and the internal ID of the rule.
  • The first number after Cells is the number of returned cells with a value.
  • The second number after Cells is the number of cells in the area that was requested.
  • The third number after Cells is the number of areas that were calculated to pre-fetch the input value for the rule.
  • The fourth number after Cells is the number of input values that were pre-fetched.
  • The first value after Time tells how much time (in ms) was spent in pre-fetching the values.
  • The second value after Time is the time spent in the calculation part of the rule. It does not include the pre-fetch times but it does include the time to fetch values during the calculation. If nothing has been pre-fetched, this is printed as well.
  • It is written if the primary required missing condition is applied and if the Leapfrog triejoin algorithm is used.
{"completeStopMessage":"(#4,0)Rule:\tSALES:7 \tCells: \t18488 \t367416 \t6 \t18605 \tTime:\t110\t78\t ms\r\nNot prefetched: \t9573\r\nPrimary required missing was active.\r\nTriejoin sweep was inactive.\r\nParam vector count: \t18603\r\n

Second section

The second section writes the rule. It is preceded by a character that identifies on which kind of cells the rule is active. The options are all (A:), basic (B:), or consolidated (C:) cells.

This example calculates the revenue in the Profit dimension for local currency. After the rule, it also displays which references were used for the rule calculation.

B:[CURRTYPE:\u0027LC\u0027, PROFIT:\u0027Revenue\u0027]=[PROFIT:\u0027Sales Volume\u0027] *\r\n[PROFIT:\u0027Price per Unit\u0027];\r\nReference (0):\t8915\t0\t1\t123\t PROFIT:\u0027Sales Volume\u0027] * [CURRTYPE:\u0027LC\u0027, PROFIT:\u0027Price per Unit\u0027]\r\nReference (1):\t32472\t0\t1\t123\t[CURRTYPE:\u0027LC\u0027, PROFIT:\u0027Price per Unit\u0027]\r\n

Third section

The third section of the CompleteStopMessage provides information about the execution. It also shows the number of cells in each area.

Calculations of IF statements with single-dimensional conditions are broken up into different areas.

Rule area #0\t cells:\t52488\t References:\t2\r\nRule area #1\t cells:\t314928\t References:\t3\r\n"}