The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11: Quickly master this extremely robust and powerful Hyperion business intelligence tool

Edward Cody

$54.99

5 (5 Ratings)

Paperback Sep 2010 232 pages 1st Edition

Edward Cody

$54.99

5 (5 Ratings)

Paperback Sep 2010 232 pages 1st Edition

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

View table of contents

Preview Book

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

Chapter 2. The Query

The Query section is a gateway to Interactive Reporting for building a query and retrieving data from a database. The Query provides the business analyst with an ad-hoc interface to model and analyze data, allowing the analyst to create, modify, and run scenarios on key business metrics. The Query section supplies the data for all of the other presentation sections of the document, and the Query section can easily be modified and reprocessed as desired. The goal of this chapter is to provide the business analyst with the tools necessary to effectively build and manage queries from a data model.

This chapter covers:

An overview of the Query section layout
Building a query
Creating request items
Creating filters
Sorting
Query processing
Query options
Identifying metadata (table and column remarks)

The following two chapters address features of the query including building data models and advanced querying and filtering techniques.

Note

The examples in this section are based on the...

Building a query

A query is built by adding and configuring items in the Request, Filter, and Sort areas of the section. Interactive Reporting provides a significant amount of flexibility for building queries, including the ability to add custom logic into the query. Once the query is configured, the query can be processed and modified as desired.

Request items

The columns of data returned from a query are configured by adding items to the Request line. Items from the model are added to the Request line by the following two methods:

Right-click method	Drag-and-drop method
Highlight the column(s) in the table of interest.	Highlight the column(s) in the table of interest.
Right-click and select Add Selected Items.	Drag-and-drop the columns into the Request line.

Note

The Ctrl and Shift keys can be used to highlight multiple columns, and right-clicking on the entire table object and selecting Add Selected Items will add all of the items in the table into the Request line.

The following...

Filters

Filters provide the ability to return a subset of data in the model by a field or combination of fields from the data model. Interactive Reporting provides a very robust filtering capability, where complex filters can be added to queries through an easy-to-use interface.

A filter is easily added to the query by adding the item to the Filter line. Items are added to the filter line by using one of the following two methods:

Right-click method	Drag-and-drop method
Highlight the column in the table of interest.	Highlight the column in the table of interest.
Right-click and select Filter.	Drag-and-drop the column into the Filter line.

Since the filter must be configured after it is added, only one column can be added to the Filter line at a time. Once the column has been added to the Filter line, the Filter interface appears to configure the filter values for the column.

Filter interface

The Filter interface provides significant flexibility for building complex filter conditions...

Key benefits

Get to grips with the most important, frequently used, and advanced features of Oracle Hyperion Interactive Reporting 11
A step-by-step Oracle Hyperion training guide packed with screenshots and clear explanations
Explore the features of Hyperion dashboards, reports, pivots, and charts
Learn how to build advanced data models and queries, and how to import external data set into your analysis

Description

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.

Who is this book for?

This book is for all Oracle Hyperion Interactive reporting users from novice to advanced. If you find yourself struggling while using this tool or you are new to the tool, this book will guide you through and make the learning process incremental.

What you will learn

Navigate the Workspace with examples for importing and provisioning Interactive Reporting documents
Learn to build data models and queries, and import external data
Gain in-depth understanding of leveraging user-defined SQL in the product
Learn to analyze data in the Result, Table, and Pivot sections
Explore the different chart types and methods for adding chart content
Build report sections including data from multiple queries and different charts and pivots
Create interactive dashboards and configure interactive components

Estimated delivery fee Deliver to Ecuador

Standard delivery 10 - 13 business days

$19.95

Premium delivery 3 - 6 business days

$40.95

(Includes tracking information)

What do you get with Print?

Instant access to your digital eBook copy whilst your Print order is Shipped

Paperback book shipped to your preferred address

Download this book in EPUB and PDF formats

Access this title in our online reader with advanced features

DRM FREE - Read whenever, wherever and however you want

Frequently bought together

Oracle Hyperion Interactive Reporting 11 Expert Guide

$60.99

$54.99

Total $ 115.98

