Attribute Settings

What are Attributes and How are They Used

Attributes and attribute hierarchies are mapped to reporting cubes for reporting purposes. You can map attributes as either attribute hierarchies or properties, with up to ten attributes and hierarchies per Financial reporting cube and ten for the Sales reporting cube (twenty total). Attributes can be used just like dimensions (for example, sliced and diced across axes and drilled down upon).

You can add any remaining attributes (those in addition to the 10 per cube) created on dimensions as member properties. There is no limit to the number of properties that can be mapped. Attributes mapped as properties cannot be drilled upon. Properties show up as notes on a report. They can be included as mapped properties in the report setup for a Dynamic Report. When you run the report, they’re displayed.

Attribute Settings are processed in the cloud so that you can continue working while processing takes place. Once complete, you will be notified.

Attributes and Attribute Hierarchies are discussed in detail in the Hierarchy Management Admin Guide.

Mapping and Unmapping Workforce Planning Default Measures for Reporting Purposes

All default measures are enabled for selection on the Attribute Settings page so that you can map and unmap them to and from the reporting area. If you did not want to include annual salary or bonus, for example, in a Dynamic Report, you can hide them from the Measure dimension.

In Practice:

To Map Workforce Planning Default Measures from Attribute Settings Screen:

1. Navigate to Maintenance > Reports > Cube Settings.

2. The first tab is displayed when the screen opens, which is Attribute Settings.

3. Select Workforce Attributes from the list-box.

4. Click the Add button to select measures to map.

   

5. You MUST map Amount in CC (Common Currency), Headcount and any one of the measures each from the Position and Employee dimensions to take advantage of Workforce Reporting. See images below.

   

6. Click Add Selected.

7. Click Save.

Unmapping Measures

Not all measures can be unmapped. You will receive an informational message for measures that cannot be unmapped. Workforce Reporting measures (Amount in CC, Headcount and any one of the measures each from the Position and Employee dimensions) are required to be mapped.

To Unmap Measures:

1. Click the checkbox next to the measure you want to unmap.

2. Click the Unmap Measures button shown below.