Course Content
- Introduction to Cognos
- Cognos products
- Cognos BI
- Open data access virtually connects to any
- Studios (Query, Report, Event, Analysis, Metric, Powerplay)
- Transformer
- Cognos Connection (Navigation, Delivery, Administration)
- Environment
- single server or distributed
- physical or virtual
- database server content store
- data access/sources
- security AD, LDAP
- Software installation - Configuration
- Backup DR / maintenance
- FM setup Dev, QA, Prod
- Transformer - Bridge
- Tools
- Framework Manager FM
- Data sources
- Multiple data sources in FM Powercube, SAS, BW or DMR
- Stored procedures
- Modeling
- Packages
- Transformer
- Cube
- Relative time
- Dimensions, levels, categories
- Measures
- Cube
- Studios
- Analysis studio (Analyst tool)
- Slice and dice
- Query Studio (Adhoc or quick & dirty)
- Features
- Create report
- Report Studio
- Express edition
- Professional edition
- Introduction to Report studio
- Types of Reports list/crosstab/chart or dashboard etc
- Features bursting
- Page Explorer
- Query Explorer
- Condition Explorer
- Source, data item & tool box tabs
- Menu tabs (File, Edit, Data, Run, Tools etc)
- Objects
- Object Properties
- Page design and page structure
- Report specification, XML definitions
- SQL/MDX
- Query
- Union, Join, SQL etc
- Filters detail & summary, Slicer
- Data Items, Expression builder
- Functions, parameters, auto fields
- Summarization aggregate
- Drill through
- Master detail relationship
- Graphs
- Trouble shoot techniques
- Bursting
- Intro to Dimensional reporting
- Event Studio
- Setting up events
- Managing events
- Analysis studio (Analyst tool)
- Framework Manager FM
- Trade Secrets, tips and tricks
- DR Strategy
- User roles/groups & administration
- Multi value macro Java technique
- Source Code repository