flex.bi automatically creates two hierarchies in the "Time" dimension - default and weekly.
...
Set the unique hierarchy name for your calculated hierarchy [1].
Specify the hierarchy's levels as a selection from predefined levels Year, Quarter, Month, Week, and Day [2].
The custom JavaScript code should calculate the numeric value of the display name value for each level of the date [3].
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.
...