Index

A

• adaptave state controls, interactice reporting documents
  • inherit property / Importing BQY documents into the EPM Workspace
  • view only property / Importing BQY documents into the EPM Workspace
  • view and process property / Importing BQY documents into the EPM Workspace
  • analyze property / Importing BQY documents into the EPM Workspace
  • analyze and process property / Importing BQY documents into the EPM Workspace
  • query and analyze property / Importing BQY documents into the EPM Workspace
  • datamodel and analyze property / Importing BQY documents into the EPM Workspace
• Add_Months function
  • about / Date/time functions
• advanced filtering
  • about / Advanced filtering
  • Custom SQL filter option / Custom SQL filter option

C

• chart
  • sections, creating / Creating Chart sections
  • chart this pivot / Chart this pivot
  • section, removing / Removing Chart sections
  • formatting / Chart formatting and properties
  • properties / Chart properties
• chart, types
  • about / Chart types
  • vertical bar chart / Vertical and horizontal bar charts
  • horizontal bar chart / Vertical and horizontal bar charts
  • vertical bar-stacked chart / Vertical and horizontal bar charts
  • horizontal bar-stacked chart / Vertical and horizontal bar charts
  • vertical stack bar chart / Vertical and horizontal stack bar charts
  • vertical cluster bar chart / Vertical cluster bar chart
  • pie charts / Pie charts
  • area charts / Area and stacked area charts
  • stacked area charts / Area and stacked area charts
  • line charts / Line charts
  • ribbon charts / Ribbon charts
  • bar-line charts / Bar-Line charts
  • scatter charts / Scatter / Bubble charts
• column definitions
  • modifying / Modifying column definitions
  • value replacement / Value replacement
• computed items
  • about / Computed items
  • examples / Computed item examples
• computed items, chart
  • about / Computed items
• computed items, Pivots
  • true totals / True totals and surface values
• concatenation
  • about / Concatenation, Concatenation
• conditional functions
  • about / Conditional functions
• Contains option / Filter interface
• content
  • adding / Adding and modifying content
• content, chart
  • adding / Adding content
  • removing / Removing content
  • analyzing / Analyzing content
  • Drill / Drill
  • trend lines, adding / Adding reference and trend lines
• content, Pivots
  • data, drilling into / Drill
• controls, dashboard
  • types / Control types
  • command button / Control types
  • radio button / Control types
  • list box / Control types
  • drop down / Control types
  • text box / Control types
  • slider / Control types
  • embedded browser / Control types
  • hyperlink / Control types
  • script editor / Script Editor
• custom join conditions
  • about / Custom join conditions
• custom SQL
  • processing / Custom SQL and custom join conditions
• custom SQL files
  • importing / Importing custom SQL files
  • imported SQL, refreshing / Refreshing imported SQL
• custom SQL filter option
  • about / Custom SQL filter option
• custom SQL SubQuery
  • about / Custom SQL SubQuery
• custom values, adding
  • manually / Manual entry
  • by transferring method / Transfer values
  • filters, loading from file (importing) / Loading filters from a file (importing)

D

• dashboard
  • sections, creating / Creating Dashboard sections
  • layout / Understanding the Dashboard layout
  • editing / Editing the dashboard
  • controls / Working with controls
  • printing / Exporting and printing
• dashboard, building
  • about / Building a dashboard
  • sections, adding / Adding sections
  • content, removing / Removing content
  • content example, adding / Adding content example
• dashboard objects
  • about / Dashboard objects
  • query objects / Query objects
  • reports / Reports
  • graphics / Graphics
  • controls / Controls
  • gauges / Gauges
  • live charts / Live Charts
  • resources / Resources
• data
  • items, modifying / Adding computed items and modifying items
• data functions, chart
  • about / Data functions
• data layout
  • about / Data layout
  • computed items, identifying / Identifying computed items
  • columns, removing / Removing columns
• data model
  • New Query item / Creating a data model
  • Insert Query menu / Creating a data model
  • building / Building a data model
  • tables, adding / Adding tables to the data model
  • updating / Updating the data model
• datatypes
  • about / Datatypes
• date/time functions
  • about / Date/time functions, Date/time functions
• decode function
  • about / Value replacement
• design guides, report
  • design guidelines / Design guides
  • grid / Design guides
  • rulers / Design guides
  • page margins / Design guides
• documents
  • saving / Saving documents
• documents, saving
  • save options / Save options
  • password, protecting the document / Password protecting the document
  • password, protecting the design mode / Password protecting the design mode
  • offline mode / Offline mode
• Drillup, chart
  • about / Drillup
  • focus / Focus

E

• Elements window
  • about / The Elements window
• elements window, report
  • about / Elements window
  • query elements / Query elements
  • graphics / Graphics
  • fields / Fields
  • resources / Resources
