Contents

• Infor BI Designer
• Overview and start
  • General information
  • Starting Infor BI Designer
  • Connecting with an existing repository registration
  • Registering a Designer database
  • Connecting without an existing repository registration (initial log-on)
  • User interface
  • Navigation tree
    • Moving objects between projects
    • The Common folder
  • Data section
  • Status section
  • Running the DistClean utility
• Working with Infor BI Designer
  • Menu commands
    • File
      • Creating database
      • Validating database
      • Importing database languages
      • Validating database schema
      • Settings
        • Language
        • Repository Connection
        • Modeling Service
        • Models
        • Logging
          • Auditing
          • Audit events in Designer
        • Designer Database
        • General
    • Action
    • Infor BI Designer help
  • Folders
    • Creating and deleting folders
    • Folder objects in the data section
  • Relational tables
    • Data section of relational tables
    • Data input
    • Creating, editing, and deleting elements
    • Comments and notes
    • The Help tab
  • Dimensions
    • Creating and deleting dimensions
    • Opening dimensions with Infor BI OLAP Server
    • Editing dimension properties
      • Dimension Properties tab
      • Level Names tab
      • Attributes tab
      • Creating and editing attributes
      • Cubes tab
      • Mappings tab
    • Subsets
      • Creating subsets
        • Creating a static subset
        • Creating a dynamic subset
        • Creating a parent-child subset
      • Editing and deleting subsets
    • Data section of dimensions
    • Adjusting and analyzing the structure
    • Data input
    • Parents
    • Permissions
    • Import
      • Selecting the data source text file
      • Selecting the data source table from a relational database
      • Importing data
        • Schema tab – overview and column mappings
        • Data tab – importing and mapping elements
        • Order position
    • Unified data sources
    • Comments and notes
    • The Help tab
  • Cubes
    • Creating cubes
    • Editing and deleting cubes
    • Using MDAC cubes
    • Properties of cubes
      • Editing general cube properties
      • Administering cube permissions
      • Cube-to-cube relations
    • Comments and notes
  • Importing and exporting rules
    • Importing rules
    • Exporting rules
    • Confirming rule creation
  • Office documents
    • Embedding, saving, and deleting documents
    • Opening Office documents
  • Web pages
    • Embedding and removing web pages
    • Opening web pages
  • Scripts
    • Creating and deleting scripts
    • Specifying, editing, and running scripts
    • Script properties
    • Comments and notes
• System
  • Overview System
  • Connections
  • Data Sources
  • Data Connections
  • Languages
    • Managing languages
    • Assigning multilingual captions
  • Access Control
    • Setting up the application user
    • Setting up the Designer administrator
    • Setting up the Designer user
    • Assigning object permissions to users and roles
  • Common
  • Rules
    • Rule groups
    • Creating a rule group
    • Assigning a rule to a group
    • Deleting an assignment
    • Editing a rule group
• Connector
  • Concepts
    • Data links and ODBC connections
    • Source databases
    • Business units
    • Business groups
    • Mapping source tables to target dimensions
    • Mapping elements and creating hierarchies
    • Reference database
    • Data connections for cubes
  • Step by step
  • Connector settings
    • Connect to the data link service – Data link service tab
    • ODBC connections tab
  • Configuring data links and data connections
    • Data link setup
    • Enabling connections and business units
      • Synchronizing Data Link connections
      • Enabling business units
  • Configuring business units
    • Editing the business units
    • Work space of the business unit configuration
      • Icons of the tree nodes
      • Buttons to configure nodes
      • The Properties section
    • Properties of the tables
    • Configuring the fact tables
      • Incrementally loading the fact tables
    • Configuring the dimensions
      • Specifying the Key field
      • Specifying the Description field
      • Additional settings of specific dimension types
    • Properties of the fields
    • Synchronizing attribute table fields
    • Editing the related fields
      • Adding related fields
      • Removing related fields
      • Navigating between related fields
      • Erroneous relations
    • Importing hierarchical information
    • Adding tables
    • Removing tables
    • Create lookup dimensions
    • Editing SQL statement
  • Configuring business groups
    • Creating business groups
      • Step 1 - Specify the name and description
      • Step 2 - Select the business units
      • Step 3 - Configure the currencies
      • Step 4 - Create the unified mappings
      • Step 5 - Data Transfer
      • Step 6 - Loading structures
      • Step 7 - Summary
    • Editing business groups
      • Changing the description of a business group
      • Specifying exchange rates
      • Business units
      • Currencies
      • Mappings
      • Data connections for cubes
      • Data transfer
      • Loading structures
      • Carry forward
    • Deleting business groups
    • Refreshing the mappings of a business group
  • Mapping tables and dimensions
    • Creating mappings
    • Editing mappings
    • Selecting source elements for import
      • Copying elements
      • Mapping elements
      • Copying with dynamic ranges
    • Refreshing the mappings
    • Deleting mappings
  • Mapping dimension elements
    • Copying elements
    • Mapping elements
    • Copying with dynamic ranges
    • Creating hierarchies with dynamic ranges
  • Configuring data connections for cubes
    • Creating, Editing, Deleting
    • Configuring the data transfer
  • Importing data
  • Exporting data
  • Connector configuration check