Cognos BI Training: Report Studio and Authoring against Dimensional Data

PT16878
Training Summary
Dimensional Authoring Fundamentals with IBM Cognos Report Studio is a one-day, instructor-led course. Students will create dynamic reports against multidimensional data sources such as PowerCubes by leveraging best practices with Report Studio. Students will be exposed to multidimensional expressions, functions and prompting techniques. This is a fully interactive course. Participants will have practice performing the skills in our online classroom. The instructor is able to see each student’s computer screen and offer guidance. A full set of course materials is included and hard copies are sent prior to the class.
Prerequisites
There are no prerequisites for this course. However, it would be beneficial to be familiar with a web browser and comfortable with using laptops/PC’s and a mouse.
Duration
1 Day/Lecture & Lab
Audience
This course is designed for users who need to create and develop reports (authors) within Cognos Report Studio against a dimensional data source. This course is provided to give new users of Report Studio an overview of the user interface, together with an introduction to authoring techniques and functions used against a Dimensional (Cube) Data source.
Course Topics
Discuss and provide an overview of Business Analytics.
  • Overview of Cognos 10, covering Cognos Connection, common studio’s and Framework Manager
  • Introduction to the Report Studio interface and overview of workshops.
  • Utilizing and discussing various methods that can be used whilst building your reports.
  • Creation of basic reports, introduction to lists, crosstabs and charts within Report Studio.
  • Using insertable objects in your report and usage of various tools from within the toolbox. Creation of calculations and review of aggregation methods such as total, average, max, min…etc
  • Grouping and sorting your data.
  • Utilizing dimensional functions to assist with report development against a dimensional data source.
  • Creating hard coded and parameterized filters and the creation of prompts and prompt pages.
  • Setting up variables, general formatting and conditional formatting.
  • Utilizing and discussing various methods that can be used whilst building your reports.
  • Creation of queries, SQL/MDX overview and understanding queries.
  • Creation of Profit & Loss/Balance Sheet/Cash Flow report in Report Studio.
  • Course Review and Feedback.
  • Recap – Q/A and course review/feedback.

Related Scheduled Courses