FAQs

What is the delivery time and cost of print book?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

Economy: Can deliver to P. O. Boxes and private residences.
Trackable service with delivery to addresses in Australia only.
Delivery time ranges from 7-9 business days for VIC and 8-10 business days for Interstate metro
Delivery time is up to 15 business days for remote areas of WA, NT & QLD.

Premium: Delivery to addresses in Australia only
Trackable delivery to most P. O. Boxes and private residences in Australia within 4-5 days based on the distance to a destination following dispatch.

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Disclaimer:
All orders received before 5 PM U.K time would start printing from the next business day. So the estimated delivery times start from the next day as well. Orders received after 5 PM U.K time (in our internal systems) on a business day or anytime on the weekend will begin printing the second to next business day. For example, an order placed at 11 AM today will begin printing tomorrow, whereas an order placed at 9 PM tonight will begin printing the day after tomorrow.

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

What is custom duty/charge?

Customs duty are charges levied on goods when they cross international borders. It is a tax that is imposed on imported goods. These duties are charged by special authorities and bodies created by local governments and are meant to protect local industries, economies, and businesses.

Do I have to pay customs charges for the print book order?

The orders shipped to the countries that are listed under EU27 will not bear custom charges. They are paid by Packt as part of the order.

List of EU27 countries: www.gov.uk/eu-eea:

A custom duty or localized taxes may be applicable on the shipment and would be charged by the recipient country outside of the EU27 which should be paid by the customer and these duties are not included in the shipping charges been charged on the order.

How do I know my custom duty charges?

The amount of duty payable varies greatly depending on the imported goods, the country of origin and several other factors like the total invoice amount or dimensions like weight, and other such criteria applicable in your country.

For example:

If you live in Mexico, and the declared value of your ordered items is over $ 50, for you to receive a package, you will have to pay additional import tax of 19% which will be $ 9.50 to the courier service.
Whereas if you live in Turkey, and the declared value of your ordered items is over € 22, for you to receive a package, you will have to pay additional import tax of 18% which will be € 3.96 to the courier service.

How can I cancel my order?

Cancellation Policy for Published Printed Books:

You can cancel any order within 1 hour of placing the order. Simply contact customercare@packt.com with your order details or payment transaction id. If your order has already started the shipment process, we will do our best to stop it. However, if it is already on the way to you then when you receive it, you can contact us at customercare@packt.com using the returns and refund process.

Please understand that Packt Publishing cannot provide refunds or cancel any order except for the cases described in our Return Policy (i.e. Packt Publishing agrees to replace your printed book because it arrives damaged or material defect in book), Packt Publishing will not accept returns.

What is your returns and refunds policy?

Return Policy:

We want you to be happy with your purchase from Packtpub.com. We will not hassle you with returning print books to us. If the print book you receive from us is incorrect, damaged, doesn't work or is unacceptably late, please contact Customer Relations Team on customercare@packt.com with the order number and issue details as explained below:

If you ordered (eBook, Video or Print Book) incorrectly or accidentally, please contact Customer Relations Team on customercare@packt.com within one hour of placing the order and we will replace/refund you the item cost.
Sadly, if your eBook or Video file is faulty or a fault occurs during the eBook or Video being made available to you, i.e. during download then you should contact Customer Relations Team within 14 days of purchase on customercare@packt.com who will be able to resolve this issue for you.
You will have a choice of replacement or refund of the problem items.(damaged, defective or incorrect)
Once Customer Care Team confirms that you will be refunded, you should receive the refund within 10 to 12 working days.
If you are only requesting a refund of one book from a multiple order, then we will refund you the appropriate single item.
Where the items were shipped under a free shipping offer, there will be no shipping costs to refund.

On the off chance your printed book arrives damaged, with book material defect, contact our Customer Relation Team on customercare@packt.com within 14 days of receipt of the book with appropriate evidence of damage and we will work with you to secure a replacement copy, if necessary. Please note that each printed book you order from us is individually made by Packt's professional book-printing partner which is on a print-on-demand basis.

What tax is charged?

