The full range of editor functions in data model are supported for these dataset types:

• SQL queries submitted against Oracle BI Server, an Oracle Database, or other supported databases. Publisher can retrieve the metadata information from these SQL queries.

  See Create Datasets Using SQL Queries.

• Multidimensional (MDX) queries against an OLAP data source

  See Create a Dataset Using a MDX Query Against an OLAP Data Source.

• Queries against your LDAP repository to retrieve user data

  You can report on this data directly, or join this to data retrieved from other sources. See Create a Data Set Using an LDAP Query.

• Microsoft Excel spreadsheet data sources

  You can store the Excel spreadsheet in a file directory set up as a data source by your administrator, or you can upload it directly from a local source to the data model. See Create a Dataset Using a Microsoft Excel File.

• XML data file data sources

  You can store the XML file in a file directory set up as a data source by your administrator, or you can upload it directly from a local source to the data model. See Create a Dataset Using a XML File.

• CSV (comma separated value) file data sources

  You can store the CSV file in a file directory set up as a data source by your administrator, or you can upload it directly from a local source to the data model. See Create a Dataset Using a CSV File.

Dataset types that can use partial editor functions in data model

Publisher can retrieve the column names and data type information from the data source of these dataset types, but it can't process or structure the data. Only a subset of the full range of editor functions in data model are supported for dataset types:

• Analysis

  See Create a Dataset Using an Analysis.

• View objects created using Oracle Application Development Framework (ADF).

  See Create a Data Set Using a View Object.

• Visualization

  See Use Self-Service Analytics.

Dataset types that can't be modified in the data model editor

For these dataset types, Publisher can retrieve the data generated and structured at the source. You can't apply additional modifications in the data model editor for these dataset types:

• HTTP XML feeds off the web

  See Create a Dataset from an HTTP XML Feed.

• Web services

  See Create a Dataset Using a Web Service.

  To use a web service to return data for the report, supply the web service WSDL to Publisher and then define the parameters in Publisher.