Level Filters Does Not Work In DSM Worksheets

(Doc ID 2055445.1)

Last updated on AUGUST 21, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version and later
Information in this document applies to any platform.


On : version, Worksheet


When we apply a filter at the user level, it is not applied in DSM worksheets (Alias Levels). Our Hierarchy is BILL TO --> Promotion Planning. The promotion Planning (Customer) 'TESCO' has three BILL TOs. If we create a user with level filter of TESCO, the user can see promotions of only TESCO (as expected) but the user can see the Settlements for all the Promotion planning.

Customer expects DSM worksheets to respect the same filters and user should be able to only see the Settlements for TESCO only

The issue can be reproduced at will with the following steps:
1. log into Collaborator Workbench
2. open the DSM worksheets
3. check the worksheet results


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 hundreds of Community platforms