Learn Cognos Bi report Presentation and multidimensional analysis

Learn Cognos Bi report Presentation and multidimensional analysis, Wang Xiaoqing Cognos senior presales Engineer

Comprehensive Bi Functions
Ad hoc query: queue Studio
Report: Report Studio
Provides various types of reports
Consistent output information of various types of reports
Personalized targeted Customization
Allow multiple users, multiple user groups, and protocols with it
It can be accessed by email, portal, office, search, and mobile devices.

Different functions of traditional bi products have different independent query engines, independent metadata management, and independent system management, the data obtained from the relational database query engine is different from the query engine used by OLAP data. Data inconsistency.

Cognos is an SOA architecture, web layer, application layer, data layer, and presentation layer. Strength: You can use the databases of various vendors as the data source, but it is a unified metadata modeling and consistent view.

Presentation Layer: all are pure web, and no plug-ins need to be downloaded. OLAP client and web.

The architecture minimizes deployment risks and supports flexible distribution and deployment. It can provide high-performance intelligent load balancing and make full use of the existing environment to predict the performance scale. You can also configure clusters for heterogeneous systems.

Flexible portal creation and support. Supports portlets and graphics, search, and navigation. Cognos provides 15 different portlets.

Ad hoc services, personalized reports, dashboard reports, production reports, and management reports.

Dimension reports: dimension awareness and automatic drilling. Supports multiple types of computing.

Analysis studio is a visualized multi-dimensional analysis presentation tool.
Powerplay is a client-side multi-dimensional analysis and presentation tool. The difference is that it can only be compatible with Cognos cubes, which is more efficient than analysis studio and optimized.

Data Lineage: Metadata tracing. When data is found to be incorrect, the source of the query data is incorrect. The fields or tables that can be traced back to the data warehouse. If you don't think it is enough, you need to know which business system is the cause of tracing? What should I do? One method is to integrate Cognos metadata with datastaage metadata.

Note:

IBM Infosphere datastage supports the collection, integration, and conversion of large amounts of data in a simple to highly complex data structure.

IBM Infosphere datastage
IBM Infosphere datastage is a core component of IBM Infosphere Data Integration suite that supports close integration of enterprise information regardless of the number of data sources, targets, and transient frameworks.

Whether you are building an enterprise data warehouse to support information needs of the entire company, building a "real-time" data warehouse, or integrating dozens of source systems to support enterprise applications, for example, Customer Relationship Management (CRM), Supply Chain Management (SCM), and enterprise resource planning (ERP), WebSphere datastage helps you ensure that you have information that can be trusted.

The most powerful solution in the industry
WebSphere datastage provides three key features required for successful enterprise data integration: the most comprehensive connectivity for easy and fast access to any data source or target system; advanced development and maintenance tools, it accelerates implementation and simplifies management. A scalable platform allows you to easily process today's large volumes of company data.

IBM Infosphere datastage supports the collection, integration, and conversion of large amounts of data in a simple to highly complex data structure. IBM Infosphere datastage manages the data that arrives within a few seconds after the acquisition, as well as the amount of data that flows through the system on a daily, weekly, or monthly basis.

The most comprehensive connectivity between the source and Target Systems
Infosphere datastage supports an unlimited number of heterogeneous data sources and targets in a task, including:

* Text Files
* Complex XML Data Structure
* Enterprise application systems, including SAP, Siebel, Oracle, and lelesoft
* Almost all databases, including partitioned databases, such as Oracle, IBM DB2 Universal Database (with or without data partitioning features), IBM Informix, Sybase, teradata, and Microsoft SQL Server
Web Services
SAS
* Integrated messaging and enterprise applications, including WebSphere MQ and seebeyond

The list is still being extended. As long as it appears in your enterprise, it will be supported. Full connectivity to IBM Infosphere datastage enterprise data sources means that you no longer need to develop and maintain the connection between custom code and your important data.

IBM Infosphere datastage packs supports:

* Seamless connection between the most widely used enterprise applications and the comprehensive data integration solution (IBM Infosphere Information Server.
* Rapid and automatic integration of enterprise data and metadata reduces deployment time and enterprise data integration costs.
* Use the GUI-driven drag-and-drop design in the IBM Infosphere datastage software to integrate with as many enterprise data sources as possible from SAP, Siebel, PeopleSoft, JD Edwards, and Oracle Applications.

Products include:

* IBM Infosphere datastage pack for Oracle Applications v2.2.0.
* IBM Infosphere datastage pack for JD Edwards performaniseone v1.5.0.
* IBM Infosphere datastage pack for lelesoft enterprise v3.1.0.
* IBM Infosphere datastage pack for sap r/3 v5.3.0.
* IBM Infosphere datastage pack for sap bw v4.3.0.
* IBM Infosphere datastage pack for Siebel v3.2.0.

Advanced Business Event Management. A task defined by a business event automatically starts the occurrence of business processing conditions, task execution, and event lifecycle to form a closed loop, which can be integrated with BPM applications.

Comprehensive report platform management. Activity management, report priority setting, security management, cluster configuration management, and scheduling management.

Integrate with the go office plug-in. Word, Excel, and PowerPoint. Use Excel for analysis

Supports BlackBerry and Windows moblie mobile phones. You can view and interact with each other, provided that the "prompt" is included ".

Cognos OLAP Server is divided by storage method:
Molap: stores multi-dimensional data in the cube. That is to say, the data on each intersection is calculated in advance, and the advantage is that the pre-calculated response speed is very fast, disadvantage: All analyses are based on cubes, which cannot be expanded infinitely.

ROLAP: Based on relational data blocks, OLAP is implemented through multi-dimensional models. Advantage: Query and analysis is oriented to the entire data warehouse and is not limited to cube. disadvantage: the performance depends on the performance of the data warehouse.

Hybrid product: combines m and R to put summarized data into the cube and detailed data in the data warehouse. Drill-through is used to obtain information, ensuring performance and comprehensive analysis sources.

Cube generation speed and compression ratio
File cube reduces database overhead
Supports time partition cube, which is transparent to business personnel. small cubes form a large cube to cope with growth.
Invalid Cube Storage
Reads data from heterogeneous data sources.

Cognos Development Process:
1. Framework Modeling
2. Create a metric in metric designer
3. Publish and update data packets in connection
4. data packets published in various functional modules
5. Manage Users in connection
6. Create a cube in Transformer