SIEMENS

Teamcenter 12.2

Dimensional
Planning and
Validation Tutorial
PLM00150 • 12.2
Contents

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1
Overview of defining an inspection quality process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1
Understanding what you are measuring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-1

Task 1: Creating templates (administrator task) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-1

Creating an inspection device template . . . . . . . . . . . . . . . . . . . ... . . . . . . . . . . . . . . . . . 2-1
Create an inspection device template . . . . . . . . . . . . . . . . . ... . . . . . . . . . . . . . . . . . 2-1
Create the forms associated with an inspection device template .. . . . . . . . . . . . . . . . . . 2-3
Creating a measurement routine template . . . . . . . . . . . . . . . . . ... . . . . . . . . . . . . . . . . . 2-3
Create a measurement routine template . . . . . . . . . . . . . . . . ... . . . . . . . . . . . . . . . . . 2-4
Create the forms associated with the measurement routine . . . ... . . . . . . . . . . . . . . . . . 2-5

Task 2: Creating a bill of resource . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1

Create a plant structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-1
Create an inspection device from a template . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-2
Copy the inspection device to the bill of resource and create forms . . . . . . . . . . . . . . . . . . . . 3-4

Task 3: Creating a process structure (bill of process) . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1

Create a process structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-1
Create the forms for the process structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-2
Create a measurement routine from a template . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4-3

Task 4: Defining the feature data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-1

About the sample DPV Excel Engineering workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-2
About feature validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3
Import the Excel file into Teamcenter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-3
Open the DPV Excel Engineering workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-5
Add a feature to the DPV Excel Engineering workbook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-5
Add feature nominals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-6
Add the first attribute . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-7
Add the remaining attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-8
Add specifications for attributes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-9
Finish adding the feature data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5-11

Next steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6-1

PLM00150 12.2 Dimensional Planning and Validation Tutorial 3

Chapter 1: Introduction

This tutorial steps you through the process of defining an inspection process to measure features
(geometric locations) on an all-terrain vehicle (ATV) to understand and monitor the profile of the right
hood, left hood, and grille relationship. It takes approximately an hour to run the entire tutorial.
Tutorial time: 1 hour
Basic requirements:
• You are familiar with Teamcenter.

• Understand statistical process control.

• Have access to the various components, such as the Teamcenter database.

• Have Microsoft Excel 2003 with compatibility pack for Excel 2007 installed or a later version of
Excel.

Note
The tutorial does not cover configuring DPV Extraction, Translation, and Loading (ETL).

Overview of defining an inspection quality process

The workflow to set up an inspection quality process consists of the following tasks:
1. (Administrator task) Create templates to make it easier for users to create the basic structures
defining what is being measured.

2. Create a bill of resource using the templates the administrator created.

3. Create a process structure (bill of process) also using the templates the administrator created.

4. Add the features to be measured into Teamcenter.

Understanding what you are measuring

In this tutorial, you will define engineering data to measure points or features along the profile of
the right and left hood and grille of an all-terrain vehicle (ATV). Defining engineering data lets you
monitor the relationship between the points. All the features have attributes that define the feature's
measurement characteristics, in this case, the x, y, and z locations and deviations from x, y, and z.
The x, y, and z attributes help you understand all six degrees of freedom and the relationship of the
part outcome based on assembly and stamping tools.
The x feature attributes are shown in the figure.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 1-1

 Chapter
Chapter 1: 1: Introduction
Introduction

Dimensional Planning and Validation provides a standard set of feature attributes. For this tutorial,
you use the standard attributes for locations and deviations (X_ACT, Y_ACT, Z_ACT, X_DEV, Y_DEV,
and Z_DEV). You will also create a custom attribute to capture the radius of the holes.

1-2 Dimensional Planning and Validation Tutorial PLM00150 12.2

Chapter 2: Task 1: Creating templates (administrator task)

Administrators create templates from which users can quickly create new routines and inspection
devices. The templates are generic placeholders. Users create the actual occurrences of these
objects from the templates.
There are two types of templates:
• Inspection device
An inspection device represents an actual inspection device on the factory floor monitoring
the manufacturing process.

• Measurement routine
A measurement routine is an operation within a plant that defines the measurement data to be
collected from a specific type of inspection device.

