Try Saving the Workbook in Design Mode and Uploading Again Jet

This topic describes what y'all need to know to work with a workbook's datasets.

Add Datasets to a Workbook

Your workbook tin can utilize more than one dataset.

When you add more than i dataset, Oracle Analytics blends the data. You tin can cheque the default blending, or update or add information blending between datasets. Come across Alloy Datasets.

1. On the Domicile folio, select a workbook, click the Actions card, and and so select Open.
2. In the Visualize canvas, become to the Data panel, click Add (+).
   
   Description of the illustration data_set_add_to_project_button.jpg
   
3. Select Add Dataset. In Add Dataset, select a dataset and click Add to Workbook.
4. Optional: Click Data to go to the Data Diagram and view how the datasets are composite.

Supplant a Dataset in a Workbook

When you replace a dataset, Oracle Analytics suggests how yous can re-map the columns from the dataset that you replaced to the replacement dataset. You can have or update these suggested mappings.

For example, you might replace a workbook's exam dataset with a production dataset. Or you can re-create a workbook and its visualizations, and so use the indistinguishable workbook as a template. After you rename the duplicated workbook, you can add together a different dataset.

When you replace the dataset, any data mapping that you specify is applied to the workbook. For instance, if y'all map a data element to None, the specific data is removed from the workbook's visualizations, calculations, and filters.

1. On the Home page, select a workbook to use as a template, click the Actions bill of fare, and so select Open.
2. From the Visualize page, click Data.
3. In the Data page, click the Data Diagram.
4. Optional: If the dataset that you want to supervene upon has been blended with another dataset, then in the Data Diagram click the number between the dataset icons.
   
   Clarification of the illustration data_blending_number.jpg
   
5. Optional: In the Blend Data dialog, click Delete All Matches, specify which dataset to delete conformance from, and so click OK.
6. Locate the dataset to replace and click Actions.
   
   Description of the illustration data_set_replace_data_set_in_project.jpg
   
7. Select Supervene upon Dataset.
8. In the Replace Dataset dialog, click the replacement dataset. Click Select.
9. Review, update, and specify the column mappings for the workbook'southward visualizations, calculations, and filters.
10. Click Replace.
11. Optional: If y'all want to add together blending betwixt datasets, and then in the Information Diagram, click between the datasets that you want to blend, and in the Alloy Data dialog add column matches.

Remove a Dataset from a Workbook

Y'all can remove a dataset from a workbook. When you do this, you remove all of the dataset's columns from the workbook'south visualizations, filters, and calculations.

1. On the Home page, select a workbook, click the Deportment menu, and then select Open up.
2. In the Visualize canvas, go to the Data Panel pane, right-click the dataset that you desire to remove, and select Remove from Workbook.
   
   Description of the illustration data_set_remove_data_set_from_project.jpg
   
3. Click Save.

Alter a Workbook'due south Datasets

Y'all tin can utilise the Workbook Editor's Data page to navigate to the Dataset editor or Transform editor to view or alter a workbook'southward datasets.

When you locate a dataset's icon in the data diagram and click Edit, a new browser tab opens that contains the editor that you use to view or modify the dataset. The Workbook Editor remains open in its own browser tab and immediately reflects any saved dataset changes.

Note:

A dataset tin can be used in multiple workbooks and information flows. Modifying a dataset impacts all workbooks and data flows that use the dataset.

1. On the Dwelling house folio, select a workbook, click the Actions menu, and and then select Open.
2. In the workbook editor, click Information to go to the Information folio.
3. In the information diagram, locate the dataset and click its Open push.

   The tab that's displayed depends upon the dataset you selected:

   • If the dataset uses a connexion that doesn't back up multiple tables (for instance, spreadsheet or file, subject area expanse, or Essbase), then the Transform Editor is opened in a tab.
   • If the dataset uses a connection that supports multiple tables (for example, Oracle Database or Oracle Democratic Data Warehouse), then the Dataset Editor is opened in a tab.
4. Optional: If the Dataset editor is displayed, click the tab for the table that you want to view or modify and the Transform Editor is displayed.
5. Change and save the dataset.

Alloy Datasets

This topic explains blending and how to blend a workbook'due south datasets.

Sympathize Blending

When you add more than i dataset to a workbook, Oracle Analytics tries to match columns between the datasets that yous added. This matching is called blending.

For instance, Dataset A might contain new dimensions that extend the attributes of Dataset B. Or Dataset B might comprise new facts that y'all can utilise alongside the measures that already exist in Dataset A.

Blending automatically matches external dimensions where they share a mutual proper name and take a compatible data type with attributes in the existing dataset.

Datasets that aren't blended are divided past a line in the workbook's Data Panel.

In that location are restrictions between data elements and visualizations when a workbook contains datasets that aren't blended. For example, if your workbook contains two datasets that aren't blended, then y'all can't include the data elements of one dataset in the filters, visualizations, or calculations of the other dataset.

