Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

flex.bi automatically creates two hierarchies in the "Time" dimension - default and weekly.

...

  1. Set the unique hierarchy name for your calculated hierarchy [1].

  2. Specify the hierarchy's levels as a selection from predefined levels Year, Quarter, Month, Week, and Day [2].

  3. The custom JavaScript code should calculate the numeric value of the display name value for each level of the date [3].

  4. Test the custom hierarchy on specific dates [4].

...

The JavaScript code should include the return statement containing a numeric value and name value for each level. We expect to have positive numeric values with a position of each date within each hierarchy level. The name value should contain the unique member name. Use a Time data type variable timeValue to address any date. 

...