Administrators can also use the Teamcenter Business Modeler IDE to configure inspection devices
and measurement routines, so some or all of the forms are automatically created when the device or
routine is created. For more information, see the section of the Business Modeler IDE Guide about
configuring Dimensional Planning and Validation.
In this lesson you create both types of templates.

Creating an inspection device template

Creating a template for an inspection device consists of:
• Creating an inspection device.

• Creating the forms that define the inspection device, such as to specify error notification.

In this activity, you will create an inspection device and one of its forms.

Create an inspection device template

Step 1: In My Teamcenter, choose File→New→Item.

Step 2: From the list, select Dimensional Planning And Validation Inspection Device.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 2-1

 Chapter
Chapter 2: 2: Task Task 1: Creating
1: Creating templates
templates (administrator
(administrator task)task)

Step 3: Click Next.

Step 4: Click Assign to fill in the Item ID box.

Step 5: Type in the name for the template, Inspection device template.

Step 6: Type a description to help a user identify the template. For this tutorial, type Inspection
device template.

Step 7: Click Finish.

Step 8: Click Close.

2-2 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 1: Creating templates (administrator task)

A new inspection device template appears in My Teamcenter.

Create the forms associated with an inspection device template

There are four forms associated with an inspection device, including forms that define the location of
the remote transfer agents or set up measurement data processing in DPV Extraction, Translation,
and Loading (ETL). Because you will only be creating the inspection device process and not sending
it to DPV ETL for processing, for this tutorial, you will create the form to define the location of the
remote transfer agents, Dimensional Planning And Validation Device Location, to understand
how to create forms.
Step 1: In My Teamcenter, select the plus sign (+) next to the inspection device you just created.
An inspection device revision appears.

Step 2: Highlight the inspection device revision.

Step 3: Choose File→New→Form.

Step 4: In the New Form dialog box, select Dimensional Planning And Validation Device
Location.

Step 5: Type the following:

For the option Type the following

Name Inspection device location
Description Inspection device location form

At this point, you could also enter values for the form, which would become the default
values for routines created from this template, but for this tutorial, you will not define
values.

Step 6: Click OK.

Creating a measurement routine template

Creating a template for a measurement routine consists of:
• Creating a measurement routine.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 2-3

 Chapter
Chapter 2: 2: Task Task 1: Creating
1: Creating templates
templates (administrator
(administrator task)task)

• Creating the forms that define the measurement routine, such as specify error notification.

The type of operation you create depends on the type of inspection device being used to collect
the measurement data. For this tutorial, you will create a measurement routine with an operation
of the type Manufacturing Engineering Visual Inspection, indicating that it is a vision inspection
station collecting the data.
In this activity, you will create a measurement routine template and one of its forms.

Create a measurement routine template

Step 1: In Manufacturing Process Planner, choose File→New→Operation.

Step 2: In the New Operation dialog box, select Manufacturing Engineering Visual
Inspection.

Step 3: Click Next.

Step 4: Click Assign to fill in the ID and Revision boxes.

Step 5: In the Name box, type Measurement routine template.

Step 6: In the Description box, type Measurement routine template to help a user identify
the template.

Step 7: Click Finish.

The new measurement routine appears in a tab.

2-4 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 1: Creating templates (administrator task)

Create the forms associated with the measurement routine

As with an inspection device, there are several forms associated with a measurement routine.
Because you are only creating the process and not sending it to DPV Extraction, Translation,
and Loading (ETL), you will only create one form, Dimensional Planning And Validation Error
Notification to understand how to create forms. Dimensional Planning And Validation Error
Notification defines when to be notified of errors.
To create the form, you open the Attachments view, which lets you view components attached to
the routine template.
Step 1: In Manufacturing Process Planner, right-click the measurement routine template you just
created and choose Open with→Attachments.

The Attachment view appears beside the measurement routine.

Step 2: In the Attachments view, select the measurement routine, Measurement routine
template, you just created (the top line).

Step 3: Choose File→New→Form.

Step 4: In the New Form dialog box, select Dimensional Planning And Validation Error
Notification.

Step 5: Type the following:

PLM00150 12.2 Dimensional Planning and Validation Tutorial 2-5

 Chapter
