- Cover13; -- Contents -- Acknowledgments -- Introduction -- 1 Getting Started with Combined Analyses -- About Oracle CRM On Demand -- Access Control for Report Developers -- Company Profile Setting Affecting Reports and Dashboards -- User Profile Settings Affecting Reports -- Introduction to Combined Analyses -- What Is a Combined Analysis? -- When Do I Need a Combined Analysis? -- Need to Combine Subject Areas -- Need to Combine Similar Columns on a Single Record -- Negative (Null) Reporting -- Federated Reporting -- Advanced Combine with Similar Analysis Function -- Set Operators -- Union Set Operator -- The Importance of Planning -- Filtering Combined Analyses -- 2 Combined Analysis Basics -- Basic Combined Analyses -- Criteria Reports -- Result Columns -- Report Views -- Pivot Tables -- Filter Prompts -- Classifications of Combined Analyses -- Unified Reporting -- Federated Reporting -- 3 Negative (Null) Reporting -- Determining When Negative Reporting Is Required -- Combining Criteria to Expose Missing Data -- Negative Reporting Step by Step -- Simple Negative Report Summary -- Complex Negative Report -- Negative Reporting Summary -- 4 Layout Considerations -- Layout Challenges with Combined Analyses -- Using Pivot Tables in Combined Analyses -- Charting in Combined Analyses -- Other Views -- 5 Result Columns -- Adding Result Columns -- Formatting Data in Combined Analyses -- Style Tab -- Column Format -- Data Format -- Conditional Format -- Sorting Columns -- Writing Result Column Formulas -- Aggregation Functions -- 6 Filtering Combined Analyses -- Column Filters -- Filter Groups -- Other Column Filter Methods -- Column Filter Prompts -- Dashboard Filter Prompts -- Filter Prompt Basics -- Building the Combined Analysis Dashboard -- Index -- A -- B -- C -- D -- E -- F -- G -- H -- I -- J -- L -- M -- N -- O -- P -- Q -- R -- S -- T -- U -- V.
- "From Oracle Press--a detailed, step-by-step guide to using combined analyses to develop reports within Oracle CRM On DemandWritten by a renowned expert on the topic, Oracle CRM On Demand Combined Analyses provides a detailed and methodical explanation of how and when to use combined analyses within Oracle CRM On Demand. Combined analyses provide a mechanism by which outer joins between tables can be created virtually. This is unique to the CRM On Demand environment, and this book explains the process in detail. This Oracle Press guide describes the mechanics of creating a combined analysis, while highlighting real-world business cases where a combined analysis is critical to developing an accurate and meaningful report. These case studies for different types of report unions provide a framework for tested and proven usage of the set operators in developing combined reports. Oracle CRM On Demand Combined Analyses is written by recognized Oracle CRM On Demand expert who has developed training courses for Oracle Covers a largely undocumented topic area Features real-world case studies throughout includes coverage of: Combined Analyses Basics; Negative (Null) Reporting; Layout Considerations; Result Columns; Filtering Combined Analyses"--
"Drive better decision-making across your enterprise using the reporting and analysis techniques in this Oracle Press guide. Through clear explanations and detailed case studies, Oracle CRM On Demand Combined Analyses shows you how to deliver real-time insightful business intelligence to end users. Learn how to perform multiple queries, join tables, format result columns, and add interactivity to your reports. Methods for filtering the results of a combined analysis are also covered in this practical resource"--
View MARC record | catkey: 37422266