Courses

    Pages & Posts

      • IT Training
        • Amazon Cloud (AWS)
        • Analytics and Big Data
        • Blockchain
        • Cisco
        • Citrix
        • Cloud Computing
        • CompTIA Certification
        • Cybersecurity
        • Deep Learning and AI
        • Development Tools
        • DevOps
        • F5
        • FlexPod
        • IBM
        • IT Security
        • Java
        • Juniper Networks
        • Linux
        • Microsoft
        • Mobile Computing
        • NetApp
        • Oracle
        • Salesforce
        • VMware
        • Web Development, HTML, and JavaScript
        • WebSphere
      • Business Training
        • Business Analysis
        • Enterprise Architecture
        • HIPAA Certification & Training
        • IT Governance
        • ITIL® Certification
        • Project Management
        • Salesforce
        • Scrum & Agile
        • Seminars
      • Services
        • APM Practice
        • Authorized Cisco Training
        • BPM Practice
        • Distance Learning
        • ITIL Certification
        • Linux Certification Training
        • Media Security Solutions
        • Microsoft 365
        • Microsoft Official Courses On Demand
        • Microsoft Professional Program
        • NetApp Training
        • NIST Cybersecurity Framework
        • Salesforce Training
        • Training Facilities
        • Visual Studio TFS Training
        • Enterprise Training Solutions
        • Room Rentals
        • State & Local Government
      • Student Resources
        • Navigating Babbage Simmel Academy Courses
        • Ohio Workforce Training Voucher Program
        • Student Guide / Daily Schedule
        • College Credits / Tuition Reimbursement
        • Career Programs (WIA)
        • Student Policies
        • Testing & Certifications
        • Promotions
        • Local Hotels
        • Local Restaurants
      • IBM Cognos Transformer: Design OLAP Models (V10.2)

      Course Details

      Download PDF
      B-5282
      4 Days
      $3,095.00
      Request a Course Date

      IBM Cognos Transformer: Design OLAP Models (V10.2)

      Share this course

      Tweet Share
      IBM Cognos Transformer: Design OLAP Models (V10.2) is a four-day course that provides developers with knowledge of OLAP modeling concepts using Transformer. Participants will learn how to design, build, and maintain PowerCubes for use in IBM Cognos BI so that end users can easily analyze data.
      • Course Outline
      • Audience

      Course Outline

      Overview of IBM Cognos BI
      • Discuss IBM Cognos and Performance Management
      • Describe IBM Cognos BI components
      • Explain how to extend IBM Cognos BI
      Transformer Fundamentals
      • Discuss the basics of OLAP analysis
      • Review Transformer capabilities and its role in IBM Cognos 8 BI
      • Discuss Transformer components
      • Define categories and members
      The Transformer Development Process
      • Describe the purpose of a model plan
      • Match business requirements to the model
      • Discuss an approach for creating a model plan
      Data sources in Transformer
      • Discuss the types of data used by Transformer
      • Create data source files and define properties
      • Preview source data and SQL
      • Add IBM Cognos data sources to the model
      • Discuss data filtering
      Building a Model
      • Create model structures and modify property sheets
      • Confirm the data source origin
      • Generate categories to populate the model
      • Modify the model using the dimension diagram
      • Verify the model and create a PowerCube
      • Publish as a data source and package
      Considerations for Designing Successful PowerCubes
      • Describe model types and data entities
      • Define members and member unique names
      • Address changes that Impact a MUN
      • Discuss when category codes can change
      The Time Dimension
      • Define a regular time dimension
      • Examine standard and nonstandard time dimensions
      • Limit the range of valid dates
      Relative Time
      • Compare trends over time
      • Set the current period
      • Create relative time categories
      • Customize relative time categories
      Use Multiple Data Sources
      • Discuss the use of multiple data sources
      • Plan the data sources
      • Define data source types
      • Uniqueness
      • Identify and resolve conflicts between data sources
      • Validate a multiple data source model
      • Discuss a unique move
      Working with Measures
      • Discuss the purpose and uses of measures
      • Describe regular and calculated measures
      • Set measure properties
      • Compare rollup options
      • Create a calculated measure
      • Create calculations before or after rollups
      • Create a category count
      Allocated Measures
      • Discuss measure allocation
      • Allocate measures as a constant and by another measure
      • Check measure distribution
      Currency Conversion
      • Apply and use currency conversion techniques
      Alternate Hierarchies within a Dimension
      • Discuss primary and alternate hierarchies
      • Describe the benefits of alternate hierarchies
      • Create an alternate drill-down path
      • Define convergence levels and identify uniqueness issues
      Advanced Dimensional Modeling
      • Discuss techniques for customizing dimensions
      • Add a new source level to an existing dimension
      • Create a manual level in a dimension
      • Create orphan categories
      • Modify a dimension using a subdimension
      • Create a special category
      • Create a scenario dimension
      • Use calculated columns and categories
      Customize Cube Content
      • Create various types of PowerCubes
      • Omit dimensions and exclude measures
      • Create and apply dimension views
      Examine IBM Cognos Security
      • Examine the security environment
      • Identify the IBM Cognos BI security model
      • Define authentication and authorization
      • Identify security policies
      Applying Security
      • Review model security
      • Create custom views
      • Assign security to custom views
      • Assign custom views to PowerCubes
      • Combine custom views with dimension views
      • Examine a union of custom views
      Maintain Models and PowerCubes
      • Maintain models and PowerCubes
      • Understand data source, model, cube updates
      • Synchronize the model and data source
      • Incrementally update PowerCubes
      • Copy and activate a newer version of the PowerCube without affecting users
      Considerations for Drill Through
      • Identify conformed values between data sources
      • Discuss using drill through in IBM Cognos BI
      • Define a report drill through
      • Define a package-based drill through
      • Identify drill-through values
      • Discuss modeling recommendations
      Optimize PowerCubes
      • Examine cube groups
      • Plan for disk space
      • Optimize PowerCube inputs and outputs
      • Determine factors that affect PowerCube build time and user response time
      Partition PowerCubes
      • Identify the pros and cons
      • Develop a partitioning strategy
      • Create a time-based partitioned cube
      • Automatic vs. manual partitioning
      • Understand multi-file PowerCubes
      Blank Model Plans (Optional) Identify Common Data Structures (Optional)

      Audience

      This intermediate course is intended for Developers who design OLAP models for use in IBM Cognos BI.

      Related Courses

      IBM Cognos Framework Manager: Design Metadata...

      IBM Cognos Framework Manager: Design Metadata Models is a five-day, instructor-l...

      View course details

      IBM Cognos Report Studio: Author Professional...

      This course is designed for professional report authors to learn report building...

      View course details

      College Credit, CEUs, PDUs and CDUs
      When you take courses with the Babbage Simmel, be sure you get the credit you deserve. Curriculum offered by Babbage Simmel can earn you college credit, CEUs, PDUs or CDUs.

      College Credit
      Select curriculum offered by Babbage Simmel is part of the accredited Ashland University undergraduate course catalogs. For questions please E-Mail: info@babsim.com or call 614-481-4345.

      Continuing Education Units (CEUs)
      Continuing Education Units (CEUs) are nationally recognized standard units of measurement earned for satisfactory completion of qualified programs of continuing education. If you need more information about CEUs, please E-Mail: info@babsim.com or call 614-481-4345.

      Professional Development Units (PDUs)
      Professional Development Units (PDUs) can be issued by PMI® for formal learning activities related to project management. Project Management Professionals (PMPs®) are required to earn a minimum of 60 PDUs every 3 years to maintain certification. For more information about this program go to the PMI® web site or call 1-855 746 4849.

      Continuing Development Units (CDUs)
      CDUs may be earned by attending professional development (e.g. courses, seminars) offered by organizations endorsed by IIBA® and designated as an EEP vendor. As an IIBA Endorsed Education Provider (EEP) Babbage Simmel's IIBA® endorsed courses qualify for CDU credit. For more information about CDUs go the IIBA® web site or call 1-647-426-3735.

      Our babsimLIVE distance learning brings the classroom learning experience to you by seating you virtually into a real-life instructor-led classroom taught by award winning world-class instructors with other IT professionals like yourself. From the comfort of your home, workplace, or at the Babbage Simmel Columbus Campus, you acquire the training you need, when you want it, in the environment that is most comfortable for you to be successful.

      About Us Contact Us Blog Find A Course

      © Copyright 2019 • Babbage Simmel. All Rights Reserved. Columbus Web Design by Jetpack | Privacy Policy