FAQs to Explore and Report

What’s my dataset storage limit?

Oracle Analytics Cloud has a fixed 250 GB storage quota for data files that's shared across all users. The limit for an individual user is 50GB. Oracle recommends that you delete unused datasets to free up storage space. Contact your administrator if your requirements exceed these limits.

What are the view display limits for analyses and dashboards?

Analysis and Dashboard Limits	Limit	View Type	Alternative Options
Maximum number of view prompt values	10,000	All view types that support view (page edge) prompts	None
Maximum number of rows displayed	40,000	Narrate, Ticker	None
Maximum number of sections	300	All view types that support sections except Simple Trellis	Place fewer columns on the section edge of the analysis view. Move one or more of the columns on the section edge to the row or page edge. Reduce the number of data values in the section edge of the analysis view by applying dashboard or analysis filters to the columns on the section edge.
Maximum number of sections in a simple trellis	10	Simple Trellis	None
Maximum number of visible columns in a pivot table	300	Pivot Table	Place fewer columns on the column's edge of the pivot table view. Move one or more of the columns on the column's edge to the rows, page, or sections edge. Reduce the number of data values in the column's edge by applying dashboard or analysis filters to the columns on the column's edge.
Maximum number of visible rows per page in a pivot table	5,000	Pivot Table	Use the Data Viewing option of Fixed headers with scrolling content instead of Content Paging.
Maximum number of visible rows per page in a table view	5,000	Table	Use the Data Viewing option of Fixed headers with scrolling content instead of Content Paging.

What are the display limits for prompts?

Prompt Limits	Limit	More Information
Maximum number of choice values	1000	Applies to: Choice lists, check boxes, list boxes, and radio buttons in prompts. List of values displayed in the Select Values dialog when you select the Search option in a prompt values list.
Maximum number of default values	1000	Applies to dashboard prompts.

What's the maximum number of rows allowed in a query or download?

See Limits Querying, Displaying, and Exporting Data in Plan Your Service.

What are the limits for email delivery?

The compute size of your Oracle Analytics Cloud deployment determines the maximum number of rows you can deliver in a single email. The row limit also depends on whether the report you’re delivering is formatted or unformatted. See Limits Delivering by Email (Classic Analyses and Dashboards) in Plan Your Service.

Note:

Content delivery by email is an expensive operation and has a direct impact on the overall system performance. The impact on system performance increases with the number of recipients, the number of rows and columns that you send, and the delivery format. Oracle recommends that you schedule deliveries during non-peak hours or change the delivery format to reduce any performance impact.

What's the maximum size map layer file that I can upload?

The maximum file size that you can upload is 25MB.

When I want to save an object, where does the default location come from?

You can save any object in any location. However, the Save In field in the Save dialog sometimes recommends the best location based on the object type that you’re saving. For example, you should save filters, groups, and calculated items within a subject area folder so that these items are available when you build an analysis for the same subject area. If a subject area folder doesn’t exist in your /My Folders or within /Shared Folders, then a subject area folder is created automatically. The Save In field defaults a save path to /My Folders/Subject Area Contents/<subject area>; however, the dialog's Folders area displays all instances of the subject area folder in the catalog.

You can save other objects such as analyses and prompts in any folder. Bear in mind the distinctions between shared and personal folders, when deciding whether to share the object that you’re saving with others.

Can I enable other users to access my analyses, dashboards, and workbooks?

Yes. To enable other users to access your analyses, dashboards, and workbooks, move or save the analysis, dashboard, or workbook to a shared folder and then give other users the required access permissions. See Assign Access Permissions and Assign Shared Catalog Folder and Workbook Permissions.

Can I make analyses and dashboards interact with prompts and other analyses?

Yes, analyses and dashboards interact with prompts. See Advanced Techniques: How Dashboard Prompts and Analysis Prompts Interact. You can link views such that one view drives changes in one or more other views. See Linking Views in Master-Detail Relationships.

I have interacted with a dashboard drilling and applying filters. How do I save the state of my dashboard and share the dashboard with others?

You can save and get back the settings that you make on a dashboard. See Save and Restore Dashboard State. You can share dashboard pages with other users by sharing links to those pages. See Link to Dashboard Pages.

How do I remove the Diagnose link displayed on my analyses and dashboards?

In Classic view, sign in as a user with the BI Service Administrator role and set the value of the configuration setting Diagnose BI Server Query to Denied. You can find this setting under Administration\ Security - Manage Privileges\Admin: General.

Tip: You can access the Administration page by clicking the user My Profile icon, then Administration.

Can I migrate analyses between different environments?

Yes. You can migrate analyses between service environments by copying and pasting the XML code for the analyses using the Advanced tab of the analysis editor. See Advanced Techniques: Examining the Logical SQL Statements for Analyses.

Can I delete data files uploaded by a deleted user from my Cloud service?

Yes. Reinstate the deleted user, then delete the dataset files.

Can BI users access reporting dashboards and reports in Smart View?

Yes. See Smart View and Oracle Analytics Cloud.

Can I change default logo and dashboard style?

Yes. On the Dashboard Properties page, choose a predefined theme that includes a custom logo from the Style list. Administrators create these themes and make them available to dashboard builders.

Can I use initialization blocks in Oracle Analytics Cloud?

You can use initialization blocks to set session variables but you can’t use them to set users, roles, or groups. When you sign-in to Oracle Analytics Cloud, the identity management system that your Oracle Analytics Cloud uses automatically populates values for the USER and ROLE (GROUP) session variables.

Why don't I see images from background maps when I print pages or when I export images in formats such as PDF, PPT, and PNG?

You or a visualization builder might have added an image to a background map by referencing that image with a URL. For the image to print or be exported in various formats, the external website hosting that image must have the Access-Control-Allow-Origin header from the host server. If a map background includes an image reference that's taken from an external website that doesn't have this header, you won't see the image.

For more information about this header, see https://www.w3.org/wiki/CORS_Enabled

Why do some users have read permissions that I didn't assign?

If you save or move a report, dashboard, or workbook containing an artifact (for example, a dataset) to a shared folder, and when prompted you share the related artifacts, then Oracle Analytics assigns the artifacts read permissions for the users who can access the report, dashboard, or workbook in the shared folder.

Without the read permission, users won't be able to access the correct content when they open the report, dashboard, or workbook.

Why does a workbook that I've shared with other users display as a dashboard, and why isn't the Visualize page available to the users?

How the workbook is displayed when the user opens it depends on the user's permissions and how the workbook was set up.

If the shared workbook contains a presentation flow and the user has read-only permissions to the workbook, then the workbook's dashboard is displayed only and the user can't access the workbook in the Visualize page. The presentation flow's dashboard and canvas preferences determine how the dashboard displays and the functionality it contains.
If the shared workbook is displayed in presentation mode, then the workbook's presentation flow dashboard and canvas preferences determine how the user can interact with the presentation flow or dashboard. See Open the Presentation Flow.
If the workbook doesn't contain a presentation flow and the user has read-only permission, then the workbook is displayed in the Visualize page. The user can change filter values, add filters, export, sort, and drill in the Visualize page.