Blending relationships are stored in the tables and not in the workbook. So any blending matches that you add together or remove impact the other datasets that apply the same tables.

Note:

Your workbook might contain a dataset that includes tables from different connections and schemas. When datasets comprise multiple tables, the tables well-nigh likely incorporate joins. See Understand Dataset Table Joins. In your workbook, you tin alloy datasets that comprise multiple tables and joins. For example, you lot can add and blend datasets with multiple tables when you want your workbook to contain cross fact analysis.

About Mismatched Values in Blended Information

In some cases when the rows of information that you lot wait to see in a dataset are missing, then yous must specify which dataset to use for data blending.

Sometimes rows of data are missing when your workbook includes data from 2 datasets that incorporate a mixture of attributes and values, and at that place are match values in i source that don't exist in the other.

Suppose we have 2 datasets (Source A and Source B) with slightly unlike rows, as shown in the post-obit image. Notation that Source A doesn't include IN-viii and Source B doesn't include IN-vii.

The post-obit results are displayed if you select the All Rows data blending option for Source A and select the Matching Rows information blending option for Source B. Considering IN-7 doesn't exist in Source B, the results contain null Rep and null Bonus.

The post-obit results are displayed if you lot select the Matching Rows data blending option for Source A and select the All Rows data blending selection for Source B. Because IN-viii doesn't be in Source A, the results contain null Appointment and naught Revenue.

The visualization for Source A includes Date as an attribute, and Source B includes Rep as an attribute, and the lucifer column is Inv#. Under dimensional rules, yous tin can't use these attributes with a mensurate from the opposite table unless you also utilize the match column.

At that place are two settings for blending tables that contain both attributes and measures. These are gear up independently in each visualization based on what columns are used in the visualization. The settings are All Rows and Matching Rows and they describe which source rows the system uses when returning data to be visualized.

The arrangement automatically assigns data blending co-ordinate to the following rules:

• If the visualization contains a match cavalcade, then the organization sets sources with the match cavalcade to All Rows.
• If the visualization contains an aspect, so the organization sets its source to All Rows and sets the other sources to Matching Rows.
• If attributes in the visualization come from the same source, then the system sets the source to All Rows, and sets the other sources to Matching Rows.
• If attributes come up from multiple sources, then the system sets the source listed first in the workbook'southward elements console to All Rows and sets the other sources to Matching Rows.

Blend Datasets

If your workbook contains multiple datasets, and then yous can blend data in i dataset with data in another dataset.

When you add more than one dataset to a workbook, the system tries to find matches for the data that's added. Information technology automatically matches external dimensions where they share a common name and have a compatible information type with attributes in the existing dataset. Blending relationships are stored in the tables and non in the workbook. So any blending matches that yous add or remove affects the other datasets that utilize the same tables.

See Empathise Blending.

Note:

Datasets can include multiple tables from different connections and schemas. These datasets use joins, which are divers in the Dataset editor. To reduce or eliminate blending in workbooks, Oracle suggests that whenever possible you create datasets that contain multiple tables and use joins. Meet Create a Dataset From a Connexion.

1. On the Domicile page, select a workbook, click the Actions menu, and and so select Open.
2. To add another dataset to the workbook, so click Data, and in the Information page, go to the Data Panel, click Add (+), and then Add Dataset.
3. In the Add Dataset dialog, select a dataset and click Add to Workbook.
4. In the Data page, go to the Information Diagram and locate the datasets to blend.

   You lot can't blend datasets that employ Oracle Essbase or Oracle Enterprise Performance Management data sources.

5. Click the number between the dataset icons.
   
   
6. Optional: To change the lucifer for a column, click the name of the column and select a unlike column.

   If columns have the same proper name and same data type, then they're recognized as a possible friction match. You can customize this and specify that one cavalcade matches some other by explicitly selecting information technology even if its proper name isn't the aforementioned. You tin select merely those columns with a matching information type.

7. Optional: Click Add Another Match, and in the table, select the columns that yous want to bring together.
8. Optional: For a measure that y'all're uploading for the commencement time, specify the assemblage type such every bit Sum or Average.
9. Click OK.

Change Data Blending in a Visualization

You can modify a visualization's properties to override the workbook's data blending settings.

1. On the Domicile page, select a workbook, click the Actions bill of fare, and so select Open.
2. In the workbook, select a visualization, and in the Properties Panel click Datasets.
   
   
3. To change the default blending, click Data Blending, and select either Machine or Custom.

   If you choose Custom, you tin can set the blending to either All Rows or Matching Rows.

   • Y'all must assign at least one source to All Rows.
   • If both sources are All Rows, so the organisation assumes that the tables are purely dimensional.
   • You can't assign both sources to Matching Rows.

brownaboaccon.blogspot.com

Source: https://docs.oracle.com/en/cloud/paas/analytics-cloud/acubi/work-workbooks-datasets.html

Share this post