Entering TEXT data in Essbase using Text List
In essbase 11 onwards there is an option to have planning smartlist like functionality in Essbase cube .. This new functionality is called Text List .. Just like planning smartlist, using essbase text list you can enter Text data in essbase also, you can restrict entries as in smartlist. Following is the process for having textlists in Essbase.
1. Enable type measures for essbase database : Go to Outline Properties and enable Typed measures.
Add caption
|
2. Creating Text List : Just like planning smartlist , create Essbase text list by going into Text List Manager Tab. In below screenshot I have created a text list for inserting ratings.
3. Apply data type as Text and assign
TextList : In below example I have assigned Rating Textlist to Rating account.
Now your Essbase tasklist is ready for use .. You can use it just like Smartlist from smartview. Also, using excel ad-in you can simply lock n send text data into Essbase. For calculation purpose just like Smartlist you can use id value ..
hadoop training
ReplyDeleteData Science training
linux training
mulesoft training
web methods training
business analyst online training
oracle adf online training
oracle rac online training
ReplyDeleteThe tutorial is very helpful for a first timer like me, by the way if you could have given a
tutorial on creating a free blog, it would have been very helpful for newbies like me.
click for info