• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

User Defined Attributes in EssBase

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” check box also select “Allow UDA changes” to allow for only UDA changes in the outline.
Summary
Review Date
Reviewed Item
User Defined Attributes in EssBase
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on User Defined Attributes in EssBase"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.