Member properties

A Member Property is an additional piece of information that can be added to any existing dimension.

E.g., if you have a Customer dimension with the Customer Name, you can add all the customer's other formal information as member properties - formal information such as:

• Address
• Phone number
• Email address
• Etc.

One of the advantages of using a Member Property is that the information - the dimension member information and the member property information - is retrieved by only one database query. If the same information needed multiple dimensions, it would require at least one query per dimension. So the gain is mainly a performance gain.

Another advantage, specifically related to TARGIT, is that member properties with email addresses can be used in a very efficient way together with batch scheduled jobs. (https://community.targit.com/hc/en-us/articles/360017063998-Batch-scheduling)

To set up a Member Property in the Data Model Editor, you should drag and drop the field from the table to one of your existing dimension attributes.