1. Designing Pixel-Perfect Reports in Oracle Analytics Cloud
  2. Build Data Models for Pixel-Perfect Reports
  3. Use the Data Model Editor
  4. About the Data Source Options

About the Data Source Options

Data source types supported for creating datasets can be categorized into three general types.

You can connect to on-premise data sources over a Private Access Channel (PAC). See Connect to Private Data Sources Through a Private Access Channel.

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.

  • 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:

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: