Create Pixel Perfect Reports using Analytics Cloud LVC

• Introduction
• Objectives 2
• Overview of Oracle Analytics Publisher 3
• Pixel Perfect Reporting 4
• Pixel-Perfect Reporting 5
• Oracle Analytics Publisher Global Header 8
• Logging In to Oracle Analytics Cloud 9
• Oracle Analytics Publisher Home Page 10
• Oracle Analytics Publisher Global Header 11
• Global Header: Open and New 12
• Browse and View Catalog Objects 13
• Browsing the Catalog 14
• Oracle Analytics Publisher Repository Object Types 15
• Viewing Reports 17
• Creating a New Folder 18
• Manage Catalog Objects 19
• Managing Catalog Objects 20
• Adding to Favorites 22
• Managing Favorites 23
• Create and View Simple Reports 24
• Creating Reports: Overview 25
• Launching the Report Wizard from the Home Page 26
• Additional Methods for Launching the Report Wizard 27
• Step 1: Select Data 28
• Step 1: Options—Use Data Model 29
• Step 1: Options—Upload Spreadsheet 30
• Step 1: Options—Use Subject Area 31
• Using the Guide Me Workflow 32
• Step 2: Select Layout 33
• Steps 3 and 4: Create Chart 34
• Step 5: Create Pivot Table 35
• Step 5: Create Table 36
• Step 6: Save Report 37
• Step 6: View Report 38
• Editing Report Layouts 39
• Configure Layouts, Properties and Report Parameters 40
• Configuring Layouts and Reporting Properties 41
• Configuring Layouts 42
• Layout Toolbar 43
• Setting Report Properties 44
• Report Properties: General Tab 45
• Report Properties: Caching 47
• Report Properties: Formatting 48
• Report Properties: Font Mapping and Currency 49
• Configuring Report Parameters in the Report Editor 50
• Summary 51
• Data Model Editor
• Objectives 2
• Data Model Editor Features 3
• Data Model Editor 4
• Data Model Properties 6
• Supported Data Sources 8
• Private Data Source 11
• Private Data Sources 12
• Creating a Private Data Source 13
• Create and Edit a Data Model base on SQL 15
• Creating a Data Model Based on a SQL Query Data Set 16
• Step 1: Define Default Data Sources and Output Options 17
• Step 2: Add a SQL Query Data Set 18
• Step 3: Build a Query in Query Builder 19
• Step 3: Query Builder—Select Objects 20
• Step 3: Query Builder—Define Relationships 21
• Step 3: Query Builder—Select Columns 22
• Step 3: Query Builder—Add Aliases and Conditions 23
• Step 3: Query Builder—View Results 25
• Step 3: Query Builder—Save the Query 26
• Step 4: Save the Data Model 27
• Step 5: View Output and Save Sample Data 28
• Step 5: Save Sample Data and Export 29
• Creating a Report from Data Model Editor 30
• Parameters and List Of Values 31
• Adding Parameters 32
• Adding LOVs: SQL Query Type 33
• Adding LOVs: Changing SQL and Viewing Parameter 34
• Verifying LOV in a Report 35
• Date Parameter Example 36
• Bind Variables 37
• Configuring Parameter Setting for a Report 38
• Viewing a Report and Editing Parameter 40
• Verifying Parameter Changes 42
• Adding LOVs: Fixed Type 43
• Cascading Parameters 44
• Summary 45
• Working with the Layout Editor
• Objectives 2
• Describe the Layout Editor 3
• Layout Editor 4
• Opening the Layout Editor: Method 1 5
• Opening the Layout Editor: Method 2 6
• Opening the Layout Editor: Method 3 7
• Edit Report Versus Edit Layout 8
• Report Editor 9
• Use the Layout Editor to Build Reports 10
• Select a Predefined Template 11
• Layout Editor Interface 12
• Navigating the Layout Editor Interface 13
• Properties and Context-Sensitive Toolbar 14
• Properties and Context-Sensitive Menus 15
• Grids, Data Tables, Formatting, Grouping, Subtotals and Sorts 16
• Creating a Layout with a Basic Template 17
• Inserting a Layout Grid 19
• Working with Data Tables 21
• Inserting a Data Table 22
• Adding Data Fields 23
• Table Tab and Dynamic Table Menus 24
• Formatting Data in a Table 25
• Number and Date Formats 26
• Defining Groups and Subtotals 27
• Defining Sorts 28
• Applying Conditional Formats 30
• Managing Conditional Formats 32
• Defining a Table Filter 33
• Filter Definition 34
• Working with Charts 35
• Inserting a Chart 36
• Adding Data Fields to a Chart 37
• Editing Charts 38
• Editing Chart: Additional Tasks 39
• Working with Repeating Sections 42
• Repeating Section Results 43
• Text Items and Images 44
• Working with Lists 45
• Working with Gauges 46
• Pivot Table 47
• Other Features 48
• Page Layout Features 49
• Formatted Report 50
• Saving a Layout 51
• Summary 52
• Template Builder
• Objectives 2
• Template Builder 4
• Installing Template Builder 5
• Template Builder Interface 6
• Oracle Analytics Publisher Menu: Online 7
• Publisher Menus: Online 8
• Publisher Menus: Insert 9
• Publisher Menus: Preview and Tools 11
• Publisher Menus: Options 13
• Relationship Between RTF and XML 16
• Creating an RTF Template Using Sample XML Data 18
• Step 1: Create an RTF Template from a Sample Layout 19
• Step 2: Load the Sample Data 20
• Step 3: Insert Fields 21
• Step 4: Preview the Data 22
• Step 5: Insert a Table 23
• Step 6: View the Results 26
• Changing Field Properties 27
• Previewing the Data 28
• Publisher Charts 30
• Adding a Chart to an RTF Template 31
• Step 1: Use Template Builder to Insert a Chart 32
• Step 2: Define the Chart 34
• Step 3: Preview the Chart 35
• Pivot Table Support in Template Builder 36
• Pivot Table Results 37
• Designing an RTF Template in Online Mode 39
• Step 1: Log On to Oracle Analytics Publisher 40
• Step 2: Open the Oracle Analytics Publisher Report 41
• Step 3a: Define the RTF Template—Add a Table 42
• Step 3b: Define the RTF Template—Add a Chart 45
• Step 4: Preview the Data 46
• Step 5: Upload the Template and View the Layout 47
• Creating a New Report Using Template Builder 49
• Methods of Creating RTF Templates 51
• Exploring the Basic Method 52
• Exploring the Form Field Method 53
• Form Field Example: Inserting a Table 54
• Form Field Example: Populating the Table 55
• Form Field Example: Completed Template 56
• Advanced RTF Template Techniques 59
• Grouping in the Table Wizard 60
• Sorting in the Table Wizard 61
• Running Totals in the Table Wizard 62
• Page and Section Breaks in the Table Wizard 63
• Adding Page Numbers 64
• Formatting Dates 65
• Formatting Numbers 66
• Conditional Formats 67
• Conditional Formats Results 68
• Creating a Conditional Region 69
• Supported MS Word Native Formatting Features 70
• Page-Level Calculations 71
• Adding Page-Level Calculations 72
• Brought-Forward and Carried-Forward Totals 74
• Brought-Forward and Carried-Forward Totals Results 75
• Backgrounds and Watermarks 76
• Drawings and Shapes 77
• Excel Templates 79
• Excel Template Builder 80
• Sample Excel Template 81
• Summary 82
• Scheduling and Bursting
• Objectives 2
• Schedule Oracle Analytics Publisher Reports 4
• Schedule Report Job: Overview 5
• General Options Tab 6
• Output Options Tab 7
• Schedule Options Tab 8
• Notification Options Tab 9
• Diagnostic Tab 10
• Submit the Job and Review the Confirmation Details 11
• Manage Report Jobs 13
• Edit a Report Job 14
• Edit a Report Job (cont) 15
• Report Job History: Overview 17
• Report Job History: Overview (cont) 18
• Report Job History: Details 19
• Download and Republish 20
• Send the Output to a New Destination 21
• Schedule a Report with Triggers: Overview 23
• Set a Schedule Trigger 24
• Review the Data Model That Contains the Trigger 25
• Create a Job That Uses a Trigger 26
• Choose the Trigger and Submit the Job 27
• Verify in Job History 28
• Bursting a Report 30
• Bursting Key Concepts 31
• Add a Bursting Definition 32
• Enable a Report to Use a Bursting Definition 34
• Schedule a Bursting Job 35
• View the Results After Bursting 36
• Summary 37
• Create Data Models and Reports Based on Other Data Sources
• Objectives 2
• Supported Data Sources 3
• HTTP (XML Feed) Data Source 5
• Create an Oracle Analytics Publisher Report Based on HTTP (XML Feed) 6
• Step 1: Define an HTTP Data Set 7
• Step 2: View the Data 8
• Step 3: Create a Report 9
• Create an Oracle Analytics Publisher Report Based on an XML File 11
• Step 1: Define an XML File as a Data Set 12
• Step 2: View the Data 13
• Step 3: Create a Report 14
• Create an Oracle Analytics Publisher Report Based on | a CSV File 16
• Step 1: Define a CSV Data Set 17
• Step 2: View the Data 18
• Step 3: Create a Report 19
• Create an Oracle Analytics Publisher Report Based on an Excel Spreadsheet 21
• Step 1: Define an Excel Spreadsheet as a Data Set 22
• Step 2: View the Data 23
• Step 3: Create a Report 24
• Create an Oracle Analytics Publisher Report Based on an Oracle Analytics Cloud
• Analysis 26
• Step 1: Define an Oracle Analytics Cloud Analysis Data Set 27
• Step 2: View the Data 28
• Step 3: Create a Report 29
• Create an Oracle Analytics Publisher Report Based on an DV Data 31
• Step 1: Define an DV Data Data Set 32
• Step 2: View the Data 33
• Step 3: Create a Report 34
• Summary 35
• Translations
• Objectives 2
• Translation Types 3
• Translate Using a Localized Template 5
• Use the Localized Template Option: Process Overview 6
• Step 1: Design the Localized Template 7
• Step 2: Upload the Localized File to Template Manager 8
• Localized Template Results 9
• Translate Using XLIFF 12
• Structure of an XLIFF File 13
• XLIFF File Attributes 14
• XLIFF File Embedded Data Fields 15
• Use the XLIFF Option: Process Overview 16
• Step 1: Generate the XLIFF file Using Template Builder 17
• Step 1: Generate the XLIFF file from Layout Properties 18
• Step 2: Translate the Strings 19
• Step 3: Preview the Strings 20
• Step 4: Upload the Translation 22
• Results for XLIFF File 23
• Manage Translations 25
• Overall Translation Process 26
• Catalog Translations 27
• Export the XLIFF File for a Catalog Folder 28
• View the Exported File 29
• Import the File for a Catalog Folder 30
• User Preferences 31
• Summary 32
• Integrating Oracle Analytics Publisher with Oracle Analytics Cloud
• Objectives 2
• Logging In to Oracle Analytics Cloud 4
• Oracle Analytics Cloud Home Page 5
• Navigating Oracle Analytics Cloud: Classic Home 6
• Oracle Analytics Cloud Classic Home Page 7
• Creating Objects from the Global Header 8
• Configuring a JDBC Connection 9
• Creating a Data Model Based on a SQL Query Data Set 12
• Step 1: Adding a SQL Query Data Set 13
• Step 2: Query Builder – Define Relationships and Select the Columns 14
• Step 2: Query Builder – View Results 15
• Step 2: Query Builder – Save the Query 16
• Step 3: Save the Data Model 17
• Step 4: View Output and Save Sample Data 18
• Step 5: Create a Report from Data Model Editor 19
• Step 5: Select a Layout 20
• Step 5 : Create Graph Layout 21
• Step 5 : Create Table Layout 22
• Step 5 : Save Report 23
• Step 6: View Your Report 24

Adding an Oracle Analytics Publisher Report to an Oracle Analytics Cloud Dashboard 26

• Step 1: Edit Your Dashboard 27
• Step 2: Add a Column and Section to Your Dashboard 28

Step 2: Add an Oracle Analytics Publisher Report to Your Dashboard and Run the Dashboard 29

• Step 3: View Your Dashboard Results 30
• Summary 31
• Security
• Objectives 2
• Secure Reporting with Oracle Analytics Publisher 4
• Business Challenge 5
• Solution 6
• Virtual Private Database 7
• Virtual Private Database (VPD) 8
• How Does VPD Work? 9
• Implement Row-Level Security with Oracle Analytics Publisher 11
• Apply the VPD Policy 12
• Verify the VPD Policy 13
• Update the Publisher Data Source 14
• Test the BIP Report – Employee Salary Report for SMITH 15
• Test the BIP Report – Employee Salary Report for CLARK 16
• Summary 17