PBCS: Duplicate Alias Error in Smart View

(Doc ID 2388190.1)

Last updated on APRIL 23, 2018

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 11.1.2.3.412 and later
Information in this document applies to any platform.

Goal

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.
 

Solution

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