Fusion Applications Smart View: Alias Table In Smart View Does Not Retrieve The Expected Default Values

(Doc ID 2006544.1)

Last updated on SEPTEMBER 08, 2015

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Application Toolkit - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Goal

How do we configure so that we can see the true default alias (as shown in FR Studio) to render in Smart View?

In Smart View all aliases render only the member name - not suitable for presentation reports/analysis.

The member name as it appears.

Example for member below:
[Department BPU2-Department BPU2 Current].[ALLDEPTIDS].[COMMON].[ACCOUNTING]
When the default should be showing "Accounting".


 

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