Chapter 2: 2: Task Task 1: Creating
1: Creating templates
templates (administrator
(administrator task)task)

For the option Type the following

Name Error notification
Description Error notification form

Step 6: Click OK.

The Dimensional And Planning Error Notification form appears. At this point, you
could enter values, which would become the default values for routines created from this
template, but for this tutorial, you will not define values.

Step 7: Click Close.

The Attachment view now looks like the following:

Step 8: Continue with Task 2.

2-6 Dimensional Planning and Validation Tutorial PLM00150 12.2

Chapter 3: Task 2: Creating a bill of resource

A bill of resource lets you see the actual resources that are used to measure a routine, including:
• The plant where the measurements are being taken. It is the top level of the bill of resource. You
can have stations below it.

• Inspection devices.

• Remote transfer agents.

• Parsing scripts, which translate the raw measurement data from inspection devices to the
standard loading format (Document Markup Language) so the data can be stored in Teamcenter
for analysis and backup in a bill of resource in Teamcenter.

The following is the bill of resource with a plant called ATV plant, one inspection device, which has
device instance information and a parsing script, which translates the raw measurement data from
inspection devices to the standard loading format (Document Markup Language) so the data can be
stored in Teamcenter for analysis and backup.

For this activity, you will create a simple plant structure with only one level.

Create a plant structure

Step 1: In Manufacturing Process Planner, choose File→New→Workarea.

Step 2: Choose MEPrPlant.

Step 3: Click Next.

Step 4: Click Assign to fill in the ID and Revision boxes.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 3-1

 Chapter
Chapter 3: 3: Task Task 2: Creating
2: Creating a billaofbill of resource
resource

Step 5: Type in a name for the new plant of ATV_plant.

To facilitate measurement data loading, the plant name specified in the bill of resource
must match the plant name in the measurement files.

Step 6: Click Finish.

The plant structure appears in a new tab.

Create an inspection device from a template

When you create the inspection device from a template, Teamcenter creates all the necessary forms
you need to define the device. You then edit the forms. To simplify the process for this tutorial, the
administrator created only one form, of the type Dimensional Planning And Validation Device
Location, named Inspection device location.
Step 1: In Manufacturing Process Planner, choose File→New→From Template→Item From
Template.

Step 2: Search for the inspection device template:

□ Click the Choose Template tab.

□ Next to the Template ID box, click Find the Template by Name .

3-2 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 2: Creating a bill of resource

□ In the Find template by name dialog box, in the Name box, type *template*.

□ Click Find.
The templates that match the criteria appear in the dialog box.

□ Double-click Inspection Device Template.

Tip
Click Add to Favorites to save the template to a favorites palette so it
can be quickly accessed and used.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 3-3

 Chapter
Chapter 3: 3: Task Task 2: Creating
2: Creating a billaofbill of resource
resource

The Item Details section at the bottom of the dialog box is completed with the
information for the template you selected.

Step 3: Click the Configuration tab and choose the cloning rule Cloning.

Step 4: In the Item Details section, change the name of the device to
ATV_process_inspection_device and the description to ATV process
inspection device.
All other values (ID, revision, and type) are automatically set for you.

Step 5: Click OK.

A new tab appears listing the inspection device.

Copy the inspection device to the bill of resource and create forms
Step 1: Copy the inspection device to your bill of resource:
□ Select the inspection device revision, and choose Edit→Copy.

□ Click the ATV_plant tab and highlight the plant.

□ Choose Edit→Paste.
The inspection device appears in the ATV_plant tab.

Tip
Double-click the plant to see the inspection device beneath it.

Step 2: In the Attachments view, view the form created for the inspection device. There should
be one named Inspection device location.

3-4 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 2: Creating a bill of resource

Step 3: Double-click the form, and click Check-Out and Edit.

Step 4: In the Check-Out dialog box, click Yes.

Step 5: Edit the form:

For this option Type

alive_test_interval_min 3
data_directory C:/inspection_device
location_name inspection

Step 6: Click Save and Check-In.

Step 7: In the Check-In dialog box, click Yes.

Step 8: Continue with Task 3.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 3-5

Chapter 4: Task 3: Creating a process structure (bill of process)

You define engineering data in a process structure or bill of process. A bill of process is a
hierarchical structure designed in Teamcenter Manufacturing Process Planner that represents the
measurement or inspection process within a given plant. The structure defines the locations where
the measurement routines are executed throughout the plant. The measurement routine itself defines
the actual elements that are measured. Feature data, which you will add in Task 4, is stored in a
dataset. The plant in the bill of process must have the same name as the plant you created for the bill
of resource. They are different objects in Teamcenter, however.

In this activity, you will:

• Create a process structure.

• Create a measurement routine.

Create a process structure

You need to create a process structure before you can define a measurement routine. The top level of
the process structure is a plant. Optionally, you could add a structure underneath the plant, including
an assembly line, zone, and station. For this tutorial, you will just create a simple plant structure.
After you create the process structure, specify its location by attaching a Dimensional Planning
And Validation Location form, which is used to organize the measurement routine so users can
navigate to it when viewing reports.
Step 1: In Manufacturing Process Planner, click Create New Process .

Step 2: In the New Process dialog box, from the Process Type list, select MEPrPlantProcess.

Step 3: Click Next.

Step 4: Click Assign to fill in the ID and Revision boxes.

Step 5: In the Name box, type ATV_process.

Step 6: Click Finish.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 4-1

 Chapter
Chapter 4: 4: Task Task 3: Creating
3: Creating a process
a process structure
structure (bill
(bill of of process)
process)

A new tab appears listing the new process.

Create the forms for the process structure

Step 1: Right-click the new process and choose Open with→Attachments to display it in the
Attachments view.

Step 2: In the Attachments view, select ATV_process.

Note
You must select the plant process in the Attachments view to create a form.

Step 3: Choose File→New→Form.

Step 4: In the New Form dialog box, select Dimensional Planning And Validation Location.

Step 5: In the Name box, type ATV_process_location.

Step 6: Select Open On Create to edit the form options.

Step 7: Click OK.

The ATV_process_location form appears.

Step 8: Click Check-Out and Edit.

Step 9: In the Check-Out dialog box, click Yes.

Step 10: Enter the following:

4-2 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 3: Creating a process structure (bill of process)

Use this option To do this

Country Type United States as the country in
which the plant is located.
Region Select North America/North America
Region as the region for the plant.
Time Zone Select Eastern Time from the list.

Step 11: Click Save and Check-In.

Step 12: In the Check-In dialog box, click Yes.

Create a measurement routine from a template

After creating the process structure, create the measurement routine as an operation within the plant.
Later you will enter its feature data.

When you create the measurement routine from a template, Teamcenter creates all the necessary
forms you need to define the routine. You then edit the forms. To simplify the process for this tutorial,
the administrator created only one form, of the type Dimensional Planning And Validation Error
Notification, named Error Notification.

Step 1: In Manufacturing Process Planner, click the ATV_process tab.

Step 2: Select ATV_process.

Step 3: Choose File→New→From Template→Operation from Template.

Step 4: Search for the measurement routine template:

□ Click the Choose Template tab.

□ Next to the Template ID box, click Find Template by Name .

□ In the Find Template by Name dialog box, type *template*.

□ Click Find.

The templates that match the criteria appear in the dialog box.

□ Double-click Measurement Routine Template.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 4-3

 Chapter
Chapter 4: 4: Task Task 3: Creating
3: Creating a process
a process structure
structure (bill
(bill of of process)
process)

Tip
Click Add to Favorites to save the template to a favorites palette so it
can be quickly accessed and used.

The Item Details section at the bottom of the dialog box is completed with the
information for the template you selected.

Step 5: Click the Configuration tab and choose the cloning rule Mapping_Consumes.

Step 6: In the Name box, type ATV_routine and in the Description box, type ATV routine.
All other values (ID, revision, and type) are automatically set for you.

Step 7: Click OK.

Step 8: In the Attachments view, view the form Error Notification created for the measurement
routine.

Step 9: Double-click the form, and click Check-Out and Edit.

Step 10: In the Check-Out dialog box, click Yes.

Step 11: Select when you want to be notified of errors.

Step 12: Click Save and Check-In.

Step 13: In the Check-in dialog box, click Yes.

Step 14: Continue with Task 4.

4-4 Dimensional Planning and Validation Tutorial PLM00150 12.2

Chapter 5: Task 4: Defining the feature data

