An Oracle White Paper

April 2012

Introduced in Release 6.0

E29311-01

Boolean Extended Attributes

# Overview

A new extended attribute type of Boolean has been added. Boolean attributes can be rolled up during formulation. The roll up behavior can be set on the attribute template.

# The Basics

The Boolean attribute displayed in consumption, with optional text:

Figure 1. Boolean attribute

A Boolean attribute is created like any other extended attribute. Once on the extended attribute template in ADMN, select Boolean as the attribute type. Once Boolean is selected the following fields are available:

Figure 2. Extended attribute template

Display Text – This is the text that is displayed next to the dropdown in consumption. This field is optional. When left blank, only the dropdown will be displayed in consumption.

Default State – This is the value the dropdown is set to when the attribute is added to the specification. There are 3 states for the Boolean attribute: True, False and Null.

Rollup Behavior – This field defines the rollup behavior of the attribute during formulation. There are two options, Rollup as True if all items are true and rollup as true if one item is true. See the following rollup examples:

## Rollup as True if all are True

The following inputs are added to a formulation specification “Lemonade”:

Input |
Sugar | Organic = True
Water | Organic = True
Lemon Juice | Organic = False

In the previous table, the lemonade produced by the formulation specification would include the extended attribute/value pair of Organic = False. This happened because the Lemon Juice input was not organic. If all inputs were marked as true the output’s extended attribute would be Organic = True.

## Rollup as True if one is True

The following inputs are added to a formulation specification “Lemonade”:

input |
Sugar | Genetically Modified = False
Water | Genetically Modified = False
Lemon Juice | Genetically Modified = True

In the previous table, the lemonade produced by the formulation specification would include the extended attribute/value pair of Genetically Modified = True. This happened because the Lemon Juice input was genetically modified. If all inputs were marked as true the output’s extended attribute would be Genetically Modified = False.

# Allowing Nulls

Null values are either ignored during rollup as if they did not exist in the set or stop the rollup action. This will all depend on if you select “Allow Nulls” or “Do Not Allow Nulls” inside the extended attribute listing on the output popup.

Figure 3. Null values

Note: An extended attribute is considered Null if the attribute does not exist on the input or if the attribute does exist and no value is set.

For example, if you have “allow null” selected in the following example, the result would still be True. However if you selected do NOT allow null then nothing would appear in the “Theoreticals” column:

input |
Sugar | Genetically Modified = False
Water | Genetically Modified = BLANK (OR the Genetically Modified EA doesn’t exist)
Lemon Juice | Genetically Modified = True

# Printing and Searching

Boolean attributes can be searched and printed and are available everywhere other extended attributes are supported.

# Calculated Extended Attribute

Boolean attributes can be referenced by calculated extended attributes. An integer that represents the selected value will be returned: 0 is false, 1 is true, -1 if not set.

Boolean Extended Attribute April 2012 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores, CA 94065 U.S.A. Worldwide Inquiries: Phone: +1.650.506.7000 Fax: +1.650.506.7200 oracle.com | Copyright © 2012, Oracle and/or its affiliates. All rights reserved. This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. UNIX is a registered trademark licensed through X/Open Company, Ltd. 1010