New Planning Center for Insights into Your Model
With the 2024R1 Release, we provide a new tile called Planning Center in the Modeling area. From the Planning Center, we enable to use:
- Configuration Metrics: Keep an eye on the main elements in your model. Color coding helps you pinpoint the areas of the model that present the most risk to performance.
- Sheet and Report Metrics: Track performance and usability of reports and sheets. Usage metrics offer you a better understanding of the adoption and usage patterns of your team.
You can review the metrics for a day or for a time range. From the toolbar, you can select a 31-day time range within the previous 90 days.
The Planning Center is not available to customers in Singapore at this time.
Watch the Video:
4m 15sConfiguration Metrics
Release: 2024-03-09
We now provide Configuration Metrics in the new Planning Center section of Modeling to help you monitor changes to your model over time and provide insights to possible performance issues.
In the Configuration Metrics, we provide the following metrics as KPI charts:
- Levels, including parents and leaf levels.
- Versions
- Dimensions
- Dimension values
- Dimension attributes
- Sheets, both user-assigned and level-assigned.
- Snapshot reports
- Shared reports
- Custom accounts
- Cube Calculated Accounts
- Modeled Calculated Accounts
- Linked Accounts
You can review the metrics for a day or for a time range. From the toolbar, you can select a 31-day time range within the previous 90 days. Each chart displays the number of values, according to the selected time range, with a line graph that displays changes over time. We also provide color indications that let you know when your current numbers are above or below our benchmarks.
Sheet Metrics
Release: 2024-03-09
We provide a new Sheet Metrics section in the new Planning Center section of Modeling. With Sheet Metrics we enable you to review the performance and usage patterns of your sheets. You can review the metrics for a day or for a time period that you define.
We provide these details:
- Name: The name of the sheet.
- Type: The type of sheet — standard, modeled, or cube.
- Views: How often the sheet was opened.
- Distinct Views: How many unique users opened the sheet.
- Saves: How often people saved changes to the data in the sheet.
- Average Time to Open: How long it takes to load the sheet based on the actual performance.
- 95pct Time to Open: How long it takes to load the sheet in the worst case scenario, after ignoring the top 5% to remove anomalies and outliers.
See Check Sheet Metrics.
Report Metrics
Release: 2024-03-09
We provide a new Report Metrics section in the new Planning Center section of Modeling. With Report Metrics we enable you to review the performance and usage patterns of all shared reports and snapshots in your model. You can review the metrics for a day or for a time period that you define.
We provide these details:
- Name: The name of the report.
- Type: The Type of the report — matrix, model, pattern, or transaction.
- Views: How often users viewed the report.
- Distinct Views: How many unique users viewed the report.
- Average Time to Open: How long it takes to load the report based on the actual performance.
- 95pct Time to Open: How long it takes to load the report in the worst case scenario, after ignoring the top 5% to remove anomalies and outliers.
See Check Report Metrics.
New Planning Center Permission
Release: 2024-03-09
We provide the new Planning Center permission within the Model Management Access permission set in the Administration area. The permission enables users to access the Planning Center in the Modeling area.
Add this new permission to existing permission sets to provide access to the Planning Center.
Search Bar for Sheet and Report Metrics
We now provide a new search bar in Sheet Metrics and Report Metrics. For your convenience, you can filter the sheets and reports based on your typed input.