Categories
- All Categories
- 151 Oracle Analytics News
- 28 Oracle Analytics Videos
- 14.8K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
Fusion Analytics Dataset Series: Dataset using queries
Datasets are self-service data models that you build specifically for your data visualization and analysis requirements.
A dataset can be based on one table, spreadsheet, or file. Or a dataset can be a self-service data model that contains multiple tables with relationships defined between the tables.
You can create datasets from data from files that you upload, or SaaS applications, Oracle Analytics reports, and many relational and big data sources that you build connections to. See Data Sources Available for Use in Datasets.
Datasets are subsets of the file or data source's data that you curate and shape to meet your specific analytics and visualization needs. A dataset contains data source connection information, tables, the columns you specify, and the data enrichments and transformations that you apply.
You can use a dataset in multiple workbooks and in data flows. If you change a dataset, changes affect all workbooks and data flows that use the dataset.
The post describes how our users can create datasets using sql queries
Comments
-
Can I ask a quick question? Why I can't see Manual Query option under Local Subject Area?
0 -
Alvaro - It may be issue with your level of access
2 -
This is an old post but I can't see the option either and I am the FAW Service Administrator. Thought?
0 -
You will be able to see this as service Admin . Any anomalies login a support ticket
0