Question: How can I list multiple accounts within a single Excel XF Get Cell function?

• You cannot list multiple accounts within the same XFGetCell function. The XFGetCell function retrieves a cell from the cube based on parameters supplied.
• To retrieve multiple accounts, you can add multiple XFGetCell functions within the same Excel cell e.g =XfGetCell(Parameters) + XfGetCell(Parameters)
• Using multiple XFGetCell functions within the same cell may be less performant than having the XFGetCell functions in separate Excel cells.
  • In this case, you may want to retrieve each account using XFGetCell functions in separate rows, hide these rows and then use standard Excel SUM function to add the values together.

 

Source:  Office Hours 2021-06-10 - Partner Enablement