Cognos page layers
![cognos page layers cognos page layers](https://performanagement.files.wordpress.com/2009/03/prompt1.jpg)
This method of modeling enables executing multi-fact, multi-grain queries ensuring a predictable, clean set of results. Conformed dimensions are dimensions used by multiple fact tables. The satellite tables represent the set of dimensions that can be used to look at the measures from different angles.īy using conformed dimensions, a "data warehouse bus is established. The central table represents the fact table and only contains numeric and additive measures. In every data warehouse a number of star schema's are present. In a data warehouse facts and dimensions are established and data is stored at the lowest granular level. The dimensionally modeled database is ideal for reporting and is often referred to as a data warehouse. How easily can the model be adapted to changing conditions and how easily can the user generate ad hoc query requests? Both questions can be answered by using star schema modeling. Model flexibility can be defined from two different points of view. Cube Designer is beyond the scope of this insight, but in the near future a new insight concerning Dynamic Cubes will be released. Cube Designer will model Dynamic Cubes, a recently introduced cubing technology that replaces Powercubes.Framework Manager is used to create relational and dimensionally modeled relational models (DMR), called frameworks.All end-user based tools are accessed from Cognos Connection. The metadata modeling tools within Cognos Business Intelligence are client-server applications. IBM Cognos 10 Business Intelligence uses 2 metadata tools: Framework Manager and Cube Designer. This enables the use of different databases even from different vendors- or OLAP cubes in a single semantic layer, enabling the ability to use these transparently in a single report. By using a single version of the truth and the use of consistent terminology, end-user productivity is increased as the self-servicing aspect of business intelligence is strengthened.Ī semantic layer can handle multilingual features and consolidate different database sources and/or OLAP cubes. This makes it very easy for a business user to create his own reports as the terminology used is very recognizable.īusiness users are insulated from underlying data complexity while IT maintains governance over the use of data sources. The semantic layer maps complex data into familiar business terms and shields cryptic database language from the end-user.
![cognos page layers cognos page layers](https://www.ibm.com/docs/cs/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_rptstd_fin.10.2.2.doc/rsbia_bia_usr_interface.jpg)
This representation hides database complexity to the end-user by creating an intuitive model. The purpose of a semantic layer is to create a business representation of corporate data. Analysis Studio (legacy product): perform multidimensional analysisĪll these tools share the same semantic layer built with IBM Cognos Framework Manager.Query Studio (legacy product): perform basic reporting using basic queries and formatting.Cognos Insight: do self-service analysis and share these insights with the enterprise.Event Studio: create agents to follow-up on triggers.Report Studio: perform advanced, pixel perfect reporting with complex queries.Cognos Workspace Advanced: perform multi-dimensional analysis and create basic reports.Cognos Workspace: build corporate dashboards using pre-made components.Each one has a specific functionality focus: IBM Cognos Connection will provide interaction with other modules from the Cognos family such as IBM Cognos Insight or IBM Cognos Controller.įigure 1: Cognos 10.2.1 Cognos Connection Portalįrom IBM Cognos Connection all the end user applications can be launched. The portal contains all available reports, analysis, dashboards and offers advanced sharing, publishing and security features. It provides a single point of entry for all corporate data and the tools to analyse this data.
Cognos page layers software#
Zero Footprint means no additional software or applets are installed on the client PC. IBM Cognos Business Intelligence Server offers report authors a single platform to create reports, dashboards, events and perform analysis on multidimensional data.Īll users connect to the Cognos BI server using a zero footprint web portal: IBM Cognos Connection. We thus are proud to present : "Best Practices in Modelling IBM Cognos 10.2 Semantic Layers".
Cognos page layers update#
Given IBM Cognos 10 now is on the market for a while, we decided to update the Insight to incorporate new IBM Cognos 10 functionality. Since then, this page has become the most visited page on our website, with over 50.000 pageviews since publication, clearly showing the need for the topic. In October 2008, we published the Insight " Best Practices in Modelling IBM Cognos 8 Semantic Layers" on our website.