Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Insert Member Property

    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:

    1. Select the XLCubed > Insert Formula > Member Property ribbon or menu option
    2. Choose a location for the new formulae
    3. Choose the connection to use from the dropdown
    4. Select the hierarchy the desired property belong to
    5. Select the member to use
    6. Choose a member property from the Property dropdown
    7. Click OK and the formula will be inserted

    See Also