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

Курсы 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 (Учебный центр в Украине).

 


Место проведения мероприятия: г. Киев пр., В. Лобановского, 4г Основы IBM Cognos BI: дополнения для разработчиков метаданных (V10.2) +380444922929
Время проведения: Уточняйте
Ссылка курса обучения
Назад в раздел





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

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

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

19.06.2017 Авторизованные курсы Microsoft на базе Учебного центра МУК


Учебный центр МУК - Silver Learning Partner Microsoft - приглашает всех желающих стать участником авторизованных курсов Microsoft согласно ближайшего расписания. 

01.06.2017 Открыт набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center»
Учебный центр МУК обладая статусом Silver Learning Partner Microsoft объявляет набор на курс «Виртуализация серверов с Windows Server Hyper-V и System Center», который состоится с 06 по 09 июня 2017 года.

21.05.2017 Снова лучшие: Dell EMC награждает МУК
Группа компаний МУК получила две награды на Dell EMC Partner Awards 2017

17.05.2017 HPE Education Brunch 2017
Учебный центр Группы компаний MUK при поддержке НРE Украина уже традиционно приглашает желающих стать участниками HPE Education Brunch 2017