Index

A

• account.defaultName parameter / Session parameters, Using session parameters
• account.personalInfo.userName parameter / Session parameters
• action logs
• running, in batch mode / Running action logs in batch mode
• actions
• completing, from log file / How to play back actions from a log file
• aggregation rules
• creating, for measures / Creating aggregation rules for measures
• Archive-log.xml file / Starting Framework Manager
• areas, Project Viewer pane
• Data Sources / The Project Viewer pane
• Parameter Maps / The Project Viewer pane
• Packages / The Project Viewer pane
• attribute types
• specifying / Specifying attribute types

B

• batch mode
• action logs, running in / Running action logs in batch mode
• BmtScriptPlayer syntax / BmtScriptPlayer syntax
• business layer
• creating / Creating the business layer
• columns, renaming / Renaming columns
• columns, hiding / Hiding columns
• attribute types, specifying / Specifying attribute types
• filters, adding / Adding filters
• calculations, adding / Adding calculations
• prompts, adding / Adding prompts
• formatting, adding / Adding formatting

C

• calculations
• about / Adding calculations
• adding / Adding calculations
• embedded calculations / Embedded calculations
• standalone calculations / Standalone calculations
• cardinality
• about / Facts identified by cardinality, Cardinality
• rules / Cardinality
• detecting, during import / Detecting cardinality during import
• Cognos resources
• about / Cognos resources
• installed Cognos manuals / Installed Cognos manuals
• on Internet / Resources on the Internet
• columns
• renaming, in model / Renaming columns
• hiding, in model / Hiding columns
• configuration, IBM Cognos Framework Manager / Configuring Framework Manager
• Context Explorer
• about / The Diagram tab
• count() function / Determinants
• current_timestamp parameter / Session parameters
• Custom-data.xml file / Starting Framework Manager

D

• database objects
• importing / Importing additional database objects
• Data Definition Language (DDL) / Model portability
• data formatting
• properties / Data formatting properties
• data items
• grouping / Grouping data items
• data layer
• about / Data layer
• data source
• tables, importing from / Importing from the same data source
• Dependencies tab
• about / The Dependencies tab
• determinants
• about / Determinants that conflict with relationships, Determinants
• relationships, conflicting / Determinants that conflict with relationships
• adding / How to add determinants
• Diagram tab
• about / The Diagram tab
• dimension
• about / Cardinality
• dimensional layer
• about / Dimensional layer
• Dimensional Modeled Relational (DMR)
• about / Modeling layers
• Dimension Map tab
• about / The Dimension Map tab
• Dynamic Query Mode / Importing from a new data source
• about / Using the Dynamic Query Mode
• using / Using the Dynamic Query Mode

E

• embedded calculations
• calculated aggregation type, using / Embedded calculations that use the calculated aggregation type
• about / Embedded calculations
• creating / Creating embedded calculations
• embedded filters
• about / Embedded filters
• creating / Creating an embedded filter
• existing data source
• importing from / Importing from an existing data source
• Explorer tab
• about / The Explorer tab
• Explorer Tree / Model Design Accelerator user interface
• externalized query subjects
• using / Using externalized query subjects
• creating / Creating externalized queries
• externalize methods, IBM Cognos
• default / Creating externalized queries
• CSV / Creating externalized queries
• tab / Creating externalized queries
• IQD / Creating externalized queries

F

• fact tables
• about / Cardinality
• filter
• about / Adding filters
• adding / Adding filters
• embedded filters / Embedded filters
• standalone filters / Standalone filters
• folders
• creating / How to create folders
• used, for creating logical groups / Using folders and namespaces
• formatting
• adding / Adding formatting, Adding formatting
• formatting patterns
• using / Using formatting patterns
• Framework Manager
• multiuser modeling, implementing / Multiuser modeling in Framework Manager
• Framework Manager model
• generating / Generating a Framework Manager model
• Framework Manager project
• relational database metadata, importing into / Importing relational data

I

• IBM Cognos Architect / Importing relational data
• IBM Cognos Data Manager / Importing relational data
• IBM Cognos DecisionStream / Importing relational data
• IBM Cognos Framework Manager
• configuring / Configuring Framework Manager
• starting / Starting Framework Manager
• user interface screen / User interface
• IBM Cognos Framework Manager User Guide 10.1.1
• URL / Resources on the Internet
• IBM Cognos Impromptu / Importing relational data
• IBM Cognos Model / Importing relational data
• IBM Cognos PowerCubes / Importing OLAP data sources
• IBM Metadata Sources / Importing relational data
• IDlog.xml file / Starting Framework Manager
• import
• cardinality, detecting during / Detecting cardinality during import
• installed Cognos manuals / Installed Cognos manuals
• IQD method / Creating externalized queries
• item
• remapping, to new source / Remapping an item to a new source
• remapping / How to remap an item
• item dependencies
• displaying / Showing item dependencies

J

• joins
• adding, to workspace / Adding joins to your workspace

L

• links
• creating / Creating links
• Log.xml file / Starting Framework Manager
• log file
• used, for moving model / Moving a model by using the log file
• actions, completing from / How to play back actions from a log file
• logical layer
• about / Logical layer

M

