PBCS: Duplicate Alias Error in Smart View
Last updated on APRIL 23, 2018
Applies to:Oracle Planning and Budgeting Cloud Service - Version 126.96.36.199.412 and later
Information in this document applies to any platform.
We have a custom Period dimension with multiple hierarchies. There is a different hierarchy for each plan type. Within a single plan type, there are no duplicate aliases, however across the plan types there are duplicate aliases. We have set the hierarchies to not apply to the other plan types, however we are still getting duplicate aliases errors in SmartView. We are looking to confirm if we can have duplicates across the application, but not within the same plan type.
Does the duplicate alias rule apply to the application or the plan type?
The issue is that we have one member's name the same as another member's alias. The 2 members are in separate/mutually exclusive plan types. Smart View throws an Alias error when retrieving/drilling on the dimension. no error on DB refresh, just data retrieval via SV.
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