Contents
- Infor BI Application Studio
- Program start and user interface
- Starting Application Studio
- Options of the Log On dialog box
- Connecting to the sample database
- Starting the program from the command line
- Repository registrations
- Adding projects and report catalogs to a repository
- Editing, removing, and managing permissions of projects and report catalogs
- Keyboard shortcuts
- Displaying panes
- Cut, copy and paste in panes
- Enabling menus and toolbars
- Application look
- Accessing data
- Database structure
- Database aliases
- Lists
- Creating lists
- Displaying named sets
- Server List Designer
- Client lists
- Relational lists
- Variable lists
- Custom lists
- DataLink lists
- Formula lists
- Pick lists
- Variables
- Managing variables
- Manage values for users
- Manage values for variables
- Clearing values
- Variables in the report wizard
- Persistency and values
- Creating report variables
- Creating global variables
- Example - controlling dependent lists with variables
- XML variables
- Using variables in SQL queries
- Input and output variables
- Calculations
- Manage unavailable lists and calculations
- Accessories
- Custom hierarchies
- Creating custom hierarchies
- OLAP Server metadata hierarchy
- Attributes of custom hierarchies
- Editing custom hierarchies
- Deleting custom hierarchies
- Exporting custom hierarchies
- Examples of custom hierarchies in use
- Creating ascending or descending sorts in a report
- Navigating between reports
- Changing the format of numbers in a report
- Navigating between reports from a list containing multiple links to the same reports
- Navigating from multiple menu items to a single report
- Selecting different views within a report using the OLAP metadata hierarchy
- Creating slice dimensions with the Olap Metadata hierarchy
- Custom hierarchies
- Creating and managing reports
- Report Catalog
- Creating reports, report templates, and style sheets
- Deleting reports
- Copying and moving reports and folders
- Creating folders
- Creating a Point of View (POV)
- Managing permissions
- Report links
- Report snapshots
- Design Mode, Debug Mode, and View Mode
- Checking reports in and out
- Version history
- Defining reports
- Defining reports
- Report Objects
- List objects
- Lookup objects
- Hyperblocks
- Creating hyperblocks
- The Create Hyperblock Wizard
- Creating multiple output cells
- Using variables to specify the output format
- Editing hyperblock properties
- Editing hyperblock output properties
- Key output cell
- Column width
- Overlapping hyperblocks
- Nesting hyperblocks
- Using MOD and ROW to format hyperblocks
- Using OFFSET to reference hyperblocks
- Command buttons
- POVs
- Inserting Text objects
- Inserting images
- Inserting web extensions
- Formatting and positioning objects
- Formatting list objects
- Formatting web extensions
- Formatting text and shape objects
- Formatting graphic objects
- Returning an image to its original size
- Formatting command buttons
- Formatting charts
- Properties tab
- Availability tab
- Size and Position tab
- Format tab
- Format tab of line and arrow objects
- Slices
- Charts, Sparklines and Map Charts
- Actions
- Action types
- Action modes
- Conditions
- Specifying command texts, command images, and separators in action menus
- Specifying parameter settings
- Specifying jump inputs
- Copying actions
- Examples of actions
- Using actions to jump to other reports
- Making jumps conditional
- Using actions to restructure a list
- Setting a variable and writing back a value with the Edited Cell action
- Resizing a report object with the Recalculate Report action
- Open dialog and Close dialog actions
- Dynamic delivery to a single e-mail recipient
- Dynamic delivery to multiple e-mail recipients
- Drillback in Infor Ming.le
- Creating a Q&A Query action
- Using actions with web extensions
- Formulas
- Specifying formulas
- ADDRESS
- ADDSLICEAXISATTRIBUTES
- ADDSLICEAXISATTRIBUTESA
- ADDSLICEAXISATTRIBUTESORT
- ADDSLICEAXISLIMIT
- ADDSLICEAXISRANKING
- ADDSLICEAXISVALUESORT
- ARRAY
- ARRAYINDEXOF
- ARRAYINSERT
- ARRAYLENGTH
- ARRAYREMOVE
- ARRAYTONUMBERS
- ARRAYTOSTRING
- ARRAYSWAP
- ATTACHMENTS
- ATTACHMENTINFO
- CELLGET
- CELLPROPERTYGET
- CELLWRITE
- CELLPROPERTYWRITE
- CLIENTTIMESHIFT
- CREATESLICEAXIS
- CREATESLICEDEFINITION
- CREATESLICELIST
- CREATESLICELISTS
- CREATESLICELISTSEGMENT
- CREATESLICETUPLESEGMENTS
- CROSSLINK
- DBEXECUTE
- EXTRACTPROPERTIES
- EXTRACTPROPERTIESBYFILTER
- FILTER
- FINDKEYS
- FINDKEYSA
- FINDKEYSBYFILTER
- FINDKEYSBYFILTERA
- GETARRAYITEM
- GETCOLOR
- GETCOLORRANGE
- GETDATALINKDRILLBACKQUERY
- GETENVIRONMENTINFO
- GETKEY
- GETKEYS
- GETKEYSA
- GETKEYVALUES
- GETKEYVALUESA
- GETLEVEL
- GETNAME
- GETOLAPNAME
- GETPROPERTIES
- GETPROPERTIESA
- GETPROPERTY
- GETPROPERTYVALUES
- GETPROPERTYVALUESA
- GETSESSIONID
- GETTICKET
- GROWTHX and GROWTHY
- HLOOKUP
- HTML
- HYPERBLOCK
- HYPERLINK
- KEYGET
- INITSLICERS
- ISMULTISELECT
- LINESTB, LINESTM, LINESTR
- LOGESTB, LOGESTM, LOGESTR
- MEMBERCNAME
- MEMBERGET
- MEMBERNAME
- MERGEPROPERTIES
- MULTISELECTADD
- MULTISELECTCHANGEAGGREGATION
- MULTISELECTCREATE
- MULTISELECTGETMEMBERS
- MULTISELECTGETMEMBERSSIMPLE
- MULTISELECTREMOVE
- NOTEGET
- NOTEWRITE
- RDB
- REFRESHOLAPMETADATA
- ROA
- ROAC
- ROC
- ROK
- RON
- RUNPROCESS
- RWA
- RWC
- RWDB
- RWN
- SERVERTIMESHIFT
- SETPROPERTY
- SLICEGET
- SLICEWRITE
- SPLITELEMENTNAMES
- STYLENUMBERFORMAT
- SUMIF2
- TRANSLATESTRING
- TRANSLATEUNIQUESTRING
- VLOOKUP
- VALIDATESLICERS
- WBA
- WBC
- Multiselect
- Styles and style sheets
- Report parameters
- Report Size
- Formatting columns and rows
- Inserting headers and footers
- Designing for dashboards
- Designing for Dashboards
- Resizing reports
- Report parameters and dashboards
- Detecting the environment in which a report runs
- Using combo boxes as filters
- Using XML variables with filter dimensions
- Tuple report parameter
- DataLink query report parameter
- Dashboard jumps
- Triggering actions from parameter changes
- Self-service templates
- Hiding reports from report viewers
- Report templates
- Formatting cells
- Formatting the report background
- Removing cell backgrounds
- Specifying conditional formatting
- Freeze areas and visible report areas
- Splits and Freeze Panes
- Colors
- Comments and cell notes
- Working with the spreadsheet
- Differences between full and web clients
- Writing back values
- Printing, exporting and scheduling reports
- Print and export overview
- Export formats
- Printing a single report
- Exporting a single report
- Exporting to a report file
- Exporting to xml
- Specifying the page setup
- Print Preview
- Inserting page breaks
- Report books
- Scheduled tasks
- Enabling dynamic report delivery
- Export, Application Component, and Print Wizards
- Export, application component and print wizards
- Printing the current report with the Print Wizard
- Printing a report book with the Print Wizard
- Exporting the current report with the Book Export Wizard
- Exporting a report book
- Exporting application components overview
- Exporting customized reports for a BI Services application
- Packaging reports for a BI Services application
- Importing reports
- Report properties
- Administration
- Installing Application Studio without user intervention
- Changing the title-bar text and the Info dialog text
- Converting a repository
- Specifying the language
- Settings
- User Management
- User Management
- Working with user management
- Creating and deleting basic groups
- Creating and deleting basic users
- Registering Windows users and groups
- Editing properties of users and groups
- Assigning users or groups on the Users and Groups tab
- Assigning users and groups on the Basic Groups tab
- Filtering the user and groups list
- User management roles
- Administering permissions and predefined roles, groups and users
- Registering authentication systems in Infor BI Repository Administration
- Managing report catalog permissions
- Managing project permissions
- Logging
- Scripting
- Advanced help
- Application Studio and CPM Applications integration
- Integrating Infor BI reports into the CPM Applications web portal
- Configuring CPM Applications for portal integration
- Integrating an Application Studio report into the web portal
- Configuring database access
- Log on parameters
- Report parameters
- Frameset parameters
- Session handling
- Title bar settings
- Report object values
- Multiple reports in Application Studio WebServices
- Unique names and captions
- Names and descriptions in CPM Applications database aliases
- Dynamic reports
- Combo boxes vs Select Element action
- Object properties
- Application Studio and CPM Applications integration
- Tutorial
- About this tutorial
- Logging on and creating reports
- Making reports dynamic
- Working with the list designer
- Using actions
- Localizing reports
- Creating writable reports
- Calculating values
- Using Period as a slicer
- Formatting
- Communication between reports
- Glossary
- .dat
- alias
- Application composer
- application key
- application
- application processes package
- application component
- attribute
- authentication
- base element
- Best Practices
- business intelligence
- cache
- caption
- cell graphic
- cell reference
- check in and check out
- client list
- combo box
- conditional formatting
- content developer
- cubes
- custom hierarchies
- custom list
- dashboard
- data area
- database independent reporting
- DataLink list
- design, view, and debug modes
- dimension
- drill-down
- dynamic report
- elements
- filter
- flag
- formatting
- formulas
- function
- global list
- hierarchy
- history
- hyperblock
- intrinsic attributes
- jumps
- key performance indicator (kpi)
- level
- list designer
- list object
- lists
- list view
- local lists
- MDX
- multidimensional databases
- multilingual string
- named sets
- null and zero values
- Olap
- OLAP Server
- OLAP metadata hierarchy
- permissions
- point of view (pov)
- project
- ragged hierarchy
- registration
- relational reporting
- relational list
- report catalog
- report templates
- report wizard
- repository
- sealed application
- server list
- sibling
- sorting
- slicing
- splashing
- splitter
- string hierarchy
- structure selection
- styles
- style sheets
- unique name
- variable
- visible area
- WebView widget
- widget
- widget communication
- write back
- xml variable