Data Preparation in OAC uses obfuscation to protect sensitive information such as SSN, credit card number, and customer number. Obfuscation is a technique that replaces the original values with random or masked values that preserve the format and length of the original values. This way, you can hide or anonymize sensitive information while maintaining its usability for analysis or visualization. References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

List and Expression are two types of filters that can be applied to all Dimensional data types in Oracle Analytics Cloud. A List filter allows you to select one or more values from a list of values for a dimension column. An Expression filter allows you to create a custom filter expression using SQL syntax for a dimension column. The other types of filters, such as Date and Range, are only applicable to specific data types, such as Date and Numeric. References: [Oracle Help Center], [Oracle Help Center]

Oracle Analytics Cloud (OAC) provides various ways to identify and analyze outliers in your data set. Outliers are data points that deviate significantly from the rest of the data and may indicate errors, anomalies, or opportunities. Two layers that you can use to determine which values of a given data set may provide the greatest opportunity due to their outlier qualities are:

• Add an outlier visualization to your canvas. This will highlight data points that stand out and may justify further investigation. An outlier visualization is a type of scatter plot that automatically detects and labels outliers in your data using machine learning algorithms. You can use the outlier visualization to explore the characteristics and causes of the outliers and compare them with the normal data points.
• Create a box plot visualization of your data set. A box plot is a type of graph that shows the distribution of a numerical variable using quartiles and whiskers. A box plot can also identify outliers as data points that lie beyond the whiskers or outside a certain range. You can use the box plot to see how the outliers affect the overall distribution and variation of your data.

References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

There are two possible ways to design the data flow and load data for these two separate data sets in data storage:

• Create two separate data flows for the Country and Sales data sets. Then call one data flow from another using a Call Data Flow step. This will allow you to execute one data flow after another in a single run.
• Create data flows for the Country and Sales data sets. Then create a sequence that defines the order of execution of these data flows using a Sequence step. This will allow you to run multiple data flows sequentially or in parallel. References: [Oracle Analytics Cloud - Data Visualization User’s Guide], [Oracle Analytics Cloud - Data Visualization User’s Guide]

To investigate why a user cannot get answers when using Day by Day with Oracle Analytics Cloud Professional Edition, you can do the following steps:

• Verify that the user has been assigned the BI Content Author and Bl Data Load Author roles. These roles are required to access and use Day by Day features, such as asking questions using natural language or voice, or getting personalized insights based on usage patterns.
• Inspect the data set and check the access control. You need to make sure that the user has sufficient permissions to view and query the data set that they asked a question about.
• Inspect the data set and make sure that it is certified, indexed for searching, and English language is selected. These are some of the criteria that make a data set eligible for Day by Day queries. You can use the Manage menu in Data Sets to check and modify these settings. References: [Oracle Day By Day User’s Guide], [Oracle Day By Day User’s Guide], [Oracle Day By Day User’s Guide]

To change the dashboard prompt range from all pages to only the Sales page, you need to do the following steps:

• In the Dashboard editor, edit the dashboard prompt properties by clicking the Edit View button on the top right corner of the prompt.
• In the Scope tab, select Page as the scope option and choose Sales as the page name from the drop-down list.
• Click OK to save your changes and apply the dashboard prompt only to the Sales page. References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

Refreshing the page is the action that you need to take before the extension is available for use in projects after uploading it to Oracle Analytics Cloud. An extension is a custom plug-in that adds new functionality or enhances existing functionality in Oracle Analytics Cloud. You can download extensions from Oracle Analytics Library, which is a repository of extensions created by Oracle and the community. You can also create your own extensions using the Extension SDK, which is a software development kit that provides tools and resources for developing extensions. To upload an extension to Oracle Analytics Cloud, you need to go to the Console page and select Plug-ins from the menu. Then you need to click on Upload and browse for the extension file (.zip) that you want to upload. After uploading the extension, you need to refresh the page to see the extension in the list of available plug-ins. You can then enable or disable the extension as needed. The other actions, such as enabling the plug-in from the Plug-in menu, restarting the OAC instance, or taking no additional action, are not required or correct before the extension is available for use in projects. References: Oracle Help Center, Oracle Help Center, Oracle Help Center

A single transaction means that all the data flows in a sequence are executed as a unit of work. If any data flow fails, the entire sequence is aborted and the changes made by the previous data flows are rolled back to ensure data consistency and integrity. References: Oracle Analytics Cloud - Data Visualization User’s Guide

To display the report in the click event drilled down in the same window, you can set the drill in place option in section properties. This option allows you to replace the original report with the drilled report in the same section of the dashboard page. You can also use breadcrumbs to navigate back to the original report. References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

After creating a data flow, you need to save the output data to a destination. You have two options to save data in Data Flow:

• Data Set Storage: This option allows you to save the output data as a data set in Oracle Analytics Cloud. You can choose the name, description, and format of the data set. You can also specify whether to overwrite or append the existing data set.
• Database Connection: This option allows you to save the output data to an external database that you have connected to Oracle Analytics Cloud. You can choose the connection, schema, table name, and mode of the database destination. References: [Oracle Help Center], [Oracle Help Center]

Selecting the desired data elements from the Data Elements pane and then right-clicking and selecting Create Best Visualization from the drop-down menu and selecting the desired data elements from the Data Elements pane and dragging them to the Best visualization zone in the Explore pane are two methods that you can use to invoke the best visualization in Oracle Analytics Cloud. The best visualization is a feature that automatically selects the most suitable type of visualization for your data based on various factors, such as the number and type of data elements, the distribution and range of values, and the analytical purpose. You can use these two methods to create the best visualization for your data without having to manually choose the visualization type from the gallery. The other methods, such as changing the project’s properties, selecting the Best Visualization option from the project’s Canvas Settings drop-down menu, and dragging the data elements to a blank area of the canvas, are not valid ways to invoke the best visualization in Oracle Analytics Cloud. References: [Oracle Help Center], [Oracle Help Center]

To create a line chart visualization of revenue data at the day level that displays the last 365 days of data and the next 90 days of forecast, you need to add a forecast and change the Period value to 90. A forecast is a feature that allows you to predict future values of a measure based on historical data using various methods, such as linear, exponential, or seasonal. The Period value specifies how many future values you want to forecast. For example, you can add a forecast to your line chart and set the Period value to 90 to see the projected revenue for the next 90 days. References: [Oracle Analytics Cloud - Data Visualization User’s Guide], [Oracle Analytics Cloud - Data Visualization User’s Guide]

You can grant ownership of items you create to other users and catalog items can be set to read-only are two true statements about Presentation Catalog in Oracle Analytics Cloud. Presentation Catalog is a feature that allows you to store, organize, and manage your analytics content and resources, such as data sets, projects, data flows, data models, and more. You can grant ownership of items you create to other users by changing the owner property of the items in the catalog. This allows you to transfer the full control and responsibility of the items to another user. You can also set catalog items to read-only by changing the permissions of the items in the catalog. This prevents other users from modifying or deleting the items, but allows them to view or copy them. The other statements, such as My Folders can be shared with other users and storage of objects of different types must be segregated into their own folders, are not true about Presentation Catalog in Oracle Analytics Cloud. My Folders is a personal folder that is visible only to you and cannot be shared with other users. You can store objects of different types in the same folder in the catalog, as long as they have unique names. References: [Oracle Help Center], [Oracle Help Center]

OBIEE 11.1.X and later is the version of OBIEE that is supported for migration to OAC. OBIEE stands for Oracle Business Intelligence Enterprise Edition, which is a comprehensive business intelligence platform that provides a range of analytics capabilities, such as interactive dashboards, ad hoc queries, enterprise reporting, and more. OAC stands for Oracle Analytics Cloud, which is a cloud-based analytics platform that provides similar features as OBIEE, as well as additional features such as data visualization, augmented analytics, machine learning, and more. You can migrate content from OBIEE to OAC using the Oracle BI Migration Tool, which is a command-line utility that allows you to export and import metadata and catalog objects between OBIEE and OAC. The Oracle BI Migration Tool supports migration from OBIEE 11.1.X and later versions to OAC, as these versions are compatible with OAC in terms of data model structure, catalog format, and security model. The other versions of OBIEE, such as OBIEE 12c, OBIEE 12g and later, and OBIEE 10g, are not supported for migration to OAC, as they are either not compatible with OAC or not available. References: Oracle Help Center, Oracle Help Center, Oracle Help Center

Dashboard prompts are filters that allow users to dynamically change the data displayed in a dashboard. Some statements that are true about dashboard prompts are:

• Prompt values can be limited based on values selected in other prompts. This is called cascading prompts, where the values of one prompt depend on the selection of another prompt.
• Repository variables and session variables can be used in prompt default values. This allows users to set dynamic default values for prompts based on variables defined in the repository or the session. References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

To enable a different set of report links at the page level and set different report links for different analyses, you need to do the following steps:

• Enable all the Dashboard Report links from Dashboard Properties. This will allow you to use report links such as drill down, drill up, drill across, or navigate to other dashboards or web pages.
• Set the Report links for each Reach report. This will allow you to customize which report links are available for each analysis on each dashboard page. References: Oracle Analytics Cloud - Data Visualization User’s Guide, Oracle Analytics Cloud - Data Visualization User’s Guide

The correct use of BI Ask is that it is used to enable user input in natural language. It extracts column names from the user input and quickly builds visuals for the columns extracted. BI Ask is a feature that allows you to create analyses using natural language queries instead of dragging and dropping columns from the subject area pane. You can type or speak your query in BI Ask and it will automatically generate the best visualization for your query based on the columns extracted from your input. References: [Oracle Analytics Cloud - Data Visualization User’s Guide], [Oracle Analytics Cloud - Data Visualization User’s Guide]