05314nam 2200757 a 450 991096401860332120240514190953.09786612712531978128271253912827125359781849680370184968037X(CKB)2670000000055880(EBL)944011(OCoLC)796383618(SSID)ssj0000467442(PQKBManifestationID)11321860(PQKBTitleCode)TC0000467442(PQKBWorkID)10490066(PQKB)10233440(Au-PeEL)EBL944011(CaPaEBR)ebr10428636(CaONFJC)MIL588194(PPN)228010292(OCoLC)741364933(OCoLC)ocn741364933(FR-PaCSA)88851877(CaSebORM)9781849680363(MiAaPQ)EBC944011(OCoLC)ocn741364933 (FRCYB88851877)88851877(DE-B1597)721996(DE-B1597)9781849680370(EXLCZ)99267000000005588020101119d2010 uy 0engur|n|---|||||txtrdacontentcrdamediacrrdacarrierThe business analyst's guide to Oracle Hyperion Interactive reporting 11 quickly master this powerful business intelligence product /Edward J. CodyFirst editionOlton, Birmingham [England] :Packt Pub. Ltd.,2010.1 online resource (232 pages)Description based upon print version of record.9781849680363 1849680361 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 optionsPassword 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 itemsRemoving 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 queriesLimitations 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 optionCustom 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 performanceCreating totalsQuickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBookInformation storage and retrieval systemsElectronic books.lcgftInformation storage and retrieval systems.005.74Cody Edward J1797545MiAaPQMiAaPQMiAaPQBOOK9910964018603321The business analyst's guide to Oracle Hyperion Interactive reporting 114339914UNINA