Change Default Time Strata on Cube and Modeled Sheets with Data

Complete any changes to your time structure.

Security:

Model includes sheets, accounts, dimensions, and formulas
permission.

Time
permission.

Configure Calendar
permission.

You can configure cube and modeled sheets to display a different time strata than the default time strata. You can do this:

When you create your sheets.

After you create and populate your sheets with data. This option requires you to erase all standard data, cell notes, and audits.

Cube and modeled accounts inherit their time strata from the cube and modeled sheets that own them. Modeled or cube sheets can't contain accounts with different time strata. Cube-entered general ledger and custom accounts use the same time strata as the cube sheet that they link to.

Go to

Modeling

Select either:

Level Assigned Sheets

User Assigned Sheets

Select

Edit

for your cube or modeled sheet.

If your sheet contains data, select

Erase All Data

Depending on whether your sheet is a cube sheet or a modeled sheet, select:

Dimensions, Attributes and Levels

for cube sheets.

Columns and Levels

for modeled sheets.

On the sheet properties menu, select the

Settings

tab.

Select the time strata from the

Select the time stratum associated with this modeled sheet

prompt.

Your company uses the standard configured calendar of Month > Quarter > Year. You want a cube sheet containing weekly data, but you don't want to erase your monthly data.

Export your existing calendar from within

Time

Update the exported spreadsheet and insert the required columns of Code, Label, and Short Name for Weeks to left of your Month columns.

Import your edited spreadsheet using the Update
option within

Time

. By using the Update
option, you don't erase your monthly data and your default time strata remains Month.

Create a new cube sheet and select Week
for its time strata on the

Settings

tab of its

Sheet Properties