You can enter the initial feature definitions in either XML or Excel. When you import the initial feature
definitions into Teamcenter, they are attached to the routine as a DPV Excel Engineering dataset.
Therefore, all edits are done in Excel.

In this activity, you import a DPV Engineering Excel worksheet into Teamcenter and add features
and feature attributes to it. Then, you edit the routine to remove and change features. As you import
it, the worksheet is automatically associated with the default rule set provided, which validates the
data according to DPV requirements. In your normal workflow, you would also associate it with a
custom rule set, which would validate the feature data according to your company’s standards. For
this tutorial, you will not associate the dataset with a custom rule set.
As explained in Understanding what you are measuring, you are creating features that monitor the
right and left hood and grille relationship. You are going to create ten features and their attributes.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-1

 Chapter
Chapter 5: 5: Task Task 4: Defining
4: Defining the feature
the feature data data

About the sample DPV Excel Engineering workbook

For this tutorial, you will import the sample DPV Excel Engineering workbook ATV_routine_blank.xlsx
to create feature data. Use Excel 2003 or later to edit it.

The Excel Engineering workbook sample contains worksheets for defining the features and tolerances
and displaying errors and comments:
• FeatureInfo
Worksheet where you enter all the feature-level information and nominal data of the feature
attributes. Each row represents a different feature. Each feature can have many feature attributes.

• ENGG and DML

Default set of tolerances (specification set) against which the measurement data will be compared
for data collected in ASCII format (ENGG) or Document Markup Language format (DML). It
represents engineering tolerances. You can add additional worksheets containing other sets of
specifications. The name of the sheet is the same as the specification set.

• Discrepancy worksheets
The default rule set creates a worksheet called Discrepancy to display any validation errors,
such as if you entered a name that contains characters that are not allowed. A custom rule
set also creates a tab (usually named User Discrepancy) to display custom validation errors,
such as if you entered a name that is inconsistent with your company’s standards. When you

5-2 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 4: Defining the feature data

correct errors in the feature data, the corresponding entries are deleted from the Discrepancy
and User Discrepancy worksheets.

• Comment worksheets
You can add comment worksheets or comment columns to the DPV Excel Engineering workbook
to assist you in understanding the entered data. Comment columns must be added after all
other required columns.

Tip
Use Excel functionality, such as sorting and filtering, to help you enter and manage the data.

About feature validation

When you import the sample DPV Excel Engineering worksheet into Teamcenter, it is automatically
associated with the default rule set, which validates the data against DPV requirements. The rule set
is a collection of macros saved in a Microsoft Excel binary workbooks (.xlsb).
For example, the default rule set validates the data to ensure:
• The feature name is unique.

• The feature name is a maximum length of 32 characters.

