Not all Members being included in the Demantra Worksheet / Export View is not including all rows (Doc ID 969874.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

Seen on v7.3.0 or v7.2.0.3 (either on a new install or after an upgrade from v720 or lower where the columns mdp_matrix.from_date and mdp_matrix.until_date didn't exist).  Also reported on v7.3.1 and higher

Find various symptoms including:

1. Combinations are being filtered out depending on whether they have any sales_data records in the historical time frame selected. Thus if only “forecast horizon” dates are selected, no combinations are returned.  For example, a worksheet with a time filter -12/+12 doesn't return the correct number of combinations but if you increase the range to -36/+36 then the right number of combinations are returned.
2. Find that not all of the children of a parent level are not being returned when you add the child level to the Aggregation Level of the Worksheet.  For example, the Product Family level has a member called Cakes who has 20 unique members at the child Item level but only 12 are displayed when you add the Item Aggregation level to the worksheet even with no other filters
3. Using the example in #2, find that it appears that an Override entered at the Product Family level returns reflects the correct value at the Product Family level but not all of the Override can be accounted for at the child Item level.
4. Export Views (ex. BIEO_FORECAST_VIEW) do not seem to contain all combinations that should normally get exported
5. Some records are not included when publishing forecast data. The workflows complete normally, there are no errors in the BIEO_*_ERR tables, but some records are missing in the msd_dp_scn_entries_denorm table.
6. Opening a Worksheet returns NO DATA. Collaborator log file shows the following error: ODPM-70012: There is a problem when m_name == null || tableName == null
7. Items have valid record in the sales_data table, however, the list price is being rejected and the biio_list_price_err table shows the following error: ODPM-00080: The levels combination LEVEL1 does not exist in table: MDP_MATRIX
8. Not all combinations present on the database are shown on the worksheets.

Cause

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