About Limitations in ReportsThe limitations of reports are listed in the following sections. Custom Objects ReportingOracle CRM On Demand Answers provides comprehensive support for reporting custom objects. You can report on Custom Objects 1, 2, and 3 and their many-to-many relationship with accounts, contacts, opportunities, and service requests through specially dedicated subject areas. Use the Advanced Custom Objects subject area to report the relationship between Custom Objects 4-15 and other prebuilt objects including Custom Objects 1, 2, and 3. However, custom object reporting is currently supported only in real-time subject areas. It is not available in historical subject areas. Description Text LimitsThe Description text fields limit how much text can be printed in a report:
Maximum Number of RowsThe maximum number of records can appear as follows:
Time Limit for Query ExecutionOracle CRM On Demand Answers provides optimal performance for queries and reports while balancing the performance of Oracle CRM On Demand. To minimize the negative effect of long-running queries or run-away queries on the overall performance of Oracle CRM On Demand Answers, a time limit has been enabled for both real-time and historical reports. Queries that exceed the time limit generate a Timeout error message. For information about specific timeout limits that are applicable to your instance of Oracle CRM On Demand, contact Customer Care. For all instances, the maximum query time cannot exceed 10 minutes for Reporting (real-time) subject areas and 180 minutes for Analytics (historical) subject areas. For information on optimizing query execution time, see About Report Performance and Optimizing Performance. Multiselect PicklistsMultiselect picklist (MSP) values are not supported in real-time reporting subject areas. They are supported in the historical subject areas for the following subject areas:
Analytics displays a multiselect picklist field (up to 10 fields for each object) as a separate folder. Within these folders only the first 20 picklist values of the field and the concatenated MSP field value are available for reporting. Column Filter Prompt in Combined AnalysesColumn filter prompts provide general filtering of a column within a request. However, this column filter prompt is not available in combined analysis requests. Book VisibilityThe Book selector appears in the Reports and Dashboard pages and in reports embedded in record Homepages. You can use the Book selector to drill down into user books or custom books. If you have Full Visibility settings and are displaying an Analytic (historical) subject area, you can exclude subordinates or subbooks in the respective book hierarchy by clearing the Include Sub-Items check box. The Book selector is not available for report previews. You cannot exclude sub-items from reports made from Reporting (real-time) reporting subject areas. You can clear the Include Sub-Items check box, but it has no affect on Reporting subject areas, it only affects Analytic subject areas. NOTE: Several settings control your visibility to records in analytics. For more information, see About Visibility to Records in Analytics. Exchange RatesIf your company has more than one active currency, your company administrator must set up exchange rates for each currency. Changes made to exchange rates appear in reports after the nightly refresh of analytics data. A single exchange rate is determined for each month, and all transactions within the month use that rate. Some record types have multiple date fields. Only one date field is used to determine the month's exchange rate. For asset currency conversions, the Purchase Date field determines the month used. For an opportunity, the Opportunity Close Date that is closest to the Exchange Rate Effective Date is used. Localization SettingsIf you change your default language, the reporting elements display in the newly selected language. However, the data in reports or dashboards depends on your company's default language regardless of your chosen language. Date SupportOracle CRM On Demand Answers supports date analysis of metrics through the date dimension for 41 years (2000 to 2040) for companies using calendar-quarter or standard, fiscal-calendar models. For companies using custom fiscal calendar, Oracle CRM On Demand Answers can support date analysis of metrics only for the years defined in Oracle CRM On Demand. If a record is created outside this period, you can still display this record as long as it is not analyzed through the date dimension. Date dimensions are set up differently in analytic (historical) subject areas than in reporting (real-time) subject areas. In analytic subject areas there is only one date dimension (standard or canonical), and there might be one or multiple sets of metrics using different dates, so these metrics can be reported by any date within the desire range. In reporting subject areas, there are one or multiple date dimensions (role-playing) and only a single set of metrics, so these metrics can be analyzed using different date dimensions. For example, consider the Opportunity History analytic subject area, which contains one date dimension (Close Date) and two sets of metrics. The default set of metrics, Opportunity Metrics, is based on the Close Date, but there is also another set of metrics, Opportunity Metrics by Open Date, to allow analysis of opportunities by an open date. However, the Opportunities Reporting subject area contains two date dimensions: Date Opened and Close Date, and one set of metrics (Opportunity Metrics). The advantage of using the date dimension of the analytic subject area is that it allows analysis of various related metrics for the entire period using any date within the desire range in a single report. The following table summarizes the set up of the date dimensions between analytic and reporting subject areas.
Time SupportDates and times shown in reports are displayed in the company's time zone, so that everyone using the report can view consistent data. It is possible to display dates and times in the user's time zone (for Reporting subject areas only) if the company administrator has enabled the User Time Zone Support for Reporting Subject Areas field and if this field is selected in the user's profile. Changing this setting affects only reports that you display and does not affect reports that other users display. When sharing reports, the date and time information that you see might be different from the information that others see. User QuotasUser quotas are available for reporting in the following subject areas: Activities, Activity History, Opportunities, Opportunity History, Opportunity-Products, and Opportunity-Product History. You must be familiar with the following considerations when reporting user quotas:
Custom Objects 1, 2, and 3 AssociationsYou cannot report on the many-to-many associations between Custom Objects 1, 2, and 3 with the following objects in Oracle CRM On Demand Answers:
The many-to-many relationship is implemented only for Custom Objects 1, 2, and 3 and Account, Contact, Service Request, and Opportunity in Oracle CRM On Demand Answers. This many-to-many relationship is yet to be implemented between Custom Objects 1, 2, and 3 and Activities, Assets, Leads, and Products. However, customers can report on the one-to-many relationship between these objects and Custom Objects 1, 2, and 3, using the Advanced Custom Objects subject area. You can display elements from the Activities dimension if you include an Activity metric in the report. Currency Conversion LimitsIf a currency value is entered using a currency that is not the company's default currency, then Oracle CRM On Demand Answers converts that value to the company's default currency for use in reports. Large values that are acceptable for input in one currency may exceed value limits when converted to the company default currency. When this occurs, the report generation cannot be completed. |
Published 1/9/2017 | Copyright © 2005, 2017, Oracle. All rights reserved. Legal Notices. |