Description of the illustration bipub_rpteditor.gif

Creating a Data Model in the BI Publisher Report Editor: This screen capture of the Report Editor displays the following items in a navigation tree: Data Model, List of Values, Parameters, Layouts, and Bursting. The Data Model folder is expanded to show a data set named Sales Query. The Data Set page shows the following entries:

• Name: Sales Query

• Type: SQL Query

• Data Source: Default Data Source

• SQL Query: The SQL query against UNITS_CUBE_VIEW shown previously in this chapter.