![]() ![]() Setting for additional hierarchy with rolling months. These results require the inclusion of normal base elements in the current year hierarchies. quarters, fiscal year offset and additional elements will be identical. This makes it easier to switch from one variant to the other. "2017_YTD", will be identical to the structure for a year element, e.g. If "full parallel hierarchy" is turned off, the structure of a total-year element, e.g."2017_YTD", will be the sum over all months. The value of a total-year element, e.g.The additional hierarchies are generated to achieve the following results: For each current-year hierarchy, a different hierarchy with separate root nodes is created (e.g."All months") to gain easy access to all "normal" elements. One dedicated hierarchy that contains no current-year hierarchies (e.g.If the option is checked, the following structure will be created: Month-to-go: the values of a month will be accumulated from a date up to the end of the month.įull parallel hierarchies: this option allows you to place YTG or YTD elements under special root-level elements.Month-to-date: the values of a month will be accumulated from the beginning of the month up to a certain date.Quarter-to-go: the values of a quarter will be accumulated from a date up to the end of the quarter.Quarter-to-date: the values of a quarter will be accumulated from the beginning of the quarter up to a certain date.Year-to-go: the values of a year will be accumulated from a date up to the end of the year.Year-to-date: the values of a year will be accumulated from the beginning of the year up to a certain date.Special periods (possible values: 13, 14, 15, or 16).Additional data element on month level (yyyy-MM-~).Additional data element on year level (yyyy-~).Sets additional hierarchy with fiscal year elementsĬreates additional elements for the checked options: Sets the levels for which elements will be created: See Assigning Dimension Types for more information.Īfter setting the dimension type, the Time Editor tab appears. Note: after defining the type “Time” for a dimension, the type cannot be changed again. This can be done in the Advanced section of a dimension’s properties page. To enable the Time Editor, you must first assign a specific dimension to the type “Time”. Besides generating an element hierarchy based on the user's settings, the Time Editor will also create several attributes with additional information about the time dimension’s elements. The Time Editor can rapidly create a time-based dimension while defining various settings. ![]()
0 Comments
Leave a Reply. |