Business Processor

Business Processor refers to a uniquely named data element of relevance which can be used to define views within the data warehouse. It typically implies aggregated information as opposed to information at a detailed granular level that is available before adequate transformations.

A Business Processor encapsulates a business logic for assigning a value to a measure as a function of observed values for other measures. Business Processors are required Measurements that require complex transformations that entail transforming data based on a function of available base measures.

Measurements that require complex transformations that entail transforming data based on a function of available base measures require Business Processors. A supervisory requirement necessitates the definition of such complex transformations with available metadata constructs.

Business Processors are metadata constructs that are used in the definition of such complex rules. Business Processors are designed to update a measure with another computed value. When a rule that is defined with a Business Processor is processed, the newly computed value is updated on the defined target.

Based on the role that you are mapped to, you can access read, modify or authorize Business Processor. For all the roles and descriptions, see Appendix A. The roles mapped to Business Processor are as follows:

§       BMM Processor Access

§       BMM Processor Advanced

§       BMM Processor Authorize

§       BMM Processor Phantom

§       BMM Processor Read Only

§       BMM Processor Write

You can access Business Processor window by expanding Unified Analytical Metadata within the tree structure of LHS menu and selecting Business Processor.

The Business Processor window displays the list of pre-defined Business Processors with their Code, Short Description, Long Description, Dataset, and Measure. The Business Processor window allows you to generate values that are functions of base measure values. Using the metadata abstraction of a business processor, power users have the ability to design rule-based transformation to the underlying data within the data warehouse / store. You can make use of Search and Filter option to search for specific Business Processors based on Code, Short Description, or Authorized status. The Pagination option helps you to manage the view of existing Business Processors within the system.

Adding Business Processor

You need to be mapped to the role group BMM Processor Write to add a Business Processor.

To create a Business Processor from the Business Processor window:

1.      Click  Add button. The Add Business Processor window is displayed.

2.     Enter the details as tabulated:

 

Field

Description

Code

While creating a new Business Processor, you need to define a distinct identifier/Code. It is recommended that you define a code that is descriptive or indicative of the type of Business Processor being created. This will help in identifying it while creating rules.

Note the following:

It is mandatory to enter a Code.

The Code should be minimum eight characters in length; it can be alphabetical, numerical (only 0-9) or alphanumerical characters.

The Code should start with an Alphabet.

The Code cannot contain special characters with the exception of the underscore symbol (_).

The saved Code or Short Description cannot be changed.

Short Description

Short description is useful in understanding the content of the Business Processor you are creating. It would help to enter a description based on the code.

Note the following:

It is mandatory to enter a Short Description.

The Short Description should be of minimum one character and maximum of 80 characters in length.

Only Alphanumeric, non-English, and Special characters such as “<blank space>”, “.”, “$”, “&”, “%”, “<”, “>”, “)”, “(“, “_”, and “-” are permitted to be entered in the Short Description field.

Long Description

The long description gives an in-depth understanding of the Business process you are creating. It would help you to enter a Long Description based on the code.

The Long Description should be of minimum one character and maximum 100 characters in length.

Dataset

Select the Dataset from the drop-down list. The list of available Datasets for the selected Information Domain will appear in the drop-down.

The Short Description of the Datasets as entered in the Datasets window under Business Metadata Management will be reflected in the drop-down.

Measure

Select the Measure from the drop-down list. All base measures that are defined on any of the tables present in the selected Dataset will appear in the drop-down.

If the underlying measure is deleted after the Business Processor definition, then the corresponding Business Processor definition will automatically be invalidated.

Expression

Click  button. The Expression window is displayed.

For more details on creating an expression using entities, functions and operators, see Create Expression section.

The placeholder option enables the user to provide values for the constants in the expression. The user can specify values to the business processor expression during the run time rather than at definition time through the place holders defined while specifying the expression. The user can specify the expression in the “Expression” field.

Note the following:

The values for the placeholders can be alphanumeric.

The process of specifying place holders enables the user to execute the same business processor definition with different values during the run time.

Expression has Aggregate Function

The expression may require an aggregation function depending on the business logic. The aggregation functions have to be entered in the expression field per acceptable syntax. IF an aggregation function is used in the expressions, the checkbox “Expression has Aggregate Function” must be enabled. Leave the checkbox “Expression has Aggregate Function” blank if your expression does not contain an aggregation function.

 

You can also:

§       Click button in the Business Processor Definition grid to refresh the entries.

§       Click Parameters to specify default values for any of the placeholders defined.

The Parameters window is displayed.

i.       Enter a default value for the place holders defined along with the expression in the Default Value field.

ii.    Click Save to save the default value for a Place Holder.

The User Info grid at the bottom of the window displays the metadata information about the Business Processor definition created along with the option to add comments.

3.     Click Save. The Business Processor is saved and listed in the Business Processor window after validating the entries.

Viewing Business Processor

You need to be mapped with the role group BMM Processor Read Only to view a Business Processor.

You can view individual Business Processor definition details at any given point. To view the existing Business Processor definition in the Business Processor window:

1.      Select the checkbox adjacent to the required Business Processor code.

2.     Click View button from the Business Processor tool bar.

The View Business Processor window displays the details of the selected Business Processor definition. The User Info grid at the bottom of the window displays the metadata information about the Business Processor definition along with the option to add comments.

Editing Business Processor

You need to be mapped with the role group BMM Processor Write to edit Business Processor.

You can update the existing Business Processor definition details except for the Business Processor Code and Short Description. To update the required Business Processor definition details in the Business Processor window:

1.      Select the checkbox adjacent to the required Business Processor code.

2.     Click  Edit button from the Business Processor tool bar. The Edit Business Processor window is displayed.

3.     Update the details as required. For more information see Add Business Processor.

4.    Click Save and update the changes.

Copying Business Processor

You need to be mapped with the role group BMM Processor Write to copy business processor.

You can copy the existing Business Processor to quickly create a new Business Processor definition based on the existing rule details or by updating the required parameters. To copy an existing Business Processor definition in the Business Processor window:

1.      Select the checkbox adjacent to the required Business Processor code in the list whose details are to be duplicated.

2.     Click Copy button from the Business Processor tool bar. Copy button is disabled if you have selected multiple checkboxes. The Copy Business Processor window is displayed.

3.     Edit the Business Processor details as required. It is mandatory that you change the Code and Short Description values. For more information see Add Business Processor.

4.    Click Save. The defined Business Processor is displayed in the Business Processor window.

Deleting Business Processor

You need to be mapped with BMM Processor Write to delete business processor.

You can remove Business Processor definition(s) which are no longer required in the system by deleting from Business Processor window.

1.      Select the checkbox(s) adjacent to the Business Processor codes whose details are to be removed.

2.     Click Delete button from the Business Processor tool bar.

3.     Click OK in the Warning dialog to confirm deletion.

The selected Business Processor definitions are removed.