How many Time Dimension Profiles are allowed per cube?

Each cube in OneStream can have only one Time Dimension Profile associated with it. This is fundamental because the Time Dimension Profile governs how time data is managed within that particular cube. It defines essential aspects such as the granularity of time, the length of the periods, and the structure for time-related attributes. Having a singular Time Dimension Profile helps maintain clarity and consistency in time-based data analysis and reporting within the cube, ensuring that all calculations and data visualizations adhere to a standardized approach.

While it may seem beneficial to have multiple profiles for varied analytical needs, this would complicate data management and potentially lead to discrepancies in time-related data interpretations within the cube. The design choice to allow just one Time Dimension Profile is thus practical, aligning with best practices for data integrity and simplification in data operations. This allows users to focus on reliable time-based metrics without confusion arising from multiple time profiles.