FAQs to Explore and Report
This topic provides answers to frequently asked questions about exploring and reporting data.
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. When users leave the organization, administrators can delete their unused datasets to free up storage space for others.
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 |
|
Maximum number of sections in a simple trellis | 10 | Simple Trellis | None |
Maximum number of visible columns in a pivot table | 300 | Pivot Table |
|
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:
|
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?
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 number of column values that display when I use a parameter as a filter?
The maximum number of column values that display when you use a parameter as a filter is 10,000.
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?
- 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.