Understanding Part Conversion Details

This topic provides more detailed information about the conversion of BAM 8.8 parts.

Part Names Conversion Method

PTAEACECONV Application Engine program converts the names for each part that will be included in the analytic model.

The following table describes BAM 8.8 part name attributes and the changes that PTAEACECONV makes to these attributes.

BAM 8.8 Part Name Attribute	Attribute Change Upon Conversion
Lower case alphanumeric characters	All lower case alphanumeric characters are converted to upper case alphanumeric characters. For example: Products converts to PRODUCTS.
White spaces	All white spaces are converted to underscores. For example: Actual Sales converts to ACTUAL_SALES.
Hyphens	All hyphens are converted to underscore characters. For example: Gross-Margin converts to GROSS_MARGIN.
Non alphanumeric characters	Non alphanumeric characters are removed from the part name. For example: Cost$ of delivery converts to COST_OF_DELIVERY.
Part names with more than 27 characters	Characters exceeding the 27 character limit are truncated. For example: Moving STD by Country and Group converts to MOVING_STD_BY_COUNTRY_AND_G
Duplicate part names	Numeric values are appended to duplicate part names. For example, if the BAM 8.8 model contains the Actual Sales and Actual_Sales part names, PTAEACECONV creates two new part names: ACTUAL_SALES and ACTUAL_SALES1.

Note: Converted names of expression modifiers include the prefix EXP_.

Additionally, for each part that is converted, the original part name is converted into the new part's description.

Filter user functions that are referenced by dimensions that exist in table views are converted to user functions. The user function names include the prefix DR_ plus the converted dimension name.

Code in Data Cube Rules, User Functions, and Expression Modifiers

PTAEACECONV uses the following order of execution when converting code in data cube rules, user functions, and expression modifiers:

Replace all references to part names with resolved part names.
During conversion, PTAEACECONV searches through the code in data cube rules, user functions, and expression modifiers for all part names and replaces these part names with new, converted part names. For example, the EmployeeNetMonthlyIncome user function contains the following code:
```
Monthly Salary - Monthly Deductions
```
PTAEACECONV changes the user function's code to:
```
MONTHLY_SALARY - MONTHLY_DEDUCTION
```
Replace all references to option lists with a literal string.
Because analytic models do not support option lists, PTAEACECONV converts references to option lists within the code of data cube rules, user functions, and expression modifiers. For example, the RevenueMethod option list exists in the following user function code:
```
&RevenueMethod := GetRevenueMethod( ); 
CASE(
&RevenueMethod = \Revenue Method\Data Entry\ : 
  Do_Something;
&RevenueMethod = \Revenue Method\Repeat Value\ : 
  Do_Something_ELSE;
)
```
The PTAEACECONV Application Engine program converts the user function's code to:
```
&RevenueMethod := GetRevenueMethod( ); 
CASE(&RevenueMethod = "Data Entry": 
  Do_Something;
    &RevenueMethod = "Repeat Value":
  Do_Something_ELSE;
)
```
Replace all references to original dimension names with converted dimension names.
Replace all references to original data cube names with converted data cube names.

Note: If a dimension name and data cube name share the same name in the original model and one or both names contain more than 30 characters, the dimension name retains the original part name in the converted analytic model. If the BAM model contains rules or user functions that reference data cubes that share the same names as dimensions, the converted rules and user functions reference the dimensions instead. Developers must resolve these issues. The PTAEACECONV conversion log file indicates all data cubes and dimensions that fall into this category.
Replace all references to the original user function names with converted user function names.

Data Cubes

The PTAEACECONV Application Engine program converts all data cubes and most data cube attributes.

Note: Data cube values are not converted. Application developers are responsible for converting data cube values.

The following data cube attributes are unaffected by the conversion:

These data cube formats:
- Text
  
  Note: The Width property is not converted.
- Number
  
  Note: Digit and Decimal properties are not converted.
- Member
- Date
  
  Note: The Dimension Name property is not converted.
These virtual data cube properties:
- Is virtual
- Is not virtual
- Note
- Attachments to dimensions

The following data cube attributes are changed during conversion:

These data cube formats:
- General
  The General format is converted to the Text format.
- Currency
  The Currency format is converted to the Number format.
- Option List
  The Option List format is converted to the Text format.
- Percent
  The Percent format is converted to the Number format.
  
  Note: Digit and Decimal properties are not converted.
- Yes/No
  The Yes/No format is converted to Text format.
Code in data cube rules.

For more information, see the Expression Modifiers section below.
Data cube names:
- Original data cube names are converted into new data cube names using the part names conversion method.
  For more information, see the
