47
●
Dashboard—Upon opening an Interactive Reporting document file, a customized
Dashboard section can appear as the Interactive Reporting document file front-end. Each
button selection, item selection, or navigation sequence can invoke a script. Behind the
scenes, Interactive Reporting refreshes the Dashboard script commands that can perform
actions such as retrieve data, populate controls, hide objects, navigate to different sections,
and specify report parameters
●
Report—Displays high-quality and professionally designed reports. These reports can span
anywhere from a complex critical operational report to a results set, a Chart, and a Pivot
table. Use the reports to help you evaluate your business, expand communications, and assist
in the decision-making process
●
Query—Foundation of the Interactive Reporting document, the Query section enables you
to connect to a relational database and download a prebuilt query or data model.
●
Results—Retrieves data to your document and displays it in the Results sections as columns
in a table
●
Pivot—Interactive table that quickly summarizes, or cross-tabulates, large amounts of data.
You can rotate its rows and columns to see different summaries of the source data, or display
the details for areas of interes.
●
Chart—Fully interactive, two- or three-dimensional view of your data that provides
powerful ways to visually analyze your data
●
Table—Single-dimension report that displays your data in columns. Tables are often used
as building blocks in other sections
●
OLAPQuery—Query section specifically designed for connecting to multidimensional
databases
●
CubeQuery—Query section exclusively designed for connecting to and querying Essbase
9.x or greater database
By default, an Interactive Reporting document file has at least one Query section and one Results
section. Each section occupies an independent window and performs distinct operations.
You can move back and forth between sections at any time to rebuild your query or alter your
result data.
Selecting Interactive Reporting Document File Sections
Sections associated with the Interactive Reporting document file are shown in the Sections pane.
➤
To select a section, click the desired section from the Sections pane.
➤
To scroll up and down through a section, use the scroll bar on the right side of the browser.
Adding Sections
A new section is added based on an existing query and results set.
Working with Interactive Reporting Document File Sections s 207