The Time Dimension in OneStream XF can be set in many different ways (ex: monthly, weekly, 13 month, or custom). It allows data to be separated into tables for each year and creates Time Profiles, which are used to create and assign different Fiscal Years to different Cubes.
A pre-configured Time Dimension allows "smart" time period reference usage in formulas. OneStream XF also allows description labels to be configured under the Time Profiles.
Below are listed some of the basic requirements for the Time Dimension in OneStream XF:
Companies can set up a custom Time Dimension or re-configure a pre-defined Time Dimension via the Time Dimensions node on the System tab.
Pre-defined Time Dimensions generally determine if an application uses a monthly or weekly time period as well as the type of calender used.
Custom Time Dimensions allow users to select a certain number of months in a quarter as well as the number of weeks in a month. These customizations usually are only applicable on new applications.
Please note: Ensure that Fiscal Year Month type changes during migration to properly align with what is set in Time Profiles property.
Below are some best practices for implementing the Time Dimension & requirements:
These are all important questions that should be considered before setting up OneStream XF as different Time Dimension set-ups can affect things like the Cube Design, Application Creation, and so forth.