Sample Excel Formulas

[RobDessureault]

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.

[Vincent]

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