Index

A

• @Aggregate_Aware() function
  • about / @Aggregate_Aware()
• Access Level option, Advanced tab
  • about / Access Level
• Access Modules Processors (AMPs)
  • about / A foreign key
• Add to View... function
  • about / Add to View
• adoption level, BI Maturity Model
  • about / The BI Maturity Model
• advanced analytics level, BI Maturity Model
  • about / The BI Maturity Model
• advanced Business layer properties
  • about / Advanced Business layer properties
  • accessing / Advanced Business layer properties
  • Description field / Description
  • Summary… button / Summary
  • Change Data Foundation… button / Change Data Foundation
  • Parameters window / Parameters
• advanced Data Foundation layer properties
  • about / Advanced Data Foundation properties
  • description / Description
  • SQL options / SQL Options
  • summary / Summary
  • parameters / Parameters
• advanced design techniques, Data Foundation
  • about / Advanced design techniques of Data Foundation
  • alias table / Alias tables
  • context / Context
  • shortcut join / The shortcut join
  • Data Foundation layer properties / Advanced Data Foundation properties
• Advanced tab
  • about / Controlling advanced properties
  • Access Level option / Access Level
  • Objects can be used in section / Objects can be used in
  • Database Format section / Database Format
  • list of values (LOV) / List of Values
  • Display option / Display
• aggregate awareness
  • about / Aggregate awareness
  • aggregated tables, inserting / Inserting aggregated tables
  • aggregated objects, defining / Defining the aggregated objects
  • aggregation navigation, detecting / Detecting the aggregation navigation
• aggregated objects
  • defining / Defining the aggregated objects
• aggregated tables
  • inserting / Inserting aggregated tables
• aggregation navigation
  • detecting / Detecting the aggregation navigation
• alias table
  • used, for solving chasm trap / Solving the chasm trap using an alias table
  • used, for fixing loop / Fixing the loop using an alias table
• alias tables, Data Foundation
  • about / Alias tables, Alias tables
  • creating / Alias tables
• Attribute / Dimensional modeling terminologies
• attributes, business objects types
  • about / Attributes
  • creating / Attributes

B

• basic BI level, BI Maturity Model
  • about / The BI Maturity Model
• BI
  • about / What is Business Intelligence?
  • concepts / Business Intelligence concepts
  • knowledge pyramid / The knowledge pyramid
  • hindsight / Hindsight, insight, and foresight
  • insight / Hindsight, insight, and foresight
  • foresight / Hindsight, insight, and foresight
  • data warehouse (DWH) / BI and DWH
  • reporting tools architecture / BI reporting tools architecture
• BIAR file
  • about / Promoting a Universe from one environment to another
• BI Maturity Model
  • about / The BI Maturity Model
  • levels / The BI Maturity Model
• BI reporting architecture model
  • about / BI reporting tools architecture
  • one-tier architecture model / The one-tier architecture model
  • two-tier architecture model / The two-tier architecture model
  • three-tier architecture model / The three-tier architecture model
• branch hierarchy
  • about / Navigation paths
• business layer
  • about / Creating your first Universe step by step
  • creating / Creating a new Business layer
• Business layer
  • requirements-gathering process / Gathering requirements
  • Business Layer window / The Business layer's main window
  • Queries tab / Queries in the Business layer
• business layer, Universe
  • about / Introduction to Universes and the Information Design Tool
• Business Layer tab
  • about / Business Layer
  • Business layer views, managing / Managing Business layer views
  • Business layer views, creating / Managing Business layer views
  • search panel, showing/hiding / Showing/hiding the search panel
  • expand all / Expand and collapse all
  • collapse all / Expand and collapse all
  • Display Options / Display Options
  • Insert Object menu / Inserting objects
• Business Layer window
  • about / The Business layer's main window
  • left panel / The left panel
  • Properties panel / The Properties panel
  • Data Foundation panel / The Data Foundation panel
• business objects
  • about / Business objects
  • best practices / Business objects
  • types / Business objects
  • folders / Folders
  • dimensions / Dimensions
  • attributes / Attributes
  • measures / Measures
  • filters / Filters
• Business Objects
  • about / History of SAP Business Objects