- Original data cube names are also converted into new data cube descriptions.

These data cube attributes are not converted:

All methods for combining periods, including:
- Summing Values
- Averaging Values
- Last in Period
- Using Formula
- Blank
All methods for splitting periods, including:
- Dividing Value
- Interpolating
- Repeating Value
- Using Formula
- Blank
All methods for justification, including:
- Default
- Left
- Center
- Right
Formatting function names.

Dimensions

PTAEACECONV converts all dimensions and most dimension attributes.

The conversion does not change the notes for dimensions.

These dimension attributes are converted but are changed during the conversion process:

Dimension names:
- Original dimension names are converted into new dimension names using the part names conversion method.
  For more information, see the Part Names Conversion Method section.
- Original dimension names are also converted into new dimension descriptions.
Total member names.
If a dimension contains a Total member, the name of the Total member is converted to an alias of the root node used in the analytic model.

These dimension attributes are not converted:

Dimension members.
Default Alias Function property.

User Functions

PTAEACECONV converts all user functions.

These user function attributes are unaffected by conversion:

Rules that have been defined to use within user functions.
References to user functions from other parts.
For more information, see the Expression Modifiers section below.

These user function attributes are changed during the conversion process:

User function names:
- Original user function names are converted into new user function names using the part names conversion method.
  For more information, see the Part Names Conversion Method section.
- Original user function names are also converted into new user function descriptions.
Code used in user functions.

For more information, see the Expression Modifiers section.

PTAEACECONV does not convert these user function categories:

Calculation Function.
Alias Function.
Formatting Function.

Expression Modifiers

PTAEACECONV converts all expression modifiers. Converted expression modifiers exist as user functions in the analytic model.

PTAEACECONV does not affect rules that are defined for expression modifiers.

These expression modifier attributes are converted but are changed during the conversion process.

Expression modifier names:
- Original expression modifier names are converted into new expression modifier names using the part names conversion method.
  For more information, see the Part Names Conversion Method section.
- Converted names of expression modifiers include the prefix EXP_.
- Original expression modifier names are also converted into new expression modifier descriptions.
Code used in expression modifiers.
For more information, see the Expression Modifiers section.

PTAEACECONV does not convert references to the original expression modifiers.

Table Views

PTAEACECONV converts all table views into cube collections. Note that BAM 8.8 table views lack important information needed to complete cube collections, including:

Main and aggregate records.
Field mapping between dimensions and data cubes to fields in the main and aggregate records.
See Mapping Data Cubes and Dimensions to Fields.

For this reason, you must provide this information in the converted analytic model.

These table view attributes are unaffected by conversion:

All references to data cubes.
All references to dimensions.
Notes.

PTAEACECONV changes table view names in the following manner:

Original table view names are converted into new cube collection names using the part names conversion method.
For more information, see the Part Names Conversion Method section.
Original table view names are also converted into new cube collection descriptions.

These table view attributes are not converted:

All references to timelines
All references to expression modifiers
Prefix modifiers
All table view-related properties, including:
- Coordinates
- Positions of dimensions in table views
- Table header cells
- Sections of table views
Table data

Import Maps

PTAEACECONV converts all import maps into cube collections. Note that BAM 8.8 import maps lack important information needed to complete cube collections, including:

Mapping between cube collections to main and aggregate records.
Field mapping between dimensions and data cubes to fields in the main and aggregate records.
See Mapping Data Cubes and Dimensions to Fields.

For this reason, it is necessary for application developers to provide this information in the converted analytic model.

These import map attributes are unaffected by conversion:

All references to dimensions
All references to data cubes
Notes

PTAEACECONV converts import map names but changes the names in the following manner:

Original import map names are converted into new cube collection names using the part names conversion method.
For more information, see the Part Names Conversion Method section.
Original import map names are also converted into new cube collection descriptions.

PTAEACECONV does not convert all table view-related properties, including:

Coordinates.
Positions of dimensions in import maps.

Organizers

PTAEACECONV converts all organizers.

These organizer attributes are unaffected by conversion:

Hierarchies within organizers (for example, folders within folders).
Notes.
References to all parts except:
- Expression modifiers
- Prefix modifiers
- Styles

PTAEACECONV converts organizer names but changes them in the following manner:

Original organizer names are converted into new organizer names using the part names conversion method.
For more information, see the Part Names Conversion Method section.
Original organizer names are also converted into new organizer descriptions.

PTAEACECONV does not convert organizer references to these parts:

Expression modifiers
Prefix modifiers
Styles
Chart views