Каталог курсов

Курсы IBM

Основы IBM Cognos BI: дополнения для разработчиков метаданных (V10.2)

 
Код курса  Код: B5205    Заявка  Предварительная запись    Продолжительность  Кол-во часов: 16 , Кол-во дней: 2


IBM.gif 

Подробное описание курса.

Description

Essentials for IBM Cognos BI: Supplement for Metadata Modelers (V10.2) is an advanced, 2 day course thatprovides participants with introductory to advanced knowledge of metadata modeling concepts, and how tomodel metadata for predictable reporting and analysis results using Framework Manager. Participants willlearn the full scope of the metadata modeling process, from initial project creation, to publishing of metadatato the Web, enabling end users to easily author reports and analyze data.

Objectives


Please refer to course description.

Audience


This advance course is intended for Developers who design metadata models for use in IBM Cognos.

PreRequisites

Required:
  • Essentials for IBM Cognos BI (V10.2) (B5270)
  • Knowledge of common industry standard data structures and design
  • Experience with SQL
  • Experience gathering requirements and analyzing data

Topics


1. Work with Different Query Subject Types
  • Identify key differences and recommendations for using data source, model, and stored procedure
query subjects
  •  Identify the effects on generated SQL when modifying query subjects, SQL settings and relationships

2. Set Security in Framework Manager
  • Examine the IBM Cognos BI security environment
  • Restrict access to packages
  • Create and apply security filters
  • Restrict access to objects in the model

3. Manage OLAP Data Sources
  • Connect to an OLAP data source (cube) in a Framework Manager project
  • Publish an OLAP model
  • Publish a model with multiple OLAP data sources
  • Publish a model with an OLAP data source and a relational data source

4. Advanced Generated SQL Concepts and Complex Queries
  • Governors that affect SQL generation
  • Stitch query SQL
  • Conformed and non-conformed dimensions in generated SQL
  • Multi-fact/multi-grain stitch query SQL
  • Variances in Report Studio generated SQL
  • Dimensionally modeled relational SQL generation
  • Cross join SQL
  • Various results sets for multi-fact queries

5. Use Advanced Parameterization Techniques in Framework Manager
  • Identify environment and model session parameters
  • Leverage session, model, and custom parameters
  • Create prompt macros
  • Leverage macro functions associated with security

6. Model Maintenance and Extensibility
  • Perform basic maintenance and management on a model
  • Remap metadata to another source
  • Import and link a second data source
  • Run scripts to automate or update a model
  • Create a model report

7. Optimize and Tune Framework Manager Models
  • Identify and implement techniques to optimize and tune your Framework Manager models
  • Use Dynamic Query Mode in Framework Manager

8. Work in a Multi-Modeler Environment
  • Segment and link a project
  • Branch a project and merge results

9. Manage Framework Manager Packages
  • Specify package languages and function sets
  • Control model versioning
  • Nest packages

10. Appendix A: Employ Additional Framework Manager Modeling Techniques
  • Leverage a user defined function
  • Set the order of operations in a model calculation
  • Externalize query subjects
  • Prepare IBM Cognos 10 content for use as a data source in Transformer
  • Create query sets
  • Use external source control through Windows Explorer

11. Appendix B: Model Multilingual Metadata
  • Customize metadata for a multilingual audience

13. Appendix C: Access Additional Resources
  • Links to sites where the customer can find more information about course-related material.

Related


You may also be interested in the following courses
IBM Cognos Framework Manager: Design Metadata Models (V10.2.2) is designed to provide participants
with introductory to advanced knowledge of metadata ...

IBM Cognos Framework Manager: Design Metadata Models (V10.2.2) SPVC J2A52GSUA

Course materials for this course are available in:
  • English
  • Spanish (Latin America)
  • Portuguese (Brazil)
The course image is available in English only.
For the fully ...

IBM Cognos Report Studio: Berichtserstellung, Grundlagen V10.2 SPVC J22G8UA

 

Дополнительную информацию по учебным программам IBM в Украине вы можете получить на сайте: www.ibm.com/training/ua (Учебный центр в Украине).

 


Ссылка курса обучения
Назад в раздел





Для предварительной записи на курсы или
уточнения информации позвоните по телефонам:
(044) 492-29-29, 594-98-98
e-mail: training@muk.com.ua

Или заполните заявку online.

Свежие новости

20.11.2017 Расписание Учебного центра МУК 2018
До конца 2017 года осталось 6 недель, самое время начинать планировать следующий год

13.11.2017 Бесплатные практические вебинары MICROSOFT
Приглашение на бесплатные практические вебинары "Portal and billing MUK CSP" и "Trials and reseller’s Storefront" для партеров на базе Учебного центра МУК

06.11.2017 Со скидкой 20,18% на все курсы IBM с Учебным центром МУК в 2018 год

Планируйте курсы IBM на 2018 год вместе с нами до 31 декабря 2017 и получайте скидку 20,18%.

31.10.2017 HPE Education Brunch in Tbilisi 2017 собрал партнеров и заказчиков со всей Грузии

19 октября 2017 года прошло масштабное мероприятие - HPE Education Brunch in Tbilisi 2017 - организованное Учебным центром МУК Грузия совместно с Hewlett Packard Enterprise.