Zum Hauptinhalt wechseln
Dokumentation
Dokumentation
Adaptive Planning
Change Timespan Display on Sheets

Change Timespan Display on Sheets

  • To display rollups for alternate calendars, ensure that your administrator imports the alternate calendars in Model Administration.
  • Security:
    Access Sheets
     permission.
You can hide time periods on sheets using your display options for any sheet with a timespan. When you save the sheet, you save the display option changes as your preferred view. You can still reset back to the default view:
  • From sheets, you reset to the default view that your administrator configures.
  • From dashboards, you reset to the default view that the dashboard owner configures.
  2. Select
    Display Options
     on the toolbar.
  3. As you complete the
    Time
     tab, consider:
    Option Bezeichnung
    Calendar
    Select an alternate calendar to display rollups for times that are different from your primary calendar.
    To maintain data integrity when you view alternate calendars, we prevent you from:
    • Adding a row.
    • Copying a cell value and pasting.
    • Copying a row and pasting.
    • Drilling into transactions.
    • Using Cell Explorer.
    You can still save this alternate calendar selection as your user view state.
    Start
    End
    Select the time range that you want to display.
The current date is 2017-05. You want to change your timespan display options to either:
  • Start with 2017-01 and end with 2017-06.
  • Start with 2016-01 and end with 2017-12.
  • Start with 2016-04 and end with 2017-05.
  • For 2016, display Q2, Q3, and Q4. For 2017, display 2017-01, 2017-02, 2017-03, 2017-04, and 2017-05.
Desired Result
Display Options
Start with 2017-01 and end with 2017-06.
  • Start
    :
    Current Year
  • Offset
     for
    Start
    :
    0
  • End
    :
    Current Quarter
  • Offset
     for
    End
    :
    0
  • On the time periods grid, select
    Month
     for all years.
Start with 2016-01 and end with 2017-12.
  • Start
    :
    Current Year
  • Offset
     for
    Start
    :
    -1
  • End
    :
    Current Quarter
  • Offset
     for
    End
    :
    2
  • On the time periods grid, select
    Month
     for all years.
Start with 2016-04 and end with 2017-05.
  • Start
    :
    Month
  • On the prompt below
    Start
    , select
    April 2016
    .
  • End
    :
    Current Month
  • On the time periods grid, select
    Month
     for all years.
For 2016, display Q2, Q3, and Q4. For 2017, display 2017-01, 2017-02, 2017-03, 2017-04, and 2017-05.
  • Start
    :
    Month
  • On the prompt below
    Start
    , select
    April 2016
    .
  • End
    :
    Current Month
  • On the time periods grid, select:
    • Quarter
       for 2016.
    • Month
       for 2017.