LEADER 04922nam 2200625 a 450 001 9910785356703321 005 20200520144314.0 010 $a1-282-71253-5 010 $a9786612712531 010 $a1-84968-037-X 035 $a(CKB)2670000000055880 035 $a(EBL)944011 035 $a(OCoLC)796383618 035 $a(SSID)ssj0000467442 035 $a(PQKBManifestationID)11321860 035 $a(PQKBTitleCode)TC0000467442 035 $a(PQKBWorkID)10490066 035 $a(PQKB)10233440 035 $a(Au-PeEL)EBL944011 035 $a(CaPaEBR)ebr10428636 035 $a(CaONFJC)MIL588194 035 $a(CaSebORM)9781849680363 035 $a(MiAaPQ)EBC944011 035 $a(PPN)228010292 035 $a(EXLCZ)992670000000055880 100 $a20101119d2010 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 14$aThe business analyst's guide to Oracle Hyperion Interactive reporting 11$b[electronic resource] $equickly master this powerful business intelligence product /$fEdward J. Cody 205 $a1st edition 210 $aOlton, Birmingham [England] $cPackt Pub. Ltd.$d2010 215 $a1 online resource (232 p.) 300 $aDescription based upon print version of record. 311 $a1-84968-036-1 327 $aCover; 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 327 $aPassword 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 327 $aRemoving 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 327 $aLimitations 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 327 $aCustom 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 327 $aCreating totals 330 $aQuickly master the extremely robust and powerful Oracle Hyperion Interactive Reporting 11 tool with this book and eBook 606 $aInformation storage and retrieval systems 615 0$aInformation storage and retrieval systems. 676 $a005.74 700 $aCody$b Edward J$01516833 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910785356703321 996 $aThe business analyst's guide to Oracle Hyperion Interactive reporting 11$93753536 997 $aUNINA