• The feature name is an alphanumeric string. All characters are allowed except:
,<>\/“‘&`@#(){}[]|: ;*^%

• Feature IDs are unique within a given routine. Feature IDs should be generated automatically
and not edited.

In addition, if you add a feature, it is added to the attributes worksheets. If you delete a feature, it is
deleted wherever it occurs in the DPV Excel Engineering workbook.
The data is also validated when you import the Excel workbook (Tools→Import Feature data),
and whenever you save it.

Import the Excel file into Teamcenter

Import the blank DPV Excel Engineering sample workbook into Teamcenter, which associates it with
rule sets. You will then open it through Teamcenter to edit it and create a dataset to store the file.
Step 1: In the DPV help folder, browse for the file:
<path to help installation directory>\getting_started_dpv\
include\defining_data\ATV_routine_blank.xlsx and save it to your local drive as
ATV_routine.xlsx.

Step 2: Configure Excel for DPV rules validation:

a. Depending on your version of Microsoft Office, access the Excel Options dialog box.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-3

 Chapter
Chapter 5: 5: Task Task 4: Defining
4: Defining the feature
the feature data data

b. On the left, click Customize Ribbon and make sure Add-Ins is in your list of
displayed tabs. If it is not, click add it and click OK.

c. On the left, click Trust Center and then click Trust Center Settings.

d. In the Trust Center dialog box, click Macro Settings.

e. Select Enable all macros.

f. Under Developer Macro Settings, select Trust access to the VBA project object
model.

g. Click OK and then click OK again.

Step 3: Save the file to your local drive as ATV_routine.xlsx

Step 4: In Manufacturing Process Planner, click the tab associated with the ATV_process.

Step 5: Right-click the routine and choose Open with→Attachments.

Step 6: In the Attachments view, select ATV_routine.

Step 7: Choose File→New→Dataset.

5-4 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 4: Defining the feature data

Step 8: From the Type list, select Dimensional Planning and Validation Excel.

Step 9: Next to Import, click Import.

Step 10: Browse for the file and click OK.

Step 11: Click OK.

The dataset is automatically associated with the default DPV rule set.

Open the DPV Excel Engineering workbook

Now you will open the DPV Excel Engineering workbook and activate the rule set macros.
Step 1: In the Attachments view, double-click ATV_dataset.
ATV_routine.xlsx opens in Excel.

Step 2: Click the Add-Ins tab and from the Apply XLSB (RULESET) menu, click the .xlsb file.
The following shows how the worksheet appears in Excel 2003 with a custom rule set
called customRuleB.xlsb and the default rule set (siemens.xlsb).

When the rule set is run, the default rule set creates a discrepancy worksheet called Discrepancy, if
one is not already available, in which it writes error and warning messages. The cells with errors are
also highlighted in red or yellow, depending on the level of error.

Add a feature to the DPV Excel Engineering workbook

Now you will create the first feature (HORDHPK047), which corresponds to the second point on the
left front of the ATV hood.

Tip
To keep the headers visible when scrolling in the worksheet, freeze the top row.

• On the FeatureInfo worksheet, enter data for the first feature.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-5

 Chapter
Chapter 5: 5: Task Task 4: Defining
4: Defining the feature
the feature data data

In the column Type

Feature Id Leave blank. DPV validation automatically
adds it.
Feature Label HORDHPK047
Feature Type Point
Alt Ftr Label HORDHPK047
Feature Description Fender Outer: Left Front Outboard U/D
Active Status Y
Need Required
Loading Split ID value

As you create the feature, the default rule set automatically adds the feature name to the
specification set worksheets to assist you later in defining tolerances (specifications). If you had
more specification sets, it adds the feature to all of the worksheets.

Add feature nominals

Now you will add data for feature nominals. Feature nominals specify the X, Y, Z, I, J, K, I2, J2, and
K2 values for the added feature. For this tutorial, all the feature nominals are 0.

Note
All child elements of feature nominals are required. If there are no I2, J2, and K2 values,
enter the feature nominals with empty elements.

• On the FeatureInfo worksheet, type 0 in the columns X, Y, Z, I, J, K, I2, J2, and K2.

5-6 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 4: Defining the feature data

Add the first attribute

Columns have been set up in ATV_routine.xls for you to add seven attributes. The first attribute you
will add is of the type X_ACT, which is the actual location of X.
Step 1: Below the header Attribute 1, type X_ACT.

Step 2: Add the remaining information to define the attribute:

In the column Type the following

Significance 1
Measurement surface
Need Required
Nominal 876.66

As you create the attribute, DPV validation automatically adds the name to the
specification set worksheets just as it added the feature.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-7

 Chapter
Chapter 5: 5: Task Task 4: Defining
4: Defining the feature
the feature data data

Add the remaining attributes

Step 1: Add the other standard attributes as you did in the previous activities. The data for the
attributes is shown below.

For the attribute, type

In the column 2 3 4 5 6
Type (column X_DEV Y_ACT Y_DEV Z_ACT Z_DEV
has no header;
it is below
the attribute
number)
Significance 1 1 1 1 1
Measurement surface surface surface surface surface

Need Required Required Required Required Required

Nominal 0 -461.49 0 629.35 0

The worksheet should now look like the following:

For this tutorial, you also wanted to capture data about the radius of the holes. This is not
a standard attribute but you can simply add it to the feature definition.

Step 2: Add the custom attribute for radius. The text for the attribute is shown below. It will be
Attribute 7. You will need to create the columns for it.

In the column For Attribute 7, type

Type (column has no header; it is below
Radius
the attribute number)
Significance 1
Measurement surface
Need Required
Nominal 0

5-8 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 4: Defining the feature data

Note
More steps are required to define a custom feature attribute depending on how
the feature attribute is displayed in the raw measurement data file and if you
want abbreviations used for it when it appears in DPV Reporting & Analysis
and reports. These steps are explained in the online help.

Step 3: Choose File→Save.

A message appears asking you if you want to save the workbook as a macro-free
workbook.

Step 4: Click Yes.

Add specifications for attributes

In this activity, you will define the set of tolerances, or specifications for the feature. You will use the
default worksheet ENGG. If DPV validation was configured, the worksheet is already populated with
the feature and its attributes. All you will need to do is to add the tolerance information.
Step 1: Select the ENGG worksheet. Notice that the feature and attribute information is already
there.

Step 2: Type the specification limits for the first feature attribute, by typing the following:

In the column Type the following

Feature Label HORDHPK047
Target 0

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-9

 Chapter
Chapter 5: 5: Task Task 4: Defining
4: Defining the feature
the feature data data

In the column Type the following

USL 0
LSL 0

Note
USL and LSL are the upper and lower limits for the data range.

Step 3: Add specifications for the other attributes, including Radius.

For the attribute, type:

In the
2 (X_DEV) 3 (Y_ACT) 4 (Y_DEV) 5 (Z_ACT) 6 (Z_DEV) 7 (Radius)
column
Target 0 0 0 0 0 0
USL 1 0 1 0 0.5 1
LSL –1 0 –1 0 –0.5 –1

Step 4: Choose File→Save.

A message appears asking you if you want to save the workbook as a macro-free
workbook.

Step 5: Click Yes.

5-10 Dimensional Planning and Validation Tutorial PLM00150 12.2

 Task 4: Defining the feature data

Finish adding the feature data

You could continue to create features and their attributes but we have provided a finished set of
features in the DPV Excel Engineering workbook, ATV_routine_complete.xlsx.
Step 1: In the DPV help folder, browse for the file:
<path to help installation directory>\getting_started_dpv\
include\defining_data\ATV_routine_complete.xlsx and save it to your local drive as
ATV_routine.xlsx.

Step 2: Copy the features, their attributes, and specifications from the
ATV_routine_complete.xlsx file.
Note that the ATV_routine_complete.xlsx file contains the first feature you made in
the previous steps.

Step 3: Choose File→Save.

A message appears asking you if you want to save the workbook as a macro-free
workbook.

Step 4: Click Yes.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 5-11

Chapter 6: Next steps

Your next steps would be to continue to configure the measurement routine for processing and
configure the collection of data. For more information, refer to the Defining the inspection quality
process help in the DPV or Teamcenter documentation.

PLM00150 12.2 Dimensional Planning and Validation Tutorial 6-1

Siemens Industry Software

Headquarters
Europe
Granite Park One
Stephenson House
5800 Granite Parkway
Sir William Siemens Square
Suite 600
Frimley, Camberley
Plano, TX 75024
Surrey, GU16 8QD
USA
+44 (0) 1276 413200
+1 972 987 3000

Asia-Pacific
Americas
Suites 4301-4302, 43/F
Granite Park One
AIA Kowloon Tower, Landmark East
5800 Granite Parkway
100 How Ming Street
Suite 600
Kwun Tong, Kowloon
Plano, TX 75024
Hong Kong
USA
+852 2230 3308
+1 314 264 8499

About Siemens PLM Software

© 2019 Siemens Product Lifecycle Management

Siemens PLM Software, a business unit of the Siemens
Software Inc. Siemens and the Siemens logo are
Industry Automation Division, is a leading global provider
registered trademarks of Siemens AG. D-Cubed,
of product lifecycle management (PLM) software and
Femap, Geolus, GO PLM, I-deas, Insight, JT, NX,
services with 7 million licensed seats and 71,000 customers
Parasolid, Solid Edge, Teamcenter, Tecnomatix and
worldwide. Headquartered in Plano, Texas, Siemens
Velocity Series are trademarks or registered trademarks
PLM Software works collaboratively with companies
of Siemens Product Lifecycle Management Software
to deliver open solutions that help them turn more
Inc. or its subsidiaries in the United States and in other
ideas into successful products. For more information
countries. All other trademarks, registered trademarks
on Siemens PLM Software products and services, visit
or service marks belong to their respective holders.
www.siemens.com/plm.