The time grid attribute is useful for financial planning.
For example, you can use it to calculate costs and revenue for a business
case.
Using time grid attribute, you can:
- Adapt the time grid attribute to any number of scenarios, and
you can use it to consider different timing and other factors on each
sheet.
- Visualize the time grid values as graphics in lines or vertical
bars.
- Show one or several sheets in the same visualization and select
the rows to be included in the charts.
- Edit one row or all rows for all sheets simultaneously.
- Display the summary column to show the sum of values in a column.
- Compare time grids faster and with ease.
- Display the time grid overview (charts or tables) in the attribute
list without having to open the editor. Edit the settings for the
time grid in the attribute list.
A time grid attribute consists of one or more sheets with
individual time lines. Each sheet displays a grid with its time line
as column headings and a common set of row titles.
Each sheet is configured for a specific scenario, with a name,
time interval (month, quarter, or year), start date, and end date.
A time grid attribute can have multiple sheets, each with an individual
time line and cell values. The cells can be empty or can contain a
number or an expression. You can use numbers, and expression for time
grid cells. You can reference the first and the last column with date
attributes.
The time grid attribute can initially be configured
with summary rows, headings, and locked rows. Summary rows are headings
that display the sum of the cell values of all of the rows below the
heading until the next heading is displayed. The summary rows are
always locked.
Tips: - Avoid configuring a time grid attribute with the summary row that
is placed as the last row. Summary row is used to sum the values of
rows below the row until the next header row. The rows that are above
the summary row are not considered.
- A time grid displays entire time intervals, even if the start
and end dates of a sheet are in the middle of the interval. For example,
if a sheet is configured to display quarters and the end date is 2
April, the entire time period (in this case the quarter) is displayed
in the sheet.
- You can select a number of cells in a sheet and paste them into
a spreadsheet application or in another position in the current time
grid sheet.
Time grid limitations
The time grid attribute
has the following limitations:
- Time grid is supported only by REST web services.
- Time grid cannot be the basis for filters.
- You cannot compare baselines for the time grid attribute type.
- The import and export of time grid attributes is limited to workspaces
and modules.
- You cannot access time grid sheets from views on the Home page,
from a view displayed as a table structure, or from the pairwise comparison
pages in the Prioritize view.
- You cannot search for a value in a time grid cell.