• business objects specific functions
  • about / Common business objects' specific functions
  • @Aggregate_Aware() / @Aggregate_Aware()
  • @DerivedTable() / @DerivedTable()
  • @Prompt() / @Prompt()
  • @Select() / @Select()
  • @Variable() / @Variable()
  • @Where() / @Where()
• Business Security Profiles
  • about / Understanding Business Security Profiles
  • Create Query view / Create Query
  • Display Data tab / Display Data restriction
  • Filters tab / Filters

C

• cardinality
  • about / Cardinality
• Central Management Console (CMC) / Promoting NorthWind using the LCMBIAR file
• Central Management Console (CMC) administration window
  • about / Access Level
• Centre on Selection option / Centre on Selection
• Change Data Foundation… button, advanced Business layer properties
  • about / Change Data Foundation
• Change Qualifier/Owner... option
  • about / Change Qualifier/Owner
• chasm trap
  • about / The chasm trap
  • example / The chasm trap
  • identifying / The chasm trap
  • solving, context used / Solving the chasm trap using context
  • solving, alias table used / Solving the chasm trap using an alias table
• Cheat Sheets
  • about / Cheat Sheets
  • used, for creating Northwind3 Universe / Cheat Sheets
• Check Integrity Problems window, IDT interface
  • about / Check Integrity Problems
• Check Integrity wizard
  • about / Using the Check Integrity wizard
  • using / Using the Check Integrity wizard
• client applications / BI reporting tools architecture
• closing phase, Universe development life cycle
  • about / Closing
• complex joins
  • about / Theta joins
• Concat function
  • about / Insertion
• conditions
  • about / Filters
• connection, Universe
  • about / Introduction to Universes and the Information Design Tool
• Connections view, Data Security Profiles
  • about / Connections
• context
  • about / The knowledge pyramid
  • creating / Solving the chasm trap using context
  • used, for solving chasm trap / Solving the chasm trap using context
  • used, for fixing loop / Fixing the loop using context
• context, Data Foundation
  • about / Context
• Controls tab, Data Security Profiles
  • about / Controls
• Count Row... option
  • about / Count Rows
• Create Query view, Business Security Profiles
  • about / Create Query
• custom navigation path
  • about / The custom navigation path
  • creating / The custom navigation path
• Custom Properties tab
  • about / Custom Properties

D

• @DerivedTable() function
  • about / @DerivedTable()
• database-server tier / BI reporting tools architecture
• Database Format section, Advanced tab
  • about / Database Format
• database management system (DBMS)
  • about / Creating the ODBC Connection
• database management systems (DBMS)
  • about / Northwind
• data connection
  • about / Creating your first Universe step by step
  • creating / Creating a new data connection
  • working with / Working with data connections
  • relational connection / The relational connection
  • OLAP connection / The OLAP connection
• Data Foundation
  • about / Creating your first Universe step by step
  • creating / Creating a new Data Foundation
  • types / Types of Data Foundation
  • single source Data Foundation / Single Source
  • multisource-enabled Data Foundation / Multisource-Enabled
  • physical objects / Physical tables and views
  • alias tables / Alias tables
  • derived tables / Derived tables
  • menus and functions / Data Foundation menus and functions
  • design concepts / Design concepts
  • advanced design techniques / Advanced design techniques of Data Foundation
  • SQL design traps / SQL design traps
• Data Foundation display
  • controlling / Controlling the Data Foundation display
  • view, inserting / Insert View
  • Data Foundation visualization, enhancing / Data Foundation visualization
• Data Foundation layer
  • about / Building the Data Foundation layer
  • building / Building the Data Foundation layer
• data foundation layer, Universe
  • about / Introduction to Universes and the Information Design Tool
• Data Foundation object
  • manipulation / Data Foundation object manipulation
  • insertion / Insertion
  • table manipulation / Table manipulation
  • table's discovery and display / The table's values and display
• Data Foundation panel, Business Layer window
  • about / The Data Foundation panel
  • Open Data Foundation function / The Data Foundation panel
  • Change Data Foundation function / The Data Foundation panel
• Data Foundation structure
  • refreshing / Refreshing the structure
• Data Foundation toolbar
  • about / Data Foundation menus and functions
  • Detect Joins / Detecting joins
  • Detect Cardinalities / Detecting cardinalities
  • Detect Row Count / Detecting the row count
  • Refresh Structure option / Refreshing the structure
  • Edit Families / Managing families
  • Save View as Image / Save the view as an image
  • Search panel / The search panel
  • Auto Arrange Tables / Auto-arranging tables
