| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Insert Member Property
Revision as of 14:58, 13 October 2010 by Antonio.remedios (talk) (Created page with '{{Code|XL3PropertyLookup}} formulae can be inserted directly into the spreadsheet using the {{Menu|XLCubed|Insert Formula|Member Property}} ribbon or menu o…')
XL3PropertyLookup formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Member Property ribbon or menu option.
To insert a member property:
- Select the XLCubed > Insert Formula > Member Property ribbon or menu option
- Choose a location for the new formulae
- Choose the connection to use from the dropdown
- Select the hierarchy the desired property belong to
- Select the member to use
- Choose a member property from the Property dropdown
- Click OK and the formula will be inserted
