Flexible Time Restrictions

This topic lists various restrictions for the Flexible Time feature.

Formulas

  • The ResultLookup function is not supported for non-standard time periods such as week-level granularity and user-managed time dimensions.
  • The IF function is not supported for non-standard time periods such as week-level granularity and user-managed time dimensions.
  • The If and ResultLookup functions are only working if member is unique below a single parent. If the member is present under multiple parents, the formulas are invalid.

  • For the CAGR function, years must be integers. 2021.3 or YearOne, for instance, are invalid.

Date Range Restrictions

  • Hierarchies that include non-standard user-managed time dimensions (that use the semantic type Other) won't be available for date ranges.

  • You won't be able to edit the custom current date if you change to a hierarchy that doesn't include the granularity that was previously used. For example, you set a date based on Quarter and then choose a hierarchy that doesn't have Quarter. You can delete the custom current date, but you can't edit it.

  • When you have dates with no value, they will still be included in date range look back.

    For example, your user-managed time dimension has values for weekdays only, not weekends. Your lookback will include the weekend days.

Planning

  • If you are copy and pasting values in a table with a model that is using custom time hierarchies, only the overall values can be pasted to cells with different time hierarchies.

  • When creating copy rules for a copy step in data actions, copying to non-leaf target members on user-managed time dimensions is not supported at this time.

  • If you use a model with user-managed time dimensions to define the context of a calendar event, the filters of the time dimension won't be applied to the attached story.

Stories - Calculations and Other Features in Charts and Tables

  • The Difference From formula won't be supported for the initial release.

  • Variances don't work as expected for hierarchies that include non-standard user-managed time dimensions that use the semantic type โ€œOtherโ€. You will need to choose a hierarchy that uses only standard time dimensions.

Augmented Analytics (Smart Features)

  • Smart Insights is not supported for user-managed dimensions, or dimensions that support week granularity and/or week patterns to show users how data points change over time. Flexible time dimensions are supported for top contributor and calculation insights.

  • Search to Insight will ignore models containing user-managed dimensions, or dimensions that support week granularity and/or week patterns.

Mobile (iOS)

  • Stories containing flexible time dimensions, if set to Optimized iOS mode, can be consumed on supported iOS devices. Stories set to the non-optimized mode are not supported.