Viewing data for shells and subshells in a generic cost sheet

You are here: Primavera Unifier User Mode > Cost Manager > Generic Cost Manager > Viewing data for shells and subshells in a generic cost sheet

Viewing data for shells and subshells in a generic cost sheet

The generic cost sheet displays transactional data by period and shell level. In the context of working with the generic cost sheet, you can filter the cost data you are viewing by shells or subshells. The generic cost sheet is accessed from the Shell > Configurable Managers > Generic Cost Manager > Generic Cost Sheet log. You can use the shell or subshell filter in combination with the timescale selector documented in the next section to create various views in your spreadsheet based on shell or subshell and time period.

To view generic cost sheet data by shell or subshell

Open the shell and click Configurable Managers > Generic Cost Manager > Generic Cost Sheet in the left Navigator. The Generic Cost Sheet log opens.

Open the Generic Cost Sheet you want to work with by double-clicking the cost sheet name or by selecting the cost sheet name in the log and then choosing File > Open.

In the View By selection list, choose one of the following:

•

Current Shell only: Data from the current shell you have selected. Manual column data is editable in the Current Shell only view.

•

Current Shell and Subshells only: Data from both the current shell and its subshells.

•

Subshells only: Data from the subshells of the current shell.

In Generic Cost Sheet views, data is rolled up from the current shell and subshells. When data is rolled up from subshells, the generic cost sheet under a shell can roll up data from other shells that are created as subshells and their subshells. The Current Shell and subshells only and Subshells only views support this rollup. For example:

•

North Region (shell)

•

Property A (subshell)

•

Building 101 (subshell)

•

Building 102 (subshell)

•

Property B

•

Building 201

•

Building 202

In this example, the North Region Generic Cost Sheet will have data from Property A, Property B, Building 101, Building 102, Building 201, and Building 202. Property A has data from Building 101 and Building 102. Property B has data from Building 201 and Building 202.

Also, data from a subshell to its parent shell can only roll up if the codes match. For example,

•

North Region (Shell)

•

Property A (1000–1001: $500)

•

Building 101 (1000–1001: $500)

•

Building 102 (1000–1002:$200)

In this example, Building 101 will roll up to Property A as the codes match (1000–1001). Building 102 will not roll up because the codes are different (1000–1002). Parent and child shell cost codes must match for roll up to occur. Timescale and column definition must also match across the shells and subshells.

Also, all subshells that will roll up must have the same currency as the parent shell. If all of the subshells and the current parent shell have the same currency, the data displays in that currency. If at least on subshell has a different currency, the data displays in the Base Currency. A confirmation message alerts you to this currency display.

While rolling up, only parent shell generic cost sheet codes should be considered. This is applicable under all views.

Oracle Corporation