My Oracle Support Banner

Server Fetch Runs Slower after Dimension Split with a High Number of Style/Colors (Doc ID 2401986.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 16.0 and later
Oracle Retail Predictive Application Server - Version 16.0 and later
Information in this document applies to any platform.


In Oracle Retail Predictive Application Server (RPAS) version 16.0.2, there is some improvement in the level split performance, but when there is a high number of style/colors in the workbook, the level split still takes a very long time. A workbook with 60,000 style/colors did not finish after 10 mins.

Steps to Recreate:

1) Log in to Fusion Client.
2) Create a new workbook in the global domain. Select all SKUs, weeks and locations in the wizard.
3) Click on Level split in the toolbar, select new split.
4) On the New split dialog, select
Dimension - Product
Level - Sku
Attributes - SplitAttribute1
and click ok
5) New split is displayed in the workbook.

Check the time taken to create the level split in the workbook.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.