The business analyst's guide to Oracle Hyperion Interactive reporting 11 : quickly master this powerful business intelligence product / / Edward J. Cody

• Record Nr.: UNINA9910964018603321
• Autore: Cody Edward J
• Pubbl/distr/stampa: Olton, Birmingham [England] : , : Packt Pub. Ltd., , 2010
• ISBN: 9786612712531; 9781282712539; 1282712535; 9781849680370; 184968037X
• Edizione: [First edition]
• Descrizione fisica: 1 online resource (232 pages)
• Disciplina: 005.74
• Soggetti: Information storage and retrieval systems; Electronic books.
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Description based upon print version of record.
• Nota di contenuto: Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewer; Table of Contents; Preface; Chapter 1: Oracle Hyperion Interactive Reporting; The Interactive Reporting document: The BQY; The EPM Workspace; Navigating the EPM Workspace; Installing the Interactive Reporting Web Client; Opening documents in the Workspace; Opening documents from the local machine; The Web Client interface; The Section Catalogue; Menus; Toolbars; Section Title Bar; Status Bar; Saving documents; Saving documents to the Workspace; Saving documents to the local machine; Save options; Password protecting the documentPassword protecting the design mode; Offline mode; Importing BQY documents into the EPM Workspace; Editing Interactive Reporting file properties; Summary; Chapter 2: The Query; The Query section layout; Sections window; Section Title Bar; Status Bar; Working with pre-built data models; Building a query; Request items; Removing request items; Filters; Filter interface; Show Values; Custom Values; Manual entry; Transfer values; Loading filters from a file (importing); Modifying the AND and OR ; operators; Variable filters; Filtering on request items; Removing filtersSorting; Query processing; Query options; Identifying metadata (table and column remarks); Summary; Chapter 3: The Data Model; Creating a data model; Duplicating a query; Removing a query; Building a data model; The Elements window; Adding tables to the data model; Joins; The Topic View; Working with meta topics; Creating meta topics; Promoting to a meta topic; Editing meta topics; Changing the data model topic view; Updating the data model; Changing the table definition; Combining multiple queries in one model; Local results; Limitations of local results; Derivable queries; Limitations of derivable queriesImporting external data; Importing a file; Refreshing external data; Importing tips; Fixing additional columns; Fixing datatype and join issues; Importing custom SQL files; Refreshing imported SQL; Summary; Chapter 4: Advanced Querying and Filtering; Structured Query Language (SQL); How SQL is translated from Request, Filter, and Sort; Advanced request items; Modifying column definitions; Concatenation; String manipulation; Value replacement; Date/time functions; Nesting functions; Datatypes; Advanced filtering; Custom SQL filter option; SubQuery option; Custom SQL SubQueryCustom SQL and custom join conditions; Custom join conditions; Combining queries; The query log and exporting SQL; Summary; Chapter 5: Results and Tables; Results section; The Tables sections; Creating a table section; Duplicating a table; Removing Table sections; Removing Results sections; Adding and modifying content; Data layout; Auto-populating table columns; Moving columns; Hiding/showing columns; Identifying computed items; Removing columns; Filters; Creating filters; Filters on multiple sections; Status Bar; Filter performance; Sorting; Sorting performance; Creating totals
• Sommario/riassunto: Quickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBook