FAQs to Explore and Report

This topic provides answers to frequently asked questions about exploring and reporting data.

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 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.

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.