Knowledge Base Article

Sample Excel Formulas

Attached is a 4 tab Excel file that has many sample Excel formulas. It shows you how to reference the 18 dimensions in order to pull or push data as well as pull in metadata attributes.

Areas of examples include: XFSetCell  /  XFGetCell  /  XFGetMemberProperty  /  XFGetRelationshipProperty  /  XFGetMemberInfo.

This is an excellent file to help you get up and running quickly using Excel formulas.

 

Updated 11 months ago
Version 5.0
Excel
Templates
  • Vincent's avatar
    Vincent
    New Contributor III
    7 months ago

    Thanks a lot for the work.

    For this function : XFGetRelationshipProperty is it possible to have the parent in a hierarchy. For example, if I have a entity Member AAA with 3 children BBB, CCC, DDD. Is it possible to use the formula pointed on "BBB" and have as a result "AAA"? 

    Thanks