• Data Foundation visualization
  • enhancing / Data Foundation visualization
• Data Governance
  • about / BI and DWH
• Data Quality (DQ)
  • about / BI and DWH
• Data Security Profiles
  • about / Understanding Data Security Profiles
  • creating / Understanding Data Security Profiles
  • Connections view / Connections
  • Controls tab / Controls
  • SQL tab / SQL
  • Rows tab / Rows
  • Tables tab / Tables
• data type, dimensions
  • string / Main properties
  • long text / Main properties
  • numeric / Main properties
  • boolean / Main properties
  • DateTime / Main properties
  • date / Main properties
  • blob / Main properties
• data warehouse (DWH)
  • about / Business objects
• DateTime
  • about / Main properties
• default navigation path
  • about / The default navigation path
• Delimit option
  • about / Delimit
• derived tables, Data Foundation
  • about / Derived tables
  • creating / Derived tables
  • uses / Derived tables
  • @Prompt functionality, using / Using the @Prompt functionality in a derived table
  • nested derived tables / Nested derived tables
  • listing / List of derived tables
• Description field, advanced Business layer properties
  • about / Description
• design concepts, Data Foundation
  • information systems / Information systems
  • DWH schema types / The DWH schema types
• detailed table
  • about / Dimensional modeling terminologies
• Detect option
  • about / Detect
• Dimension / Dimensional modeling terminologies
• dimensional modelling terminologies, Northwind data model
  • dimension / Dimensional modeling terminologies
  • measure / Dimensional modeling terminologies
  • attribute / Dimensional modeling terminologies
• dimensions, business objects types
  • about / Dimensions
  • creating / Dimensions
  • properties / Dimensions, Main properties
  • data types / Main properties
  • Show Script function / Main properties
  • Show Values function / Main properties
  • SQL Definition tab / SQL Definition
  • Keys tab / Keys
  • Advanced tab / Controlling advanced properties
  • Source Information tab / Source Information
  • Custom Properties tab / Custom Properties
• dimension table
  • about / Dimensional modeling terminologies
• Display Data tab, Business Security Profiles
  • about / Display Data restriction
• display modes, Data Foundation tables
  • about / Display
  • Collapsed / Display
  • Joins Only / Display
  • Expanded / Display
• Display Options
  • about / Display Options
  • Show All Objects / Display Options
  • Hide Non-Active Objects / Display Options
• display options, Advanced tab
  • Default / Display
  • HTML / Display
  • Hyperlink / Display
• Display section, Advanced tab
  • about / Display
  • display format, creating / Display
  • format properties / Display
  • Data format / Display
  • Date-Time format / Display
  • Numeric format / Display
  • Alignment tab / Display
  • Border tab / Display
  • Shading tab / Display
  • Font tab / Display
  • display options / Display
• DWH
  • about / Business Intelligence concepts, BI and DWH
  • Data Quality (DQ) / BI and DWH
  • Master Data Management (MDM) / BI and DWH
  • Metadata / BI and DWH
  • Data Governance / BI and DWH
  • reference links / BI and DWH
• DWH schema types
  • about / The DWH schema types
  • snowflake schema / The snowflake schema
  • star schema / The star schema
  • relational model / The relational model

E

• Edit option
  • about / Edit
• entity-relationship diagram (ERD) / Order information
• equal join
  • about / Equal joins
  • creating / Equal joins
  • cardinality, setting / Equal joins
• Extra Tables property
  • about / The Extra Tables property

F

• fact table
  • about / Dimensional modeling terminologies
• families
  • managing / Managing families
  • creating / Managing families
  • editing / Managing families
  • deleting / Managing families
• fan trap
  • about / The fan trap
  • example / The fan trap
  • conditions / The fan trap
  • simulating / The fan trap
  • solving / Solving a fan trap
• filters, business objects types
  • about / Filters
  • creating / How to create a filter
  • Properties window / Filter properties
• Filters tab, Business Security Profiles
  • about / Filters
• folders, business objects types
  • about / Folders
  • creating / Folders
  • Folder properties panel / Folders
  • considerations / Folders
• foreign key
  • about / A foreign key
