Posts

Dimensions & OLAP Types in Cognos

  Conformed Dimensions It is a dimension which is shared by multiple fact tables Ex: customer dimension, time dimension Fact Constellation It is a process of connecting multiple fact tables with PK-FK relationship Slowly changing dimension (SCD) A slowly changing is a dimensions which captures the changes occurs over a period of time There are three types of SCD’ SCD type1 SCD type 2 SCD type3 SCD type 1 It contain only current data SCD type 2 It maintain couple history and current data SCD type 3 It maintain partial history (or) recent history and current data Surrogate key It is a system generated key which access primary key in the dWH tools maintains the uniqueness. Interested in mastering Cognos Training? Enroll now for FREE demo on  cognos online classes OLAP and types of OLAP OLAP It is a interface (or) a gate way between the user and data source (dWH) (or) It is a set of specifications with allows the client application (report application) to query the data from data ...

What is Cognos reporting and its different services and components?

Image
  Cognos is business intelligence and performance management software. It enables business users to extract corporate data and analyze it without using any technical knowledge. It is also known as the Cognos reporting tool. It helps to prepare many corporate reports by analyzing data. These reports are presented in the format of graphs, pictures, diagrams, etc. Furthermore, this is more helpful for non-technical people to prepare reports based on the data.  Cognos reporting tool helps to make great business decisions by reading the reports. These reports are drawn by professional authors of report writing. They analyze and prepare complex reports with proper formatting. Moreover, it is a web-based tool. The Cognos reporting tool will help users in many ways. For more tutorial concepts visit: learn cognos online Cognos reporting tool The Cognos reporting tool is very helpful. Using the Cognos reporting tool, we can create many reports that any organization requires. Such as sta...

The IBM Cognos TM1 programming environment

  In this lesson, we will discuss The IBM Cognos TM1 programming environment The API is intended to give access to many of the features and functionality of the TM1 OLAP engine. The API is designed for use with Microsoft C, C++ and Microsoft Visual Basic. All the C functions are supported by Microsoft Visual Basic. However, some of the string and array value handling functions have a special version for Microsoft Visual Basic. You should use these functions if you are programming in Microsoft Visual Basic. For C and C++ applications, include the header file TM1API.H. For Microsoft Visual Basic applications, include the file TM1API.BAS. The API has been optimized for use in a networked environment. As a result, the conventions used vary markedly from those used in other Application Programming Interfaces you may be familiar with. For example, all values are passed as pointers or handles to  value capsules  that contain the actual data.   Location of the IBM Cognos TM1...

The Components of IBM CognosTM1

Image
  Types of components in Cognos Introduction The components of TM1 are divided into two basic types which are: Client components Sever components Most of these components are installed by default with a standard installation of the product, but some are not. To learn cognos Tm1 tarining visit: cognos tm1 course Client components Client components allow access to the tm1 Servers. During a default installation, the following Client components will be installed: TM1 Client TM1 Perspectives TM1 Architect TM1 API OLE DB Provider TM1 Client The TM1 (basic) client is accessed through Microsoft Excel as an Add-In and will allow limited access to available TM1 Servers. TM1 Client does not allow administrative access to any TM1 Servers. It does not offer the ability to set up and run a local TM1 Server. During the installation, a local version of TM1 Server is installed and can be accessed by TM1 Client, TM1 Perspectives, or TM1 Architect. Learn about  Cognos TM1 online  TM1 P...

What is Cognos reporting and its different services and components?

Image
Cognos is business intelligence and performance management software. It enables business users to extract corporate data and analyze it without using any technical knowledge. It is also known as the Cognos reporting tool. It helps to prepare many corporate reports by analyzing data. These reports are presented in the format of graphs, pictures, diagrams, etc. Furthermore, this is more helpful for non-technical people to prepare reports based on the data.  Cognos reporting tool helps to make great business decisions by reading the reports. These reports are drawn by professional authors of report writing. They analyze and prepare complex reports with proper formatting. Moreover, it is a web-based tool. The Cognos reporting tool will help users in many ways. To learn complete IBM Cognos course visit ITGuru learn cognos online Blog Cognos reporting tool The Cognos reporting tool is very helpful. Using the Cognos reporting tool, we can create many reports that any organiza...