The business analyst's guide to Oracle Hyperion Interactive reporting 11 [[electronic resource] ] : quickly master this powerful business intelligence product / / Edward J. Cody
| The business analyst's guide to Oracle Hyperion Interactive reporting 11 [[electronic resource] ] : quickly master this powerful business intelligence product / / Edward J. Cody |
| Autore | Cody Edward J |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Olton, Birmingham [England], : Packt Pub. Ltd., 2010 |
| Descrizione fisica | 1 online resource (232 p.) |
| Disciplina | 005.74 |
| Soggetto topico | Information storage and retrieval systems |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-282-71253-5
9786612712531 1-84968-037-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910459242303321 |
Cody Edward J
|
||
| Olton, Birmingham [England], : Packt Pub. Ltd., 2010 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
The business analyst's guide to Oracle Hyperion Interactive reporting 11 [[electronic resource] ] : quickly master this powerful business intelligence product / / Edward J. Cody
| The business analyst's guide to Oracle Hyperion Interactive reporting 11 [[electronic resource] ] : quickly master this powerful business intelligence product / / Edward J. Cody |
| Autore | Cody Edward J |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Olton, Birmingham [England], : Packt Pub. Ltd., 2010 |
| Descrizione fisica | 1 online resource (232 p.) |
| Disciplina | 005.74 |
| Soggetto topico | Information storage and retrieval systems |
| ISBN |
1-282-71253-5
9786612712531 1-84968-037-X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910785356703321 |
Cody Edward J
|
||
| Olton, Birmingham [England], : Packt Pub. Ltd., 2010 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
The business analyst's guide to Oracle Hyperion Interactive reporting 11 : quickly master this powerful business intelligence product / / Edward J. Cody
| The business analyst's guide to Oracle Hyperion Interactive reporting 11 : quickly master this powerful business intelligence product / / Edward J. Cody |
| Autore | Cody Edward J |
| Edizione | [First edition] |
| Pubbl/distr/stampa | Olton, Birmingham [England] : , : Packt Pub. Ltd., , 2010 |
| Descrizione fisica | 1 online resource (232 pages) |
| Disciplina | 005.74 |
| Soggetto topico | Information storage and retrieval systems |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9786612712531
9781282712539 1282712535 9781849680370 184968037X |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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 |
| Record Nr. | UNINA-9910964018603321 |
Cody Edward J
|
||
| Olton, Birmingham [England] : , : Packt Pub. Ltd., , 2010 | ||
| Lo trovi qui: Univ. Federico II | ||
| ||