• foreign key, index awareness
  • about / Foreign keys
• foresight
  • about / Hindsight, insight, and foresight
• format properties, Display section
  • about / Display
• Framework / Introduction to Universes and the Information Design Tool

H

• Highlight Aliases option / Highlight Aliases
• Highlight Related Tables option
  • about / Highlight Related Tables
• hindsight
  • about / Hindsight, insight, and foresight
• HOLAP
  • about / Online analytical processing

I

• IDT
  • about / Information Design Tool
  • features / The main features of the IDT
  • running / The Information Design Tool interface
• IDT interface
  • about / The Information Design Tool interface
  • Local Projects / Local Projects
  • Repository Resources / Repository Resources
  • Security Editor / Security Editor
  • Project Synchronization / Project Synchronization
  • Check Integrity Problems / Check Integrity Problems
• implementation and development phase, Universe development life cycle
  • about / Implementation and development
• index awareness
  • about / Keys, Index awareness
  • primary key, defining / Primary keys
  • foreign key / Foreign keys
• Information Design Tool
  • about / Introduction to Universes and the Information Design Tool
• Information Design Tool (IDT) / Creating the ODBC Connection
• information systems
  • about / Information systems
  • online transactional processing / Online transactional processing
  • online analytical processing / Online analytical processing
• Information Technology (IT) systems / Information systems
• initiation level, BI Maturity Model
  • about / The BI Maturity Model
• initiation phase, Universe development life cycle
  • about / Initiation
• Insert menu
  • about / Insertion
• Insert Object menu
  • about / Inserting objects
• Insert View / Insert View
• insight
  • about / Hindsight, insight, and foresight
• inventory information, Northwind data model
  • about / Inventory information

J

• join
  • defining / Join types
• join cardinalities
  • detecting / Detecting cardinalities
• joins
  • about / Joining tables
  • detecting / Detecting joins
• join types
  • about / Join types
  • equal join / Equal joins
  • theta join / Theta joins
  • outer joins / Outer joins
  • self join / Self joins

K

• key
  • about / Key types
• Keys tab
  • about / Keys
• key types
  • about / Key types
  • primary key / A primary key
  • foreign key / A foreign key
• knowledge pyramid
  • about / The knowledge pyramid
  • data / The knowledge pyramid
  • information / The knowledge pyramid
  • knowledge / The knowledge pyramid
  • wisdom / The knowledge pyramid
  • stages / The knowledge pyramid
  • relating, to BI / The knowledge pyramid
  • URL / The knowledge pyramid

L

• LCMBIAR file
  • used, for promoting NorthWind / Promoting NorthWind using the LCMBIAR file
• left panel, Business Layer window
  • about / The left panel
  • Business Layer tab / The left panel
  • Queries tab / The left panel
  • Parameters and Lists of Values tab / The left panel
  • Navigation Paths tab / The left panel
• levels, BI Maturity Model
  • basic BI / The BI Maturity Model
  • initiation / The BI Maturity Model
  • operation / The BI Maturity Model
  • adoption / The BI Maturity Model
  • advanced analytics / The BI Maturity Model
• life cycle management (LCM) console
  • about / Promotion and the life cycle management console
  • purpose / Promotion and the life cycle management console
  • Universe, promoting / Promoting a Universe from one environment to another
  • Northwind, promoting with LCMBIAR file / Promoting NorthWind using the LCMBIAR file
  • Northwind, promoting with Live to Live method / Promoting NorthWind using the Live to Live method
• list of values
  • about / List of values
  • types / List of values
  • based on dimension object / List of values, List of values based on a dimension object
  • static list of values / List of values
  • based on custom SQL / List of values
• list of values (LOV) section, Advanced tab
  • about / List of Values
• list of values based on custom SQL
  • about / List of values based on custom SQL
  • creating / List of values based on custom SQL
• list of values based on dimension object
  • about / List of values based on a dimension object
  • list of values based on query panel, creating / List of values based on the query panel
  • list of values based on custom hierarchy, creating / List of values based on a custom hierarchy
• Live to Live method
  • about / Promoting a Universe from one environment to another, Promoting NorthWind using the Live to Live method
  • used, for promoting NorthWind / Promoting NorthWind using the Live to Live method
• local project
  • about / Local projects
  • creating / Creating a local project
  • opening / Opening a local project
  • deleting / Deleting a local project
