Define Named Ranges

If you want to publish report data as Business Views (BVs), you need to define named ranges before uploading the Excel workbooks to Reports Center. Named ranges identify the data areas and headers that will be available for publishing as a Business View.

  1. In the report in Excel, select the table area: header, data rows and one extra blank row (required for BVs).

  2. Go to Formulas > Name Manager.
  3. Click Define Name and fill in other properties.
  4. Make sure Refers to property covers the header, data, and extra blank row. Now, you can save your report and upload it to Reports Center.

After defining the named range and uploading the report to Reports Center, you can publish report data as BVs.

Was this article helpful?

We're sorry to hear that.