About Ibm Cognos Framework
Getting Start with IBM Cognos BI
- Discuss IBM Cognos & Performance Management
- IBM Cognos components
- Describe IBM Cognos architecture at high level
- Define IBM Cognos groups & roles
- Explain how to extend the IBM Cognos
Identifying the Common Data Structures
- Examine the characteristics of operational databases & databases designed for reporting
- Examine relationships & cardinality
- Identifying the different data traps
- Examine the dimensional data sources
Requirements
- Examine the key modeling recommendations
- Define reporting_requirements
- Explore the data sources to identify data access strategies
Create an Baseline Project
- Examine the IBM Cognos BI & Framework Manager workflow processes
- Define an project and its structure
- Describe the Framework Manager environment
- Create an baseline project
- Enhance the model with the additional metadata
Prepare_Reusable Metadata
- Identify facts & dimensions
- Examine relationships, & data traps
- Verify relationships & query item properties
- Efficient filters by configuring prompt properties
Model for Predictable Results_ Identify Reporting Issues
- Describe multi-fact queries & when full outer joins are appropriate
- How IBM Cognos BI uses the cardinality
- Identifying the reporting traps
- Use tools to analyze the model
Model for Predictable Results_Virtual Star Schemas
- Identifying the advantages of modeling metadata as an star schema
- Model_ layers
- Create aliases to avoid the ambiguous joins
- Merge query subjects to create the view behavior
Model for Predictable Results_ Consolidate Metadata
- virtual facts to simplify the writing queries
- virtual dimensions to resolve the fact-to-fact joins
- Create an consolidated modeling layer for presentation purposes
- Consolidate snowflake dimensions with the model query subjects
- Simplify facts by hiding the unnecessary codes
Calculations & Filters
- Use calculations to create an commonly-needed query items for authors
- Use static filters to reduce data returned
- Use macros & parameters in calculations and filters to dynamically control the data
returned Implement an Time Dimension
- Make time-based queries simple to author by implementing an time dimension
- Resolve confusion caused by multiple relationships between an time dimension & another table Specify_ Determinants
- Use determinants to specify multiple levels of granularity & prevent double-counting
Creating Presentation View
- Identify the dimensions associated with an fact table
- Identify conformed v/s. non-conformed dimensions
- Create star schema groupings to provide authors with the logical groupings of query
subjects
- Rapidly create n model using the Model Design Accelerator
Working with Different Query Subject Types
- Identify key differences & recommendations for using data source, model, & stored procedure query subjects
- Identify the effects on generated SQL when modifying query subjects, SQL settings & relationships Set Security in Framework Manager
- Examine the IBM Cognos BI security environment
- Restrict the access to packages
- Create & apply security filters
- Restrict access to the objects in the model
Create_Analysis Objects
- Apply dimensional information to the relational Metadata to enable OLAP-style queries
- Define members & member unique names
- Identify changes that impact an MUN
- Sort members for presentation & predictability
Manage The OLAP Data Sources
- Connect to an OLAP data source (cube) in an Framework Manager project
- Publish OLAP model
- Publish an model with multiple OLAP data sources
- Publish an model with an OLAP data source & a relational data source
Advanced Generated SQL Concepts & Complex Queries
- Governors that affect the SQL generation
- Stitch_query SQL
- Conformed & non-conformed dimensions in generated SQL
- Multi-fact & multi-grain stitch query SQL
- Variances in Report Studio generated SQL
- The Dimensionally modeled relational SQL generation
- Cross join Of SQL
- Various results sets for the multi-fact queries
Use Of Advanced Parameterization Techniques in Framework Manger
- Identify the environment & model session parameters
- Leverage session, model, & custom parameters
- Create an prompt macros
- Leverage macro functions associated with the security
Model Maintenance & Extensibility
- Perform basic maintenance & management on a model
- Remap metadata to the another source
- Import & link a second data source
- Run scripts to automate or update an model
- Create an model report
Optimize ,Tune Framework Manager Models
- Identify & implement techniques to optimize and tune your Framework Manager models
- Use Dynamic Query Mode in the Framework ManagerWork in an Multi-Modeler
Environment
- Segment & link a project
- Branch an project and merge results
Manage Framework Manager Packages
- Specify package languages & function sets
- Control the model versioning
- Nest_packages
Appendix A_ Employ Additional Modeling Techniques
- Leverage an user defined function
- Set the order of operations in an model calculation
- Externalize query subjects
- Prepare IBM Cognos 10 content for use as a data source in Transformer
- Use of external source control through Windows Explorer
Appendix B_Model Multilingual Metadata
- Customize metadata for an multilingual audience
- Appendix C_ Additional_Resources