User Defined Attributes in EssBase

21 September, 2018


Related Blogs

User Defined Attributes (UDA):

UDAs are also used to define characteristics of some other members. UDA s are mainly used to group related items together. The main advantage of UDA is that it can be associated to either dense or space dimensions.

Attribute dimensions give more flexibility over UDA, because, Attributes have in-built functions, sun, min, max, count, and average, etc. We have to write calculation scripts, or we have to create run-time calculations in any reporting tool.

To create UDA manually, write click on any member and click edit member properties, Click UDA tab. Enter a UDA name next to the ASSIGN text box and click assign. Click ok.

Note: To remove UDA s completely from the outline, un-assign all UDA s and save the outline. Re-open the cutline, and all the UDA s will be removed.

INDIA       SI     AP             SMALL

INDIA       SI     TN             MEDIUM

INDIA       NI     UP             LARGE

INDIA       NI     DELHI       MEDIUM

  • Open data prep editor. Click file-> open data file. (or Click file-> open SQL and enter the select statement)
  • Map the first column to Gen 2 for geography and second column to Gen 3, Third column to Gen 4, and for the final column, select field type as UDA.
  • Click Options, Dimension build settings, Dimension build settings. Select “Allow property changes” checkbox also select “Allow UDA changes” to allow for only UDA changes in the outline.
About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .