Creating named ranges

This example procedure will show you how to specify Named Ranges for selection in the Query Editor.

To create a named range:

  1. Open Infor BI Q&A in Microsoft Excel.
  2. In cell A1, enter PK1 as the Business Unit code then highlight cell A1 and enter BU_Code in the Name Box.
  3. In cell B1, enter 81001 as the Account code then highlight cell B1 and enter AC_From in the Name Box.
  4. In cell C1, enter 810101 as the Account code then highlight cell C1 and enter AC_To in the Name Box.
  5. In cell D1, enter 2005/001 as the Period From code then highlight cell D1 and enter Period_From in the Name Box.
  6. In cell E1, enter 2005/008 as the Period To code then highlight cell E1 and enter Period_To in the Name Box.
Parent topic: Named ranges