Posts

IBM Cognos Transformer

Image
In this lesson, we will discuss The IBM Cognos Transformer IBM Cognos Transformer IBM Cognos Transformer is a simple tool for modeling dimensional hierarchies and levels for PowerCubes. We can use this data modeling tool or component to create a model, a business presentation of the information in one or more data sources. A model can contain any number of regular or calculated measures, together with logical groupings that use measure folders.     Cognos Transformer After you choose a supported product locale (language), add dimensional metadata, specify the measures(performance indicators) and apply custom views, you can create PowerCubes based on this model. You can deploy these cubes to support OLAP reporting and analysis.A regular measure is numeric data in a transactional data source. A calculated measure is new numeric data that is derived from other measures, functions, and constants, such as Profit, which is calculated from the measures Revenue and Cost.A measure...

Filters and its types in Cognos

Image
  Filter: It is nothing but a condition to restrict the data to be displayed on the report There are two types of filters Model filter Report filter Model filter: If a filter is created at the time of designing model then it is called a model filter Model filters are reusable Report filter: A filter which is created at the time of generating the report is called a report filter Report filter is specific to that particular report only Again model filters are two types Stand alone filter Embedded filter   Stand alone filter: It is created at name space level it is available as a separate object in the model It can be applied for any query subject in the model Stand alone filters are two types Static filter Dynamic filter (or) parameterized filter (or) prompt   Static filter: If a filter condition is created with a static value that can’t be changed at run time than it is called a static filter   Syntax to create static filter: Query time (column) operator operand. EX: ...

A Mobile Friendly Dashboard Using IBM Cognos Analytics

Image
  This article addresses how you can turn an existing dashboard that was built using IBM Cognos Analytics into a mobile friendly dashboard with only few steps. I will be highlighting a new extension that was recently released on the IBM accelerator catalog. The extension will work with IBM Cognos Analytics version 11.1.6. Download and install the mobile layout extension: Before we begin, you will need to download and install the mobile support extension from the IBM accelerator catalog. If you are not familiar with extensions, they are zip files that can be deployed in your Cognos Analytics environment and can be used to alter or add new functionality. I will be covering more about the IBM Cognos dashboard extensions in future articles, so stay tuned! After installing the extension, refresh your browser window and open the dashboard that you would like to turn into a mobile friendly dashboard.To learn cognos visit: cognos online training india Enable the mobile support in your...

IBM Cognos Metric Studio

Image
  IBM Cognos Metric Studio is the scorecarding and metrics tool in IBM Cognos Business Intelligence.Metric Studio is a performance tool for managing monitoring and analysing metrics, projects, and other performance measures within an organisation.  To more information visit: cognos online classes . It is used to create a scorecard application and monitor the metrics within the applications.It helps you ensure that your organisation’s performance is consistent with its targets and goals.You can use Metric Studio to create a customized scorecarding environment to monitor and analyze business metrics throughout your organization. A metric is a key performance indicator (KPI) related to time.In other words you use Metric Studio to monitor KPIs between one period and the next.A scorecard shows graphically how a metric is performing.This is typically done by using red, orange and green status notations. IBM Cognos Metric Studio IBM Cognos Metric StudioMetric Studio helps you tr...

IBM Cognos Event Studio Tutorials

Image
  Event Studio is a web-based component used to create and manage agents that monitor changes in data (aka events) and perform defined tasks when the event is detected. It is a core IBM Cognos BI component and uses the same data sources and administration and security infrastructure already defined in the IBM Cognos BI environment. It is installed as part of IBM Cognos BI.To learn complete course visit: cognos online training EVENT STUDIO CAPABILITIES Event Studio enables you to proactively detect and react to exceptional business events. As soon as these events are detected, using a business condition, you can do the following: • Notify stakeholders via email alerts or web portal headlines. • Run reports that can then be sent via email as a link or as an attachment. • Assign a task to someone for action. • Execute a stored procedure or initiate a web service. • Automate certain administrative tasks such as run an export or import or run a content maintenance task. Agents may also ...