Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11

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

Arrow left icon
Product type Paperback
Published in Sep 2010
Publisher Packt
ISBN-13 9781849680363
Length 232 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Edward Cody Edward Cody
Author Profile Icon Edward Cody
Edward Cody
Arrow right icon
View More author details
Toc

Table of Contents (16) Chapters Close

The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11
Credits
About the Author
1. Acknowledgement
About the Reviewer
2. Preface
1. Oracle Hyperion Interactive Reporting FREE CHAPTER 2. The Query 3. The Data Model 4. Advanced Querying and Filtering 5. Results and Tables 6. Pivots 7. Charts 8. Reports 9. Dashboards Index

Building Report tables


A Report table is similar in appearance and behavior to a Results or Table section. Fields are added to the table by highlighting the table of interest in the report and then dragging elements from the desired Results or Table section of the Elements window to the Table Dimensions or Table Facts area in the Table window.

Table window

The Table window is displayed similar to the Data Layout window of other section and appears at the bottom-right portion of the main window. An example of the table window is shown in the following screenshot:

If the Table window is not initially shown, the window can be accessed by clicking on the Table icon in the Section Title Bar.

Table dimensions and facts

Similar to the behavior of a pivot table, the Table Dimensions are the non-fact elements that are displayed to the left of the table and the Table Facts are the numeric columns that are displayed on the right-hand side of the table. The Table facts are summarized by a Data Function...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime
Banner background image