Contents
- Infor BI Office Plus
- Program Start and the User Interface
- Data Access
- Alias types
- Creating a database alias
- Editing a database alias
- Calculations
- Lists
- Applying ranking (Analysis Services only)
- Writing back values
- Allocate and Alter
- Write back methods and commands
- Weighted
- Equal
- To each leaf
- COPY
- COPYFULL
- LIKE
- LIKEFULL
- Rounding
- Immediate and non-immediate writeback
- Writing back multiple values with copy and paste
- Reallocation
- Infor BI Splasher - writing back in Alea Ad-hoc reports
- The VDBSET function
- VDBSET in Visual Basic
- Subsets
- Attribute tables
- Cubes and Data Areas
- Creating cubes and data areas
- Creating cubes
- Deleting cubes
- The Cube Properties dialog
- Creating and activating cubes for multidimensional access control
- The Alias Properties dialog
- Importing and Processing Cube Data
- Exporting cubes to a text file
- Data areas
- Cube Rules
- Cube rules
- General cube rule syntax
- Conventions for writing cube rules
- Rules functions
- Math rule functions
- Text rule functions
- Date and time rule functions
- Dimension rule functions
- Other rule functions
- Examples of cube rules
- The Edit Cube Rule dialog
- Creating cube rules
- Editing cube rules
- Deactivating cube rules
- The Cell Reference dialog
- Accelerators
- Exporting cube rules
- Importing cube rules
- Using a text editor to edit rules
- Editing rules with Microsoft Excel
- Saving cube rules to disk
- Discarding changes to cube rules
- Cell coordinates and rule optimization
- Dimensions and Elements
- Creating dimensions
- Editing dimensions
- Deleting dimensions
- Types of element
- Creating elements
- Defining consolidated elements
- Defining rule elements
- Syntax of rules
- Using Microsoft Excel to edit dimensions
- Using a text editor to edit dimensions
- Importing a dimension structure from a text file
- Exporting dimensions as text
- Copying elements from a dimension
- Importing new elements with Microsoft Excel
- Changing the view of a dimension in the Dimension Browser
- The Dimension Properties dialog
- Editing and deleting attributes
- Searching for elements and attributes
- Saving and discarding dimension changes
- Report management
- Choosing slice elements in Formula and Ad-hoc reports
- Importing reports
- Exporting reports
- Using templates with ad-hoc reports
- Importing templates
- Creating templates from ad-hoc reports
- Creating templates
- Formula reports
- Formulas
- Office Plus formulas
- Alea formulas
- Predefined MDX.GET formulas
- AT.COUNT
- AT.FIELD
- AT.FIELDCOUNT
- AT.FIELDINDEX
- AT.FIELDTYPE
- AT.GET
- AT.HEAD
- AT.NAME
- AT.SET
- AT.SUB.HEAD
- CA2UN
- CELL.ALLOCATE
- CELL.GET
- CELL.GETC
- CELL.GETF
- CELL.GETFC
- CELL.WRITE
- DBGET
- DBGETC
- DBGETC.FIRST
- DBGETC.NEXT
- DBSET
- DBSET2
- DBSET3
- DC.MEMBER
- DE.ADD
- DE.CHILDNAME
- DE.CHILDRENCOUNT
- DE.COUNT
- DE.FIRST
- DE.INDEX
- DE.ISCHILD
- DE.LEVEL
- DE.NAME
- DE.NEXT
- DE.PARENTNAME
- DE.PARENTSCOUNT
- DE.PREV
- DE.SIBLING
- DE.TOPCOUNT
- DE.TOPNAME
- DE.TYPE
- DE.WEIGHT
- DIM.MASK.NOTE.DELETE
- DIM.MASK.NOTE.GET
- DIM.MASK.NOTE.SET
- DIM.TOPLEVEL
- DIMENSION.GET.INFO
- GETSESSIONID
- KEY.GET
- KPI.GET
- LIST.ALIAS.NAME
- LIST.CUBE.NAME
- LIST.MDX.GET
- LIST.MEMBER.NAME
- LIST.MMEMBER.NAME
- MDS.ERROR
- MDS.ISNA
- MDS.LAST.ERROR
- MDS.NA
- MDS.SET.LAST.ERROR
- MDX.EXECUTE
- MDX.GET and Predefined MDX.GET formulas
- DIMENSIONS.COUNT
- ELEMENT.ATTRIBUTE
- ELEMENT.COUNT.CHILDREN
- ELEMENT.DIMENSION.NAME
- ELEMENT.HIERARCHY.NAME
- ELEMENT.ID
- ELEMENT.LEVEL.NAME
- GET.CHILD
- GET.DEFAULTELEMENT
- GET.FIRSTSIBLING
- GET.HIERARCHY.PER.ID
- GET.LEAD
- GET.NEXT
- GET.PARENT
- GET.PREVIOUS
- HIERARCHY.COUNT.LEVELS
- HIERARCHY.COUNT.ELEMENTS
- HIERARCHY.DIMENSION.NAME
- HIERARCHY.NAME
- ISGENERATION
- ISLEAF
- ISSIBLING
- LEVEL.COUNT.ELEMENT
- LEVEL.HIERARCHY.NAME
- LEVEL.NAME.PER.ID
- USER.NAME
- MDX.SET.CPICK
- MDX.SET.MPICK
- MDX.SET.PICK
- MEMBER.ANAME
- MEMBER.CNAME
- MEMBER.MNAME
- MEMBER.NAME
- MMEMBER.ANAME
- MMEMBER.CNAME
- MMEMBER.MNAME
- MMEMBER.NAME
- NA2UN
- NGET
- NSET
- SE.COUNT
- SE.INDEX
- SE.NAME
- SERVER.GET.INFO
- STABLE.COUNT
- STABLE.NAME
- TABLE.GET.INFO
- TDIM.COUNT
- TDIM.NAME
- VALUE.BUFFER.ANYTHING.CHANGED
- VALUE.BUFFER.GET.CALC.STATE
- WORKSPACE.GET.PARAMETER
- WORKSPACE.MAKE
- WORKSPACE.RELEASE
- WORKSPACE.SUBRELEASE
- WORKSPACE.VERSION
- Formula errors
- Ad-hoc reports
- Creating a default Ad-hoc report
- Creating an Ad-hoc report from the ribbon
- Applying a template to an Ad-hoc report
- Viewing properties of Ad-hoc reports
- Designing Ad-hoc reports
- Navigating in Ad-hoc reports
- Working with charts
- Formatting Ad-hoc reports
- Working with exception ranges
- Converting an Ad-hoc report
- Cell notes
- Alea Ad-hoc reports
- Limitations
- Creating reports from the Cubes and Data Areas dialog
- Creating reports from the Alea Ad-hoc Report dialog
- Default Alea ad-hoc reports
- Prerequisites
- Recommended location
- First location
- Second and third locations
- Opening a default Alea ad-hoc report
- Using key query to search for non-zero values
- Using zero suppression to hide zero values
- Navigating in Alea Ad-hoc reports
- Converting Alea Ad-hoc reports to formula reports
- Converting Alea Ad-hoc reports to Ad-hoc reports
- Converting Alea Ad-hoc reports from .alv to .xlsx format
- VBA functions
- Macro functions
- Attaching cell notes and comments
- Administration
- User management
- Opening the User Management dialog
- Working with user management
- Creating and deleting basic users
- Registering Windows users and groups
- Adding LDAP users and groups
- Configuring LDAP
- Managing users and groups
- User management permissions, predefined roles and groups and users
- Registering external authentication systems
- Managing project and report catalog permissions
- Managing report catalog permissions
- Report catalog permissions
- Predefined report catalog roles
- Checking effective permissions
- Assigning permissions to folders and reports
- Options
- Repository conversion
- Restoring cube data
- Access control
- User management
- Tools
- 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