14 Placeholder Maintenance
Placeholder maintenance enables planners to dynamically create, modify, or delete placeholder positions at selected hierarchy levels so that they can plan for future expected items and locations that do not currently exist in the system. As part of system configuration, Placeholder Maintenance must be enabled for the required dimensions and levels. The planner is able to choose the options Use Like Item and Assign Attributes in order to create a placeholder position.
When an informal position is to be made formal, the position's name (a label is not necessary for the update to occur) must first be updated to reflect the correct position name that will be loaded during the load process. Prior to the load, an administrative utility run against the environment to change the status of a position from informal to formal (see the Oracle Retail Predictive Application Server Administration Guide for the Fusion Client for more information on the updateDpmPositionStatus
utility). This process enables the loading and purging of that position through the hierarchy load process and disables further placeholder maintenance activities on the position.
Note that Placeholder Maintenance is also referred to as Dynamic Position Maintenance (DPM).
Adding New Positions to a Dimension
The DPM can be launched from the main menu or the context menu to both add and modify positions.
To add new positions to a dimension, complete the following steps:
-
From the Action menu, select Add Positions. The Figure 14-3 window opens.
Figure 14-1 Add Positions Option
Alternatively, you can right-click the position level to access the Add Positions context menu.
Figure 14-2 Add Positions Context Menu
From the context menu, the dimension positions are pre-selected based on the launch context.
-
The Figure 14-3 window opens with values that defaults to first option available. The Dimension and Level selection options are always available.
Selecting Dimensions
-
You can select the dimension for which you want to create the placeholder positions. Only the list of dimensions for which the DPM functionality is enabled displays.
-
You can select the level at which you want to create the placeholder positions. The list of levels depends on the dimension selected and also on the user's ability to create new levels.
Figure 14-3 Add Position
You can either:
-
Enter the number of positions to add in the Number of Positions to Add field.
-
Select the number of positions to add by using the up and down arrow keys.
Create placeholder positions with when you enter details in the Label Prefix field. The label is used for all of the number of positions specified in the Number of Positions to Add field.
Modifying the Values of the Parent Positions
The parent positions of the newly added dynamic positions are shown in the tabular layout of the Figure 14-3 window. The planner can modify the values of the parent positions if required.
You can choose either of the options:
-
Use Like Position
-
Assign Attributes.
When you Choose the Option Then Use Like Position
You select a like position by choosing a position from selection list of existing items.
Assign Attributes
Default attribute values are assigned and the attributes enabled in configuration for that level are displayed.
Specify Attribute Information
If you select the Use Like Position option and then select a position from the list of existing items, you can simplify the process of specifying attribute information for new positions. You can copy the attribute information in part or whole from the Like Position to the new positions using the Copy Attributes with Like Position. This prevents you from having to manually enter the information on an attribute-by-attribute basis.Using Edit Mode.
A row becomes editable with you either:
-
Press Enter and then press F2.
-
Double-click the current row.
Press Tab to navigate to the next cell. Exit Edit mode by pressing either Esc or F2 again.
Figure 14-4 Add Position
-
-
The Figure 14-5 window adds the positions at the launched dimension position level. A unique number is added to the duplicate position labels in the Figure 14-5 window. This unique number is to avoid the addition of duplicate informal positions. You can edit the position label in the Figure 14-5 window
When adding informal positions, a validation error appears in case of duplicate values with the Figure 14-5 or Figure 14-12 windows.
You can add an image for the informal position added from the Add Product window. The first column shows the image and URL text input field. The images added for the informal position defaults to both the thumb and full image designated to main facet for the first media attribute. The Image URL field is not mandatory field, so you can skip addition of an image.
Figure 14-5 Add Product
-
Copy the attribute information from the like position selected to the new positions and click Copy attributes from Like Position. In this way, you do not have to enter the information manually on an attribute-by-attribute basis.
Figure 14-6 Copy Attributes
Click the left and right arrow keys to update alternate hierarchy details of the newly created placeholder position.
-
Click OK and review the new placeholder position that has been created. The placeholder positions are links to help you quickly identify placeholders. The link opens the Figure 14-11 window.
Figure 14-7 Placeholder Position
Note:
The aggregate information (district, region, company, and so on) is populated only if the Add Dynamic Position window is accessed from the right-click menu. If you accessed this window from the Edit menu, these positions are emptyIf there are alternate hierarchies, the value can either be selected or added as new if the alternate hierarchy supports dynamic positions. After multiple positions are added for a level in the position tree, the levels above that level can only support single position add or edit.
Like Item Support in Placeholder Maintenance
You can use Placeholder Maintenance to copy the information from a similar position (Like Item) to the new positions. It facilitates the copying of attribute and metric information from Like Positions to the New positions, under the assumption that the new position will perform in a manner similar to the source of the copied metric data. For details on choosing the level of history cloning and defining a measure on that level for each dimension that supports Placeholder Maintenance, see the Oracle Retail Predictive Application Server Cloud Edition Configuration Tools User Guide.
Figure 14-8 Use Like Position
When a measure is not defined, the message Like Position can only be used to copy attributes for the currently selected level displays. When both the measure and the attributes are not present, the message Like Position is not available for this level displays and the Use Like Position check box is not available.
Figure 14-9 Like Position Not Available
Modifying an Informal Position
After dynamic positions are added to the hierarchy, the DPM process allows you to:
-
Change the parent of a dynamic position to a different formal or dynamic parent.
-
Update the position name and position label.
-
Change the image associated with the informal position
Note:
Only dynamic positions can be modified using the DPM feature. The Modify menu is not visible if there are no dynamic positions in the workspace.
-
Launch Modify Position(s) from the Action menu. Select the dimension and level in the Figure 14-11 window for the placeholder positions that must be modified.
Figure 14-10 Action Menu -Modify Positions
-
The Modify Dynamic Position window opens. Select the desired dimension and level where you want to modify the dynamic position.
Figure 14-11 Modify Position
-
Alternatively, you can right- click one of the positions and select Modify Positions in the right- click menu, or simply click the placeholder position link. The Figure 14-11 window shows the positions for modifying at the launched dimension.
-
The Modify Product window opens. Select the existing dynamic position and then modify the position window label or position name. Alternately, select any parent to change the parent values of the dynamic position that has been created. The parent can be Style/Sub-Class/Class and so on, or an alternative hierarchy. You can the image URL to update the image associated with position. You can also see that the Like Position column of the window contains the like position you set during the position creation.
Figure 14-12 Modify Product
-
When finished, click OK to save and close.
Note:
You can modify the parent position for an informal position only if the parent belongs to the same sub-domain. If you try to modify a parent level for an informal position and if the selected parent does not belong to the same sub-domain, then RPAS CE displays an error message:
Position [position_name] on [level] does not exists in current sub domain. DPM process cannot continue.
Search an Informal Position
You can search for a position in the list of the informal positions added. In the Figure 14-5 or Figure 14-12 window a search text box is available to locate the required position. The total number of informal positions available are displayed next to search text box. The search functionality makes it easy for you to find the required position and make modifications.
Figure 14-13 Search Box
Perform the following steps to search for an informal position in either the Figure 14-5 or Figure 14-12 window.
-
Enter your text characters in the search box to locate the position. You can search for position by position label or related parent position label. While entering characters, the matching results display in the list of positions.
The number of matching positions available are displayed next to the search box. To remove the search result either delete the entered characters or click X within the search box.
Figure 14-14 Search Position Result
-
If there are no matching positions, then the number of matching positions available displays 0 Matching Positions as shown in Figure 14-15
Figure 14-15 Search Position – No Matching Position
Select All Positions
You can select all positions in the Figure 14-5 and Figure 14-12 windows with Select All from the action Menu. This option helps in selecting all the informal positions in the Figure 14-5 and Figure 14-12 windows.
-
Select the Action menu and then select the option, Select All to select all the informal positions in the Figure 14-5 and Figure 14-12 windows.
Figure 14-16 Select All Position
Deleting an Informal Position
After a dynamic position is added, you can delete it and all of its child positions to which it is a parent.
Note:
Only dynamic positions can be deleted using the DPM feature. The delete option is not visible if there are no dynamic positions in the workbook.
-
Right-click the informal position you want to delete.
-
From the right-click menu, select Modify Position and then click X to delete the specific placeholder position.
Figure 14-17 Delete Position
-
The Delete Dynamic Position window opens to indicate the dynamic position that will be deleted and any child positions associated with it are also deleted. Click OK.
Figure 14-18 After Deletion
-
Click OK to save and close the window. The dynamic position is removed from the view.
Figure 14-19 Placeholder Position Removed
Copy and Paste Data Within the Add or Modify Product Dialog Boxes
You can Copy and Paste data from external application to modify placeholder positions. Copy and Paste functionality helps in transferring data between an external application and the Add Product or the Modify Product dialog box. This helps you to quickly update multiple positions or a range of cells while adding or modifying the placeholder positions.
To Copy and Paste data from external application, select the data and use the keyboard shortcut keys Ctrl+C to copy and use Ctrl+V to paste.
Importing Placeholder Positions
Use Import Positions to manually import a list of placeholder positions
and associated images that you have already entered in an Excel (.xslx
) file format. It loads the positions listed in the
file to the Figure 14-24 for validation and highlights errors when corrections are
required. This functionality can be used for the bulk creation of
placeholder positions and adding images for the informal position.
When buyers have clarity regarding the placeholder positions that must be created, including items, styles, attributes, and attribute values, they can enter these details into an Excel file. Then they can create the placeholder positions in the system by importing the file created earlier.
Perform the following steps to import placeholder positions.
-
To import placeholder positions, click the Import Positions icon on the Quick Access Toolbar as shown in Figure 14-20.
Alternately, select the Import Positions menu item in Action Menu or perform a contextual launch of Import Positions.
Figure 14-20 Import Placeholder Icon
Figure 14-21 Imported Placeholder Positions
-
After selecting the Import Positions icon or menu, you are redirected to select the file for upload. The selected file is uploaded to the server and processed.
-
If the import fails, this error message displays: The file import failed. Check the file format and try again.
-
If the import is successful, this message displays: Item list imported successfully.
-
-
The Add Positions window opens populated with the imported files positions. You can edit, modify, or delete the imported informal position records. If a validation failure occurs, an additional message displays.
Download and Update the DPM Import File Template
Perform the following steps to download and update the DPM Import File template.
-
To download the file template, click the Download DPM Import File Template icon as shown in Figure 14-22.
Figure 14-22 Download DPM Import File Template Icon
-
Select the dimension and level.
After clicking the Download DPM Import File Template icon, you are presented with the Select Dimension and Level dialog box. Select the dimension you want to import (for example, Product, location) and then select the level for the specific Dimension (for example, the Product dimension levels can be Style, Style/Color, Item).
Click OK to download a template for the selection dimension and level. You can import up to the lowest level of the dimension supported by the workbook.
Figure 14-23 Select Dimension and Level
-
To add multiple positions, complete the downloaded Excel template and then upload it using Import Placeholder Position. This helps in easy addition of multiple placeholder positions.
The downloaded template has a pre-defined format for each level with various fields to entre. Depending on your selected level, the format of the template changes. The downloaded template presents an example to show how to fill out the template. To add more positions, copy the example and create new line items in an Excel template.
Table 14-1 Template Level Descriptions
Template Level Template Description Template Sheets Template Columns Input Fields Style Color
Consists of two sheets. This template requires you to fill in details related to the style color and its parent style.
Company
Dimension
Dimension at which you need to add position.
Level
Dimension level at which the position is added.
Label
Name of the new style color position added.
Is Parent New
To specify if the parent is new or existing for the new position.
Parent Level
Dimension level of the parent to which the new position belongs to. For style color it is Style.
Parent Label
Name of the parent to which the new position belongs. It can be either new or existing. For new parent style, additional row is provided for adding in the same template
Attribute Name
Name of the attribute, such as Brand, Color, and so on.
Image URL
Image URL for the style color position.
Attribute Value
Value of the attribute with respect to the new position. For reference, few examples are mentioned in template.
Style UDA 1
Parent Label
Style UDA value
Style
Consists of two sheets. This template requires you to fill in details related to the style only.
Company
Dimension
Dimension at which you need to add position.
Level
Dimension level at which the position is added.
Label
Name of the new position added.
Is Parent New
To specify if the parent is new or existing for the new position.
Parent Level
Dimension level of the parent to which the new position belongs. It can be either new or existing. For style color it is always Style.
Parent Label
Name of the parent to which the new position belongs to.
Style UDA 1
Parent Label
Style UDA value
Item
Consists of three sheets. This template requires you to fill in details related to item and style/color.
Company
Dimension
Dimension at which you need to add position.
Level
Dimension level at which the position is added.
Label
Name of the new item position added.
Is Parent New
To specify if the parent is new or existing for the new position.
Parent Level
Dimension level of the parent to which the new position belongs. It can be either new or existing. For style color it is always Style.
Parent Label
Name of the parent to which the new position belongs to.
Attribute Name
Name of the attribute style/color, such as Brand, Color, and so on.
Attribute Value
Value of the attribute for style/color. For reference, a few examples are mentioned in template.
Image URL
Image URL for the style color position.
Vendor
Parent Label
Name of the vendor for the new item position.
Brand
Parent Label
Name of the brand for the new item position.
-
As the upload occurs, it loads the position list to the Figure 14-24 where you can validate and correct any errors.
To add the positions, click OK.
Figure 14-24 Add Product Window
Points to Remember when Importing Placeholder Positions
-
The item level position adding is enabled only in Item planning.
-
The entry in format for Dimension, Level, and Attribute name should be same as given in format. If the value entered is incorrect the DPM import will fail and it shows an error describing which row has the issue.
-
The image uploaded for the position defaults to both the thumb and full image. The image is designated as the main facet for the First Media Attribute.
-
The value of attributes, parent label can be added or changed post uploading the template in the Figure 14-24.
The DPM import shows an error if there is an attribute value not entered or faulty while uploading. Figure 14-25 displays an example of import errors. Fields with errors can be modified on the Add Product dialog window
Figure 14-25 Highlighted Errors in the Add Product Window
Depending on the hierarchy, the file is validated for the rows to select levels and attributes accordingly. You can only create the new levels for which DPM is enabled.
Add Images for a Placeholder Position
You can add an image URL for informal positions from the Add Product window. The image URL added for the position defaults to both the thumbnail and full size image designated to the main facet for the first media attribute. The image URL field is an optional field, so you can skip the specification of an image.
You can add bulk images along with the Excel template while importing the placeholder position. The Excel template for DPM has the field for entering the image URL. The image associated with the placeholder position helps in visual reference for the planner.
To add an image from the Add Product window, then enter the valid image URL in the first input text field provided. Along with the text field, you see an error icon at the row header when the image URL is not valid. The image URL field is also highlighted by a red boundary when there is an error as shown in Figure 14-27.
Figure 14-26 Image URL - Add Product
Figure 14-27 Error Validation in Image URL
Validations in Add or Modify Product Windows
With the placeholder positions you are trying to import, add, modify or delete, you can see an error icon at the row header for any validation errors on the product hierarchy or attributes associated to the placeholder item. The fields that have errors are highlighted by red boundaries. When you hover over the error icon, a tool tip with the following message appears: Some options are not valid. Check the spelling or ensure your workspace is up-to-date.
Figure 14-28 Validation Errors
If the attribute values entered are not valid, the following message appears, Some of the Attribute values entered are not valid. Please select a valid attribute value or remove the invalid value.