Categories
Ebooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Computer in the office
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Multimedia trainings
- Real estate
- Persuasion and NLP
- Taxes
- Social policy
- Guides
- Presentations
- Leadership
- Public Relation
- Reports, analyses
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
E-press
- Architektura i wnętrza
- Biznes i Ekonomia
- Home and garden
- E-business
- Finances
- Personal finance
- Business
- Photography
- Computer science
- HR & Payroll
- Computers, Excel
- Accounts
- Culture and literature
- Scientific and academic
- Environmental protection
- Opinion-forming
- Education
- Taxes
- Travelling
- Psychology
- Religion
- Agriculture
- Book and press market
- Transport and Spedition
- Healthand beauty
-
History
-
Computer science
- Office applications
- Data bases
- Bioinformatics
- IT business
- CAD/CAM
- Digital Lifestyle
- DTP
- Electronics
- Digital photography
- Computer graphics
- Games
- Hacking
- Hardware
- IT w ekonomii
- Scientific software package
- School textbooks
- Computer basics
- Programming
- Mobile programming
- Internet servers
- Computer networks
- Start-up
- Operational systems
- Artificial intelligence
- Technology for children
- Webmastering
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Narrative poetry
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
School textbooks
-
Popular science and academic
- Archeology
- Bibliotekoznawstwo
- Cinema studies
- Philology
- Polish philology
- Philosophy
- Finanse i bankowość
- Geography
- Economy
- Trade. World economy
- History and archeology
- History of art and architecture
- Cultural studies
- Linguistics
- Literary studies
- Logistics
- Maths
- Medicine
- Humanities
- Pedagogy
- Educational aids
- Popular science
- Other
- Psychology
- Sociology
- Theatre studies
- Theology
- Economic theories and teachings
- Transport i spedycja
- Physical education
- Zarządzanie i marketing
-
Guides
-
Game guides
-
Professional and specialist guides
-
Law
- Health and Safety
- History
- Road Code. Driving license
- Law studies
- Healthcare
- General. Compendium of knowledge
- Academic textbooks
- Other
- Construction and local law
- Civil law
- Financial law
- Economic law
- Economic and trade law
- Criminal law
- Criminal law. Criminal offenses. Criminology
- International law
- International law
- Health care law
- Educational law
- Tax law
- Labor and social security law
- Public, constitutional and administrative law
- Family and Guardianship Code
- agricultural law
- Social law, labour law
- European Union law
- Industry
- Agricultural and environmental
- Dictionaries and encyclopedia
- Public procurement
- Management
-
Tourist guides and travel
- Africa
- Albums
- Southern America
- North and Central America
- Australia, New Zealand, Oceania
- Austria
- Asia
- Balkans
- Middle East
- Bulgary
- China
- Croatia
- The Czech Republic
- Denmark
- Egipt
- Estonia
- Europe
- France
- Mountains
- Greece
- Spain
- Holand
- Iceland
- Lithuania
- Latvia
- Mapy, Plany miast, Atlasy
- Mini travel guides
- Germany
- Norway
- Active travelling
- Poland
- Portugal
- Other
- Russia
- Romania
- Slovakia
- Slovenia
- Switzerland
- Sweden
- World
- Turkey
- Ukraine
- Hungary
- Great Britain
- Italy
-
Psychology
- Philosophy of life
- Kompetencje psychospołeczne
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Audiobooks
-
Business and economy
- Bitcoin
- Businesswoman
- Coaching
- Controlling
- E-business
- Economy
- Finances
- Stocks and investments
- Personal competence
- Communication and negotiation
- Small company
- Marketing
- Motivation
- Real estate
- Persuasion and NLP
- Taxes
- Guides
- Presentations
- Leadership
- Public Relation
- Secret
- Social Media
- Sales
- Start-up
- Your career
- Management
- Project management
- Human Resources
-
For children
-
For youth
-
Education
-
Encyclopedias, dictionaries
-
History
-
Computer science
-
Other
-
Foreign languages
-
Culture and art
-
School reading books
-
Literature
- Antology
- Ballade
- Biographies and autobiographies
- For adults
- Dramas
- Diaries, memoirs, letters
- Epic, epopee
- Essay
- Fantasy and science fiction
- Feuilletons
- Work of fiction
- Humour and satire
- Other
- Classical
- Crime fiction
- Non-fiction
- Fiction
- Mity i legendy
- Nobelists
- Novellas
- Moral
- Okultyzm i magia
- Short stories
- Memoirs
- Travelling
- Poetry
- Politics
- Popular science
- Novel
- Historical novel
- Prose
- Adventure
- Journalism, publicism
- Reportage novels
- Romans i literatura obyczajowa
- Sensational
- Thriller, Horror
- Interviews and memoirs
-
Natural sciences
-
Social sciences
-
Popular science and academic
-
Guides
-
Professional and specialist guides
-
Law
-
Tourist guides and travel
-
Psychology
- Philosophy of life
- Interpersonal communication
- Mindfulness
- General
- Persuasion and NLP
- Academic psychology
- Psychology of soul and mind
- Work psychology
- Relacje i związki
- Parenting and children psychology
- Problem solving
- Intellectual growth
- Secret
- Sexapeal
- Seduction
- Appearance and image
- Philosophy of life
-
Religion
-
Sport, fitness, diets
-
Technology and mechanics
Videocourses
-
Data bases
-
Big Data
-
Biznes, ekonomia i marketing
-
Cybersecurity
-
Data Science
-
DevOps
-
For children
-
Electronics
-
Graphics/Video/CAX
-
Games
-
Microsoft Office
-
Development tools
-
Programming
-
Personal growth
-
Computer networks
-
Operational systems
-
Software testing
-
Mobile devices
-
UX/UI
-
Web development
-
Management
Podcasts
E-book details
Log in, If you're interested in the contents of the item.
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11. Quickly master this extremely robust and powerful Hyperion business intelligence tool
Ebook
Oracle Hyperion Interactive Reporting is one of the many products in the Oracle Enterprise Performance Management software suite, an industry-leading business intelligence software package. The primary focus of the Interactive Reporting product is to provide strong relational querying and data analysis capabilities. It also provides the capability to disseminate information throughout an enterprise. There is a very steep learning curve for most users of this tool.This book examines the power of the Interactive Reporting Web Client software, focusing on the key features of each section of the product. The author's experience in developing and supporting Interactive Reporting users is very well documented in this book. The goal is to educate you on every useful feature of the product, enabling you to gather information from various sources and process it to produce meaningful results that help you to spot problems and analyze trends necessary for business decisions.The book starts with a quick introduction to the product interface and the EPM Workspace, with explanation of importing and provisioning. It then takes you through each section from building a query and data model to building graphical displays of the data in a logical sequence. The report sections and interactive dashboards are also discussed at length. The book also covers advanced features of the product and provides you with the information necessary to build the foundation for creating complex queries and computations using the product.
- The Business Analysts Guide to Oracle Hyperion Interactive Reporting 11
- Table of Contents
- The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
- Credits
- About the Author
- Acknowledgement
- About the Reviewer
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Permissions
- Multidimensional queries
- Additional resources
- Conventions
- Reader feedback
- Customer support
- Errata
- Piracy
- Questions
- 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 document
- Password protecting the design mode
- Offline mode
- Importing BQY documents into the EPM Workspace
- Editing Interactive Reporting file properties
- Summary
- 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 filters
- Sorting
- Query processing
- Query options
- Identifying metadata (table and column remarks)
- Summary
- The Query section layout
- 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 queries
- Importing 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
- Creating a data model
- 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 SubQuery
- Custom SQL and custom join conditions
- Custom join conditions
- Combining queries
- The query log and exporting SQL
- Summary
- Structured Query Language (SQL)
- 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
- Data layout
- Filters
- Creating filters
- Filters on multiple sections
- Status Bar
- Filter performance
- Sorting
- Sorting performance
- Creating totals
- Grand totals
- Break totals
- Impact when adding filters
- Removing totals
- Grouping columns
- Computed items
- Computed item examples
- Concatenation
- String manipulation
- Conditional functions
- Date/time functions
- Numeric functions
- Date Groups
- Computed item examples
- Summary
- 6. Pivots
- Creating Pivot sections
- Pivot this Chart
- Pivots created using results or tables
- Removing Pivot sections
- Adding content
- Row and column labels
- Facts
- Data functions
- Removing content
- Arranging label content
- Managing label and data headings
- Data labels
- Corner labels
- Sorting
- Manual sorting
- Analyzing content
- Drill
- Drillup
- Focus and hide
- Focus
- Hide
- Hidden item
- Unhide
- Totals and computed items
- Totals
- Data functions for totals
- Removing totals
- Renaming items in row or column label
- Grouping
- Computed items
- True totals and surface values
- Totals
- Formatting and conditional formatting
- Conditional formatting
- Exporting and printing
- Summary
- Creating Pivot sections
- 7. Charts
- Creating Chart sections
- Charts created using results or tables
- Chart this pivot
- Removing Chart sections
- Adding content
- Removing content
- Chart types
- Vertical and horizontal bar charts
- Vertical and horizontal stack bar charts
- Vertical cluster bar chart
- Pie charts
- Area and stacked area charts
- Line charts
- Ribbon charts
- Bar-Line charts
- Scatter / Bubble charts
- Legend
- Data functions
- Analyzing content
- Drill
- Drillup
- Focus
- Hide
- Hidden Item
- Unhide
- Adding reference and trend lines
- Drill
- Sorting Chart labels
- Chart formatting and properties
- Chart properties
- Inserting text labels
- Grouping and computed items
- Grouping
- Computed items
- Exporting charts
- Summary
- Creating Chart sections
- 8. Reports
- Creating Report sections
- An overview of the Report layout
- Headers and Footers
- Report setup
- Design guides
- Adding content
- Elements window
- Query elements
- Graphics
- Fields
- Resources
- Adding pivots and charts
- Adding a table
- Adding graphics, fields, and resources
- Removing content
- Elements window
- Resource Manager
- Building Report tables
- Table window
- Table dimensions and facts
- Dimension and fact properties
- Break totals
- Sorting results
- Removing elements
- Report groups
- Adding report group content
- Sorting groups
- Focusing and hiding report group content
- Creating and modifying expressions
- Table expressions
- Predefined field expressions
- Report groups
- Custom fields
- Formatting expressions
- Combining data from multiple queries
- Adding computed items and modifying items
- Exporting and printing
- Summary
- 9. Dashboards
- Creating Dashboard sections
- Understanding the Dashboard layout
- Editing the dashboard
- Dashboard objects
- Query objects
- Reports
- Graphics
- Controls
- Gauges
- Live Charts
- Resources
- Building a dashboard
- Adding sections
- Adding graphics and resources
- Adding gauges, live charts, and controls
- Removing content
- Adding content example
- Configuring gauges
- Gauge properties and color ranges
- Configuring live charts
- Live chart properties
- Working with controls
- Control types
- Script Editor
- Building an interactive dashboard
- Populating Drop Downs with a script
- Setting a filter from a Drop Down control
- Exporting and printing
- Summary
- Index
- Title: The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11. Quickly master this extremely robust and powerful Hyperion business intelligence tool
- Author: Edward J. Cody, Edward Cody
- Original title: The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11. Quickly master this extremely robust and powerful Hyperion business intelligence tool
- ISBN: 9781849680370, 9781849680370
- Date of issue: 2010-09-13
- Format: Ebook
- Item ID: e_3bed
- Publisher: Packt Publishing