Using the Spreadsheet

You can use the spreadsheet to browse and edit planning content.

You can add custom attributes using business logic (DELSSEListCustomizedAttributes_ID and DELSSESetCustomizedAttributeValue_ID).

This task shows you how to:

Before you begin:
  1. Open a PPR Context with a root Manufacturing Assembly in your app.
  2. To open the spreadsheet panel, click PPR Spreadsheet from the Authoring section of the action bar and select the root Manufacturing Assembly.
Tips:
  • To make the spreadsheet dialog boxes floatable, click Show Preferences and select the Show Managers as Floatable option.
  • To reorganize the structure according to attribute groups, switch to the flat display mode by clicking Flat mode .
See Also
Assigning Product Structure Nodes to Items

Insert PPR Objects

Using the spreadsheet, you can insert PPR objects such as items, operations, and systems.

The scenario below illustrates how to insert several unloading operations.

  1. In the spreadsheet, click Insert New Content .
  2. From the list, select the type of PPR object you want to insert.
  3. In the box, enter the number of PPR objects you want to insert.
  4. Click Validate to confirm the insertion.

Tip: More commands are available when you right-click an object in the spreadsheet.

Manage PPR Object Attributes

You can hide or show, reorder, and edit attributes.

  1. In the spreadsheet, click Attributes Manager .
    The list of available attributes appears, in the order of the spreadsheet.
  2. To manage attributes display, use the following commands:
    CommandDescription

    Hides or shows all attributes.

    /

    Hides or shows a single attribute.

    /

    Moves the selected attribute up or down the list.

  3. To edit an attribute, select its value in the spreadsheet and enter a new one.

Tips:
  • Nonevaluated mandatory attributes are signaled by a highlight icon in their cell and header.
  • You can check, filter, and export attribute validation messages in the Report Manager. Click Report Manager to start the Report Manager.

    You can use the PPRSpreadsheetAttributeValidation_ID and PPRSpreadsheetAttributeValuePropagation_ID business logics to test attribute values and generate messages based on defined rules.

Filter PPR Objects

You can filter PPR objects based on attribute values.

  1. In the spreadsheet, select an attribute then click Filters Manager .
    The list of available values for the attribute appears.
  2. To filter values of the attribute, use the following commands:
    CommandDescription

    Hides or shows all attribute values.

    /

    Hides or shows a single attribute value.

Group PPR Objects

You can create grouping nodes to group PPR objects based on attribute values. This enables you to select and edit all objects in a group simultaneously.

The scenario below illustrates how to group objects by type.

  1. In the spreadsheet, click Groups Manager .
  2. Click Create Group .
  3. From the list, select an attribute such as Type.
    The list of available values for the attribute appears.

  4. Using Hide and Show , display only the values for which you want to create a group.
  5. Click Validate .
    A grouping node is created for each value.

Manage Presets

You can save the current configuration of the spreadsheet or apply an existing one.

  1. In the spreadsheet, click Presets Manager .
  2. To save the current configuration of the spreadsheet:
    1. Optional: In the box, enter a name for the preset.
    2. Click Create Preset .
    A preset containing the current attributes, filters, and groups of the spreadsheet is created.
    Tip: You can share the preset using the file automatically downloaded in the CAT settings.
  3. To apply a preset to the spreadsheet, click Load Preset .

    You can revert to the default configuration by clicking .

  4. To update a preset with the current configuration of the spreadsheet, click Save Preset .

Export Content

You can export the spreadsheet content as a text, CSV, or TSV file.

  1. Select the spreadsheet content.

    Note: If only one line is selected, it will be the only line exported. To export the entire spreadsheet content, select all the lines.

  2. Click Export Content .
  3. Specify the folder in which to export the file, name the file, and choose a file type from the list.
  4. Click Save.
    A file containing the selected spreadsheet content is created in the specified folder.