| Oracle® Retail Merchandise Financial Planning Cloud Service and Oracle® Retail Merchandise Financial Planning Enterprise Edition Cloud Service Administration Guide Release 18.0 F10753-05 |
|
 Previous |
 Next |
| Oracle® Retail Merchandise Financial Planning Cloud Service and Oracle® Retail Merchandise Financial Planning Enterprise Edition Cloud Service Administration Guide Release 18.0 F10753-05 |
|
Previous |
Next |
Hierarchy management in MFP Cloud Service can be primarily classified into two features provided by the RPASCE Platform:
Hierarchy Maintenance
Hierarchy Loading
Hierarchy Maintenance
The MFP Cloud Service Administrator can utilize the RPASCE capability to maintain user-named and user-defined dimensions within hierarchies. Per the business needs, the Administrator can create custom-made dimensions from Hierarchy Maintenance.
To illustrate the concept with an example, suppose the different classes of product by default hierarchy belong to different departments. By using the default hierarchy, the Administrator does not have the option to group different classes from different departments to put together into one logical grouping. Hierarchy Maintenance provides that power to the Administrator to put different classes into class groups (for example: A,B,C). This flexible grouping of classes can make it easier for the user to view information such as planning, replenishment, or measure analysis reports.
The Administrator needs to remember that any hierarchy in RPASCE can have user-defined dimensions within it as long as they are set up by the Administrator's company at the time of installation. The examples in this section refer to the product hierarchy, but other hierarchies can be maintained in the same way.
For detailed steps and a description for Hierarchy Maintenance, see the information on the Hierarchy Maintenance workbook in the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.
Hierarchy Loading
Loading of hierarchy position is one of the important regular tasks performed by the Administrator. Loading and refreshing of the hierarchy are made simple by the default RPAS OAT task Load Hierarchy Data (loadHier). The primary function of this task is to add, remove, and reclassify positions in the hierarchy. The loadHier task also supports the purging of data in parallel while loading new positions.
To manage the addition, removal, and reclassification of positions in a hierarchy, RPASCE uses a methodology called integer indexing. It is used to manage multidimensional data at the storage level. The loadHier task also provides a simple compression method that can skip duplicated values.
RPASCE supports loading of the hierarchy by multiple input files. The Administrator must load the extra input files along with the main input file.
The Load Hierarchy Data (loadHier) task supports comma-separated values (CSV) or fixed width flat files for loading. The load file requires a .dat file extension for flat files and a .csv.dat file extension for a CSV file.
The detailed steps and description for hierarchy loading are documented in the Oracle Retail Predictive Application Server Cloud Edition Administration Guide.
