Creating Text Entry in Essbase – SmartList

Essbase Text Entry – SmartList

You might all have known that Essbase does not store text. Yes, in a sense it doesn’t but it stores SmartList. In a way, smartlist are numbers that are tied with text. Payment terms maybe a good example to demonstrate this.

First, in your BSO / ASO outline, open up the Properties tab like below and ensure Typed Measures enabled is true (which is not by default). Then you will have a Text List Manager tab.

1_SmartList

Then next step would be to go to the Text List Manager tab. Add a new list called Payment Terms like my example and create 10 Days Term and 30 Days Term like below. Assign 21 and 28 respectively.

2_SmartList

Although you can assign any number you like, but let’s keep in sync and follow my numbers for now. You can play around later.

Now go back to your Outline tab and create an account called Payment Terms. Then edit it’s properties.

There are 2 things you will need to set for this member.

1. To change it to Type: Text instead of Numeric

2. Then Select Text List: Payment Terms

3_SmartList

Once done. Open up your excel and use either SmartView or Excel Addin. I used SmartView since I’m on 11.1.2.3 and Excel Addin is not supported says Oracle. My server environment is also on Windows 7. Anyway, the idea is to connect to that database and enter up a level 0 member for data entry. Your combination will be different from mine obviously. But the idea is to submit (or called lock and send in the old fashion way) 28 to Essbase for Payment Terms, like below. My Total Product is actually level 0 so don’t wonder why I’m on ASO and submitting on non-level 0 members.

4_SmartList

Then refresh or retrieve after you have submitted the number. You should not get 30 Days Term.

5_SmartList

The interesting part is that OBIEE doesn’t seem to support SmartList for some reason.

Update August 19th, 2014

From Oracle Support, OBIEE does not officially support Text List from Essbase. It has been raised as enhancement from Bug 18464580.

OBIEE_TextList_OracleSupport

OBIEE_TextList_Bug18464580

 

Advertisements

Author: Steve Yeung

Being in the EPM & BI field for more than 8 years, it's about time I contribute to newcomers! As a founder of MondayBI.com I wish to give you all the help I can. Feel free to give any suggestions or questions. Hope you will all enjoy this blog! William Wong Essbase Certified Specialist OBIEE Certified Specialist

2 thoughts on “Creating Text Entry in Essbase – SmartList”

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