How To Substitute Essbase Alias “Product – Default” in OBIEE Repository


In order to use Essbase Aliases on BIEE Answer, make sure that 2 setting is configured appropriately in the repository.

1.The length of “Physical Cube – Product – Default” should be appropriate (ex. VARCHAR 128).

1-1. Launch BI Administration Tool, and navigate Tools > Query Repository

1-2. Search the “Type: Physical Cube Column” for “Product – Default.”

Obiee-essbase1

1-3. Change the Length from 0 to appropriate value such as 128.

Obiee-essbase2

1-4. Press OK.

2.Product dimension should have Aliases created on the physical layer.

2-1. Right Click on Product Dimension, Create Columns for Alias Table.

Obiee-essbase3

2-2. Select an alias for “Default”

Obiee-essbase4

The above procedure will work for substituting “Product – Long Names”, “Product – Member_Name” , or other Essbase members.

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s