• Ends With option / Filter interface
• EPM Workspace
  • documents, saving to / Saving documents to the Workspace
  • BQY documents, importing / Importing BQY documents into the EPM Workspace
• exporting, chart
  • about / Exporting charts
• expressions
  • table expressions / Table expressions
• external data
  • importing / Importing external data
  • file, importing / Importing a file
  • refreshing / Refreshing external data

F

• file, importing tips
  • about / Importing tips
  • additional columns, fixing / Fixing additional columns
  • join issues, fixing / Fixing datatype and join issues
• filters
  • about / Filters
  • items, adding / Filters
  • filter interface / Filter interface
  • show values option / Show Values
  • custom values / Custom Values
  • OR operators, modifying / Modifying the AND and OR operators
  • removing / Removing filters
  • on multiple sections / Filters on multiple sections

G

• gauges, dashboard
  • configuring / Configuring gauges
  • properties / Gauge properties and color ranges
• grouping, chart
  • about / Grouping

H

• hide, chart
  • about / Hide
  • hidden item / Hidden Item
  • unhide / Unhide
• hide functionality, Pivots
  • hidden item / Hidden item
  • unhide / Unhide
• Hyperion Dashboard Studio Optimize Utility / Creating a table section

I

• ignore button / Filter interface
• interactice reporting
  • permissions interface / Importing BQY documents into the EPM Workspace
  • Adaptive State / Importing BQY documents into the EPM Workspace
• interactive dashboard, building
  • about / Building an interactive dashboard
  • drop downs, populating with script / Populating Drop Downs with a script
  • filter, setting from drop down control / Setting a filter from a Drop Down control
• interactive reporting
  • file properties, editing / Editing Interactive Reporting file properties
• interface, filter
  • = Equal option / Filter interface
  • <> Not Equal option / Filter interface
  • < Less Than option / Filter interface
  • <= Less Than or Equal option / Filter interface
  • > Greater Than option / Filter interface
  • >= Greater Than or Equal option / Filter interface
  • Begins With option / Filter interface
  • Like option / Filter interface
  • Between option / Filter interface
  • Is Null option / Filter interface
  • Include Nulls checkbox / Filter interface
  • filter name box / Filter interface
  • advanced button / Filter interface
• intersection operator
  • about / Combining queries
• items, report
  • modifying / Adding computed items and modifying items

L

• labels, chart
  • sorting / Sorting Chart labels
• Last_Day function
  • about / Date/time functions
• left join
  • about / Joins
• legend, chart
  • about / Legend
• live charts, dashboard
  • adding / Adding gauges, live charts, and controls
  • configuring / Configuring live charts
  • properties / Live chart properties
• local machine
  • documents, saving to / Saving documents to the local machine
• local results
  • about / Local results
  • limitations / Limitations of local results
  • derivable queries / Derivable queries
  • derivable queries, limitations / Limitations of derivable queries

M

• menus, web client interface
  • file menu / Menus
  • edit menu / Menus
  • view menu / Menus
  • insert menu / Menus
  • format menu / Menus
  • tools menu / Menus
  • help menu / Menus
• meta topics
  • about / Working with meta topics
  • creating / Creating meta topics
  • promoting to / Promoting to a meta topic
  • editing / Editing meta topics
  • data model topic view, changing / Changing the data model topic view
• minus operator
  • about / Combining queries
• multiple queries
  • combining, in one model / Combining multiple queries in one model
  • data, combining from / Combining data from multiple queries

N

• nesting functions
  • about / Nesting functions
• Not checkbox / Filter interface
• numeric functions
  • about / Numeric functions
• NVL function
  • about / Value replacement

O

• OCE files / Importing BQY documents into the EPM Workspace

P

• permissions interface, interactice reporting documents
  • inherit selection / Importing BQY documents into the EPM Workspace
  • no access prevents / Importing BQY documents into the EPM Workspace
  • view selection / Importing BQY documents into the EPM Workspace
  • modify selection / Importing BQY documents into the EPM Workspace
  • full control selection / Importing BQY documents into the EPM Workspace
• Pivots
  • section, creating / Creating Pivot sections
  • Pivot this Chart menu option / Pivot this Chart
  • sections, removing / Removing Pivot sections
  • content, adding / Adding content
  • row labels / Row and column labels
  • facts / Facts
  • data functions / Data functions
  • content, removing / Removing content
  • label content, arranging / Arranging label content
  • label heading, managing / Managing label and data headings
  • data labels / Data labels
  • corner labels / Corner labels
  • content, analyzing / Analyzing content
  • data, drilling into / Drill
  • Drillup / Drillup
  • focus functionality / Focus
  • hide functionality / Hide
  • computed items / Computed items
  • formatting / Formatting and conditional formatting
  • conditional formatting / Conditional formatting
  • exporting / Exporting and printing
  • printing / Exporting and printing
