I don’t think I need to provide an introduction to Text Lists in Essbase. (however if you are not aware of it, please go through http://docs.oracle.com/cd/E12825_01/epm.111/esb_dbag/frameset.htm?dtypmeas.htm)
This blog is about “How to Import a text list?”
I was once trying to import a text list into EAS and I never ever (not even in my wildest dreams) had an idea that ‘Importing a Text List” will make a blog entry.
As it turns out there is no import button (or it is not highlighted) “Where is my import button?” 🙁
Since I couldn’t find out a way to import a text list I thought creating it from scratch. (Then I made the accidental discovery, I think most of them are accidental 🙂 )
How to import a text list
Create a new text list
Do not click on “Apply” button, instead press “Enter”
There you go, when you hit “Enter”, the “Import” button will be highlighted.
Too many steps and tricks to perform an import operation 🙂
HTH
What's the maximum number of items in the list?
dbag says "A cell that corresponds to a text measure can have one of a finite list of up to 1024 valid text values."
interesting ..but then agn that's wht we get on ur blog 😀
Hi Celvin,
What if, if I have to import the values into the exiting Text List?
Thanks,
Nainitha.
@Nainitha that option is not there, what you can do is export the existing one, open the .slt (don't remember the correct extension) add the new values and then follow the steps described here
Hi Celvin,
The above method is working only when I create New TextList. I am not able to import the updated .slt file to the already existing TextList, because the import icon is disabled. It is getting enabled only when you create a new TextList.
You'll have to delete the existing one and then import this one.
Hi,
How to export/take a backup of text list?
There maybe be an unpublished MaxL for that, till the till Oracle publishes it do it manually
Thank you very much for sharing great accidental discovery. 🙂
Thanks for the information. I think it is a bug. There is no descripion in the DBAG. There is so much potential in this functionality. It is a pity this is not developed further.
Regards,
Philip