Calendar is a multi-purpose workbench that perform various actions like
- View existing calendars in the model
- Generate new Calendars in the model (Including extending existing calendars)
The Calendar Workbench is displayed below
Time Dimension Selector allows to select the desired time dimension from those available
Data tab allows to view the calendar data for the selected dimension
Generator tab allows to create new calendars for the dimension selected or to extend calendar dates
Purge deletes the calendar records for the dimension selected
Throughput & WIP added to Load Details Chart
- The Load Details graph which is available as a drilldown from Capacity Report has additional options from the graph context menu to display the Throughput & WIP in the graph.
- Select the measure to display in the graph and pick the available graph type to be displayed.
Pivot Workbench
Pivot View is now available as a workbench type to display reports.
Standard workbenches like Inventory Summary and Capacity Summary are based on pivot view.
Below is a sample pivot view.
Pivot Fields Area which includes row fields, column fields, data fields and filter field areas
Static Filters to quickly from a pivot workbench
Settings and Preview Mode
Data Section which includes any conditional formatting applied
Improvements
Columns in Schema Wizard can be created from a CSV file that can be uploaded through Step 2 of the wizard.
- Click the Upload CSV button and select the csv file.
- The headers from the csv file are created as columns for the table.
- Betelgeuse 05/10
Preview Mode for TGrid & Pivot
Preview mode support added for TGrid & Pivot Workbenches.
Click on the preview button in TGrid or Pivot to open the preview panel at the bottom of the screen.
Required Fields indicated in Import
During Import of data into a Grid through the Import button available through Table options, the Import File popup now displays information to identify which fields are required fields for the destination table.