• pre-built data models
  • working with / Working with pre-built data models
• predefined field expressions
  • about / Predefined field expressions
  • report groups / Report groups
  • custom fields / Custom fields
  • expressions, formatting / Formatting expressions
• processing options, query
  • process all option / Query processing
  • process current property / Query processing
  • process custom property / Query processing
• process property
  • return unique rows option / Query options
  • return first property / Query options
  • time limit property / Query options

Q

• queries, combining
  • processing / Combining queries
• query
  • building / Building a query
  • processing / Query processing
  • processing, options / Query processing
  • options, in query section / Query options
  • process property / Query options
  • duplicating / Duplicating a query
  • removing / Removing a query
• query, building
  • requests items / Request items
• query log
  • about / The query log and exporting SQL

R

• report
  • sections, creating / Creating Report sections
  • layout / An overview of the Report layout
  • content, adding / Adding content
  • pivots, adding / Adding pivots and charts
  • content, removing / Removing content
  • expressions / Creating and modifying expressions
  • printing / Exporting and printing
• report groups
  • about / Report groups
  • content, adding / Adding report group content
  • groups, sorting / Sorting groups
  • content, hiding / Focusing and hiding report group content
• report layout
  • headers / Headers and Footers
  • report setup / Report setup
  • design guides / Design guides
• report tables, building
  • about / Building Report tables
  • fact columns / Dimension and fact properties
  • break totals / Break totals
  • sorting results / Sorting results
  • elements, removing / Removing elements
• request items
  • about / Advanced request items
• requests items
  • example / Request items
  • removing / Removing request items
  • filtering on / Filtering on request items
• resource manager
  • about / Resource Manager
• resources
  • adding, to report / Adding graphics, fields, and resources
• resources, dashboard
  • adding / Adding graphics and resources
• result section
  • removing / Removing Results sections
  • status bar / Status Bar
• results section
  • about / Results section
• right join
  • about / Joins

S

• sections, dashboard
  • adding / Adding sections
• simple join
  • about / Joins
• sorting
  • in query section / Sorting
  • about / Sorting
• sorting, Pivots
  • about / Sorting
  • manual sorting / Manual sorting
• status bar, query section layout / Status Bar
• string manipulation
  • about / String manipulation, String manipulation
• Structured Query Language (SQL)
  • about / Structured Query Language (SQL)
  • translation, from sort / How SQL is translated from Request, Filter, and Sort
  • exporting / The query log and exporting SQL
• SubQuery option
  • about / SubQuery option
• substring function
  • about / String manipulation

T

• table
  • adding, to report / Adding a table
• table definition
  • changing / Changing the table definition
• table facts, report tables
  • about / Table dimensions and facts
• table remarks
  • identifying / Identifying metadata (table and column remarks)
• tables
  • using, for creating Pivots / Pivots created using results or tables
  • used, for creating chart / Charts created using results or tables
• tables, adding to data model
  • about / Adding tables to the data model
  • joins / Joins
• table section
  • about / The Tables sections
  • creating / Creating a table section
  • table, duplicating / Duplicating a table
  • removing / Removing Table sections
  • auto-populating / Auto-populating table columns
  • columns, moving / Moving columns
  • columns, showing / Hiding/showing columns
  • columns, removing / Removing columns
  • filters / Filters
  • filters, creating / Creating filters
  • filters, performance / Filter performance
  • data, sorting / Sorting
  • sorting, performance / Sorting performance
  • grouping columns / Grouping columns
• table window, report tables
  • about / Table window
• text labels, chart
  • inserting / Inserting text labels
• toolbars, web client interface
  • standard toolbar / Toolbars
  • formatting toolbar / Toolbars
  • section toolbar / Toolbars
• topic view
  • about / The Topic View
• total items, Pivots
  • about / Totals
  • items in row, renaming / Renaming items in row or column label
  • grouping / Grouping
• totals
  • creating / Creating totals
  • grand totals / Grand totals
  • break totals / Break totals
  • removing / Removing totals, Removing totals
  • data functions / Data functions for totals
• totals items, Pivots
  • about / Totals and computed items
• To_Char function
  • about / Date/time functions
• To_Date function
  • about / Date/time functions
• Trim function
  • about / String manipulation

U

• union all operator
  • about / Combining queries
• union operator
  • about / Combining queries
• upper function
  • about / String manipulation

V

• variable filters
  • about / Variable filters

W

• web client interface
  • section catalogue / The Section Catalogue
  • menus / Menus
  • toolbars / Toolbars
  • section title bar / Section Title Bar
  • status bar / Status Bar