• Local Projects window, IDT interface
  • about / Local Projects
• loop
  • about / Loop
  • created loop, visualizing / Loop
  • fixing, shortcut join used / Fixing the loop using the shortcut join
  • fixing, context used / Fixing the loop using context
  • fixing, alias table used / Fixing the loop using an alias table

M

• mapping table
  • about / Dimensional modeling terminologies
• Master Data Management (MDM)
  • about / BI and DWH
• Measure / Dimensional modeling terminologies
• measures, business objects types
  • creating / Measures
  • about / Measures
  • database function, differentiating with projection function / Difference between the database and projection functions
• Merge option
  • about / Merge
• Metadata
  • about / BI and DWH
• Microsoft SQL Server
  • URL / A foreign key
• MOLAP
  • about / Online analytical processing
• multilingual Universes
  • about / Multilingual Universes
• multisource-enabled Data Foundation
  • about / Multisource-Enabled

N

• navigation paths
  • about / Navigation paths
  • default navigation path / The default navigation path
  • custom navigation path / The custom navigation path
  • custom navigation path, creating / The custom navigation path
• nested derived tables
  • about / Nested derived tables
  • creating / Nested derived tables
• Northwind
  • about / Northwind
  • recommendations, by formed committee / Northwind
  • SAP BusinessObjects, recommended by formed committee / Northwind
  • database setup / Configuring and setting up Northwind's database
  • configuration / Configuring and setting up Northwind's database
  • IDT interface / The Information Design Tool interface
  • promoting, LCMBIAR file used / Promoting NorthWind using the LCMBIAR file
  • promoting, Live to Live method used / Promoting NorthWind using the Live to Live method
• Northwind3 Universe
  • creating, with Cheat Sheets / Cheat Sheets
• Northwind data model
  • about / The Northwind data model
  • dimensional modelling terminologies / Dimensional modeling terminologies
  • fact table / Dimensional modeling terminologies
  • dimension table / Dimensional modeling terminologies
  • detailed table / Dimensional modeling terminologies
  • mapping table / Dimensional modeling terminologies
  • order information / Order information
  • inventory information / Inventory information
• Northwind sample database
  • obtaining / Getting the Northwind sample database
  • downloading, from Microsoft website / Getting the Northwind sample database
  • getting, from SAP BusinessObjects samples directory / Getting the Northwind sample database
• Northwind Universe
  • creating / Creating your first Universe step by step

O

• Objects can be used in section, Advanced tab
  • about / Objects can be used in
  • Results / Objects can be used in
  • Conditions / Objects can be used in
  • Sort / Objects can be used in
• ODBC
  • about / Creating the ODBC Connection
• ODBC connection
  • creating / Creating the ODBC Connection
  • URL / Creating the ODBC Connection
• OLAP
  • about / Online analytical processing
  • ROLAP / Online analytical processing
  • MOLAP / Online analytical processing
  • HOLAP / Online analytical processing
• OLAP connection
  • about / The OLAP connection
• OLTP
  • about / Online transactional processing
• one-tier architecture model
  • about / The one-tier architecture model
  • characteristics / The one-tier architecture model
• operational data store (ODS) / Northwind
• operation level, BI Maturity Model
  • about / The BI Maturity Model
• Oracle
  • URL / A foreign key
• order information, Northwind data model
  • about / Order information
• Orders Context / Fixing the loop using context
• outer joins
  • about / Outer joins
  • right outer join / Outer joins
  • left outer join / Outer joins
  • full outer join / Outer joins
  • creating / Outer joins

P

• @Prompt() function
  • about / @Prompt()
• @Prompt functionality
  • using, in derived table / Using the @Prompt functionality in a derived table
• Parameters window, advanced Business layer properties
  • about / Parameters
• physical objects, Data Foundation
  • tables / Physical tables and views
  • views / Physical tables and views
• planning and design phase, Universe development life cycle
  • about / Planning and design
• primary indexes
  • about / A foreign key
• primary key
  • about / A primary key
• primary key, index awareness
  • defining / Primary keys
• Project / Introduction to Universes and the Information Design Tool
• projects
  • working with / Working with projects
  • local project / Local projects
  • shared project / Shared projects
  • synchronizing / Synchronizing projects