• machine parameter / Session parameters
• Macros
• prompts, creating with / Creating prompts with Macros
• measure dimension
• about / Measure dimensions
• creating / Creating a measure dimension
• aggregation rules, creating / Creating aggregation rules for measures
• Microsoft Analysis Services Cubes / Importing OLAP data sources
• Minimized SQL setting
• overriding, factors / Factors that will override the Minimized SQL setting
• model
• report dependencies, displaying / Showing report dependencies
• item dependencies, displaying / Showing item dependencies
• moving, log file used / Moving a model by using the log file
• Model.xml file / Starting Framework Manager
• Model Accelerator / Model Design Accelerator user interface
• Model Advisor
• about / Using the Model Advisor
• using / How to use the Model Advisor
• Model Design Accelerator
• user interface / Model Design Accelerator user interface
• starting / Starting Model Design Accelerator
• tables, adding to workspace / Adding tables to your workspace
• joins, adding to workspace / Adding joins to your workspace
• Framework Manager model, generating / Generating a Framework Manager model
• modeling layers
• about / Modeling layers
• data / Data layer
• logical / Logical layer
• presentation / Presentation layer
• dimensional / Dimensional layer
• model portability / Model portability
• multiple hierarchy dimension
• about / Dimensions with multiple hierarchies
• creating / Creating a multiple hierarchy dimension
• multiuser modeling
• implementing, in Framework Manager / Multiuser modeling in Framework Manager

N

• namespaces
• about / How to create namespaces
• creating, steps / How to create namespaces
• new data source
• importing from / Importing from a new data source

O

• OLAP data sources
• importing / Importing OLAP data sources
• combining, with relational data sources / Combining OLAP and relational data sources
• Oracle Essbase / Importing OLAP data sources

P

• <project_name>.cpf file / Starting Framework Manager
• package
• creating / Creating a package
• modifying / Making changes to a package
• publishing / Publishing a package
• impact of changes, analyzing / Analyzing the impact of changes made to packages
• publish impact, analyzing / Analyzing publish impact
• package security
• using / Using package security
• package versions
• using / Using package versioning
• parameter maps
• about / Parameter maps
• rules / Parameter maps
• creating, ways / How to create parameter maps
• creating, manually / Creating a parameter map manually
• creating, from query item / Basing a parameter map on existing query items
• using / Using parameter maps
• Preferences.xml file / Starting Framework Manager
• presentation layer
• about / Presentation layer, Creating the presentation layer
• data items, grouping / Grouping data items
• project
• reusing / Reusing a project
• projects
• merging / Merge projects
• segmenting / Segmenting and linking projects
• linking / Segmenting and linking projects
• Project Viewer pane
• about / The Project Viewer pane
• areas / The Project Viewer pane
• prompts
• using, with stored procedure / Using prompts with a stored procedure
• about / Adding prompts
• creating, with Macros / Creating prompts with Macros
• Properties pane
• about / The Properties pane
• purpose joins
• about / Special purpose joins
• role playing dimensions / Role playing dimensions
• reflexive / Reflexive and recursive joins
• recursive / Reflexive and recursive joins

Q

• query item
• parameter maps, creating from / Basing a parameter map on existing query items
• query subjects
• behaving, as facts / Query subjects that can behave as facts or dimensions
• with multiple relationships / Query subjects with multiple relationships
• recursive relationship / Query subjects that join to themselves
• reflexive relationship / Query subjects that join to themselves
• metadata caching conflict, checking / Query subjects that can cause a metadata caching conflict

R

• recursive join
• about / Reflexive and recursive joins
• reflexive join
• about / Reflexive and recursive joins
• regular dimension
• about / Regular dimensions
• creating / Creating a regular dimension
• relational database metadata
• importing, into Framework Manager project / Importing relational data
• relational data sources
• combining, with OLAP data sources / Combining OLAP and relational data sources
• relationships
• creating / Creating relationships and cardinality
• modeling / Where to model the relationships
• report dependencies
• displaying / Showing report dependencies
• role playing dimension / Role playing dimensions
• runLocale parameter / Session parameters, Using session parameters

S

• SAP BW / Importing OLAP data sources
• scope relationships
• about / Scope relationships
• creating / Creating a scope relationship
• Search tab
• about / The Search tab
• segment
• creating / Creating a segment
• semi-additive measure
• creating / Creating aggregation rules for measures
• Session-log-backup.xml file / Starting Framework Manager
• Session-log.xml file / Starting Framework Manager
• session parameters
• about / Session parameters
• account.defaultName / Session parameters
• account.personalInfo.userName / Session parameters
• runLocale / Session parameters
• current_timestamp / Session parameters
• machine / Session parameters
• rules / Session parameters
• creating / Creating a session parameter
• modifying / Modifying session parameters
• using / Using session parameters
• shortcuts
• used, for grouping data items / Using shortcuts
• creating / Creating shortcuts
• source
• item, remapping to / Remapping an item to a new source
• standalone calculations
• about / Standalone calculations
• creating / Creating standalone calculations
• standalone filters
• about / Standalone filters
• creating / Creating a standalone filter
• stored procedures
• importing / Importing stored procedures
• prompts, using with / Using prompts with a stored procedure
• sum() function / Determinants
• Summary tab
• about / The Summary tab
• Search tab / The Search tab

T

• table definitions
• for schema / Table definitions
• tables
• importing, from data source / Importing from the same data source
• adding, to workspace / Adding tables to your workspace
• toolbars
• functions / Toolbars
• Tools pane
• about / The Tools pane

U

• user interface, IBM Cognos Framework Manager
• about / User interface
• Project Viewer pane / The Project Viewer pane
• Explorer tab / The Explorer tab
• Diagram tab / The Diagram tab
• Dimension Map tab / The Dimension Map tab
• Properties pane / The Properties pane
• Tools pane / The Tools pane
• Summary tab / The Summary tab
• Dependencies tab / The Dependencies tab
• toolbars / Toolbars
• user interface, Model Design Accelerato
• Explorer Tree / Model Design Accelerator user interface
• Model Accelerator / Model Design Accelerator user interface

W

• workspace
• tables, adding to / Adding tables to your workspace
• joins, adding to / Adding joins to your workspace