Currently, no tax is charged on the purchase of any print book (subject to change based on the laws and regulations). A localized VAT fee is charged only to our European and UK customers on eBooks, Video and subscriptions that they buy. GST is charged to Indian customers for eBooks and video purchases.

What payment methods can I use?

You can pay with the following card types:

Visa Debit
Visa Credit
MasterCard
PayPal

What is the delivery time and cost of print books?

Shipping Details

USA:

Economy: Delivery to most addresses in the US within 10-15 business days

Premium: Trackable Delivery to most addresses in the US within 3-8 business days

UK:

Economy: Delivery to most addresses in the U.K. within 7-9 business days.
Shipments are not trackable

Premium: Trackable delivery to most addresses in the U.K. within 3-4 business days!
Add one extra business day for deliveries to Northern Ireland and Scottish Highlands and islands

EU:

Premium: Trackable delivery to most EU destinations within 4-9 business days.

Australia:

India:

Premium: Delivery to most Indian addresses within 5-6 business days

Rest of the World:

Premium: Countries in the American continent: Trackable delivery to most countries within 4-7 business days

Asia:

Premium: Delivery to most Asian addresses within 5-9 business days

Unfortunately, due to several restrictions, we are unable to ship to the following countries:

Afghanistan
American Samoa
Belarus
Brunei Darussalam
Central African Republic
The Democratic Republic of Congo
Eritrea
Guinea-bissau
Iran
Lebanon
Libiya Arab Jamahriya
Somalia
Sudan
Russian Federation
Syrian Arab Republic
Ukraine
Venezuela

J Avenue May 20, 2011

Being a Hyperion consultant with 6 years of report development experience, I found that this is a great, informative book for beginners and advanced users alike. It is easy to understand for those who are new to Hyperion Interactive Reporting. For those who are more experienced, there are still new features that the author talks about in the book that they can find very helpful. He gives detailed explanation behind every object and function in the tool. The book includes a lot of examples and pictures to guide the readers along, making it very easy to understand and follow. (H.B.)

Amazon Verified review

Ahmed Oct 05, 2019

Fast shipping, item is just as described, high quality and great communication

Backbutton Nov 24, 2012

Bought this to learn up on the subject, and not finished yet. Well written and clear; much better than some of the titles out there.

Xavier Nov 15, 2010

I am a software trainer for Hyperion and I can honestly say that this book is a great resource. If you interact a lot with the Hyperion Interactive Reporting tool because of a job function that you perform and you have questions on how to use the software more efficiently, this book is definitely worth a look.The book also explains some other powerful features which even if you are a regular user of Hyperion, you might be unaware of. Let's see what else? The book also has a number of walkthroughs that you can use to follow along with the author to help you understand what it is you are doing and reading.Last but not least, the book avoids using a lot of techno-jargon babble in its many chapters. You honestly don't need to have taken a number of database classes at a university to understand what it is the author is talking about.So in closing, if you need a handy resource that can help you with the Hyperion Interactive Reporting tool, this book is very useful and you will probably learn something new to help you with your use of the tool.

John C McAllister Sep 01, 2012

This book explains in clear language how to operate and get the most out of Oracle Hyperion. Having recently taken on a project with no prior knowledge of the product I have found this book invaluable

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11: Quickly master this extremely robust and powerful Hyperion business intelligence tool

What do you get with Print?

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

Chapter 2. The Query

Note

The Query section layout

Sections window

Note

Working with pre-built data models

Building a query

Request items

Note

Filters

Filter interface

Sorting

Query processing

Note

Query options

Identifying metadata (table and column remarks)

Note

Summary

Page 1 of 10

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with Print?

Product Details

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the author

FAQs

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11: Quickly master this extremely robust and powerful Hyperion business intelligence tool

What do you get with Print?

Contact Details

Shipping Address

Billing Address

Key benefits

Description

Who is this book for?

What you will learn

Product Details

What do you get with Print?

Contact Details

Shipping Address

Billing Address

Product Details

Packt Subscriptions

Frequently bought together

Table of Contents

Recommendations for you

Customer reviews

People who bought this also bought

About the author

FAQs