• Project Synchronization window
  • about / Synchronizing projects
  • top panel / Synchronizing projects
  • left panel / Synchronizing projects
  • right panel / Synchronizing projects
  • Save to server / Synchronizing projects
  • Get from server / Synchronizing projects
  • Lock shared resource / Synchronizing projects
  • Unlock shared resource / Synchronizing projects
• Project Synchronization window, IDT interface
  • about / Project Synchronization
• properties, dimensions
  • name / Main properties
  • status / Main properties
  • description / Main properties
  • data type / Main properties
• Properties panel, Business Layer window
  • about / The Properties panel
• Properties window, filters
  • Apply on Universe / Filter properties
  • Apply on Folder / Filter properties
  • Apply on List of Values / Filter properties
• Purchase Orders Context / Fixing the loop using context

Q

• quality assurance and testing phase, Universe development life cycle
  • about / Quality assurance and testing
  • types / Quality assurance and testing
  • SIT / SIT
  • UAT / UAT
• Queries editor
  • uses / Queries in the Business layer
• Queries tab, Business layer
  • about / Queries in the Business layer
  • using / Queries in the Business layer
  • Queries editor / Queries in the Business layer

R

• relational connection
  • about / The relational connection
• relational model
  • about / The relational model
• Replace by option
  • about / Replace by
• Repository Resources window, IDT interface
  • about / Repository Resources
• requirements-gathering process, Business layer
  • planning / Gathering requirements
  • design / Gathering requirements
  • execution / Gathering requirements
  • testing / Gathering requirements
• resources, Universe
  • data connection / Creating your first Universe step by step
  • Data Foundation / Creating your first Universe step by step
  • business layer / Creating your first Universe step by step
• row count
  • detecting / Detecting the row count
• Rows tab, Data Security Profiles
  • about / Rows

S

• @Select() function
  • about / @Select()
• SAP BO IDT
  • about / Information Design Tool
• SAP BO IDT security model
  • about / Understanding the security model
• SAP BO Universe Builder
  • about / Information Design Tool
• SAP BO Universe Designer Tool (UDT)
  • about / Information Design Tool
• SAP Business Objects
  • history / History of SAP Business Objects
• SAP BusinessObjects / Northwind
• SAP community network
  • URL / The main features of the IDT
• Save View as Image option
  • about / Save the view as an image
• search panel
  • about / Showing/hiding the search panel
  • showing/hiding / Showing/hiding the search panel
• Search panel
  • about / The search panel
  • using / The search panel
• Security Editor
  • working with / Working with the Security Editor
  • Universes / Profiles view / Universes / Profiles
  • Users / Groups view / Users / Groups
• Security Editor window, IDT interface
  • about / Security Editor
• security matrix
  • about / The security matrix
• security model
  • about / Understanding the security model
  • SAP BO IDT security model / Understanding the security model
• security profiles
  • about / Understanding the security model
  • Data Security Profiles / Understanding the security model
  • Business Security Profiles / Understanding the security model
• security restriction
  • about / Users / Groups
• Select property
  • about / The Select property
• Select Related Tables option
  • about / Select Related Tables
• self join
  • about / Self joins
• semantic layer
  • about / What is a semantic layer?
  • physical layer / What is a semantic layer?
  • business model / What is a semantic layer?
  • URL / What is a semantic layer?
• Set Case To option
  • about / Set Case To
• shared column
  • about / Joining tables
• shared project
  • about / Shared projects
  • creating / Creating a shared project
  • renaming / Renaming and deleting a shared project
  • deleting / Renaming and deleting a shared project
• shortcut join, Data Foundation
  • about / The shortcut join
  • properties / The shortcut join
  • example / The shortcut join
  • used, for fixing loop / Fixing the loop using the shortcut join
• Show Local Dependencies option / Show Local Dependencies
• Show Table Values... option
  • about / Show Table Values
• sights
  • URL / Hindsight, insight, and foresight
• single source Data Foundation
  • about / Single Source
• SMART
  • about / Gathering requirements
  • relevant / Gathering requirements
  • achievable / Gathering requirements
  • time bound / Gathering requirements
  • specific / Gathering requirements
  • measurable / Gathering requirements
• snowflake schema
  • about / The snowflake schema
• Source Information tab
  • about / Source Information
• SQL Definition tab
  • about / SQL Definition
  • properties / SQL Definition
  • Select property / The Select property
  • Where property / The Where property
  • Extra Tables property / The Extra Tables property
• SQL design traps
  • about / SQL design traps
  • examples / SQL design traps
  • fan trap / The fan trap
  • chasm trap / The chasm trap
  • loop / Loop
• SQL tab, Data Security Profiles
  • about / SQL
  • Query / SQL
  • Multiple Paths / SQL
  • Cartesian Products / SQL
• star schema
  • about / The star schema
• static list of values
  • about / Static list of values
  • creating / Static list of values
• Summary… button, advanced Business layer properties
  • about / Summary
• System Integrity Test (SIT)
  • about / SIT
  • test cases / SIT

T

• table's basic functions
  • about / The table's basic functions
• table's discovery and display
  • Count Rows... option / Count Rows
  • Show Table Values... option / Show Table Values
  • Select Related Tables option / Select Related Tables
  • Highlight Related Tables option / Highlight Related Tables
  • display modes / Display
  • Centre on Selection option / Centre on Selection
  • Show Local Dependencies option / Show Local Dependencies
  • Highlight Aliases option / Highlight Aliases
• table manipulation, Data Foundation object
  • about / Table manipulation
  • Add to View… option / Add to View
  • Edit option / Edit
  • Merge option / Merge
  • Delimit option / Delimit
  • Set Case To option / Set Case To
  • Replace by option / Replace by
  • Detect option / Detect
  • Change Qualifier/Owner... option / Change Qualifier/Owner
• tables
  • joining / Joining tables
  • auto-arranging / Auto-arranging tables
• tables, Data Foundation
  • about / Physical tables and views
  • inserting / Physical tables and views
• Tables tab, Data Security Profiles
  • about / Tables
• Teradata
  • URL / A foreign key
• theta join
  • about / Theta joins
• thick client / BI reporting tools architecture
• thin client / BI reporting tools architecture
• three-tier architecture model
  • about / The three-tier architecture model
  • characteristics / The three-tier architecture model
• Translation Management Tool
  • using / Multilingual Universes
• two-tier architecture model
  • about / The two-tier architecture model
  • database server / The two-tier architecture model
  • client-side application / The two-tier architecture model
  • characteristics / The two-tier architecture model

U

• Universe / Introduction to Universes and the Information Design Tool
  • about / Introduction to Universes and the Information Design Tool
  • components / Introduction to Universes and the Information Design Tool
  • connection / Introduction to Universes and the Information Design Tool
  • data foundation layer / Introduction to Universes and the Information Design Tool
  • business layer / Introduction to Universes and the Information Design Tool
  • creating / Creating your first Universe step by step
  • resources / Creating your first Universe step by step
  • project, creating / Creating a new project
  • data connection, creating / Creating a new data connection
  • Data Foundation, creating / Creating a new Data Foundation
  • business layer, creating / Creating a new Business layer
  • saving / Saving and publishing the NorthWind Universe
  • publishing / Saving and publishing the NorthWind Universe
  • creating, with Universe wizard / The Universe wizard
• Universe, promoting
  • BIAR file method / Promoting a Universe from one environment to another
  • Live to Live method / Promoting a Universe from one environment to another
• Universe development life cycle
  • about / The Universe development life cycle
  • requisites / The Universe development life cycle
  • phases / The Universe development life cycle
  • initiation phase / Initiation
  • planning and design phase / Planning and design
  • implementation and development phase / Implementation and development
  • quality assurance and testing phase / Quality assurance and testing
  • closing phase / Closing
• Universes / Profiles view
  • about / Universes / Profiles
• Universe wizard
  • about / The Universe wizard
  • used, for creating Universe / The Universe wizard
• UNV
  • converting, to Universe UNX extension / Converting UNV to the new Universe UNX extension
• Upgrade Management Tool
  • about / The Upgrade Management Tool
• User Acceptance Test (UAT)
  • about / UAT
• Users / Groups view
  • about / Users / Groups

V

• @Variable() function
  • about / @Variable()
• views, Data Foundation
  • about / Physical tables and views
  • inserting / Physical tables and views

W

• @Where() function
  • about / @Where()
• web intelligence (Webi) report / Northwind
• Windows Active Directory (AD) / Saving and publishing the NorthWind Universe