Below are the most common
questions that will give you brighter idea on Datawarehouse . Please refer and share your comments
Showing posts with label Cognos. Show all posts
Showing posts with label Cognos. Show all posts
Saturday, 27 October 2012
Data warehousing Concepts Interview Questions & Answers
Thursday, 11 October 2012
Difference between IBM Cognos and SAP Business Objects(BO)
COGNOS
|
BO
|
Divided
into many tools like Analysis Studio, Query Studio, Report Studio
|
All in one package- Web Intelligence
|
Appropriate
integration between all the tools
|
Many tools and no Proper Integration
between Queries, Excessive.
|
Metadata is
common to all tools, which offers performance and scalability
|
Flexible and Scalable
|
Separately
Structured Interfaces
|
Integrated Dashboards
|
Very clear
and service oriented Business Intelligence
|
Unclear BI future perspective because
of too many tools
|
Can be done
even with the basic End Users.
|
IT professionals needed for every
change
|
Loss of
Performance while scaling up the hardware
|
Performance is consistent while
Scaling UP
|
No proper
tool available to store the documents
|
Business Objects XI Info view is used
to store the documents.
|
Customers
feel Cognos is Complex
|
Customers complain BO is not fully
Business Intelligence yet.
|
Impromptu
is relatively weaker.
|
BO's adhoc reporting capability is
superior
|
Cognos
ROLAP Tools and MOLAP Cubes
|
BO is primarily ROLAP
|
Inbox drill
through from one report to other
|
Time Consuming Drill Through feature
|
Learning is
exhaustive because of many separate tools.
|
Learning is easy since many tools are
merged.
|
IBM Cognos Connection
IBM Cognos Connection is the portal to
IBM Cognos software.IBM Cognos Connection is the Web portal for IBM Cognos
Business Intelligence. IBM Cognos Connection provides a single access
point to all corporate data available in IBM Cognos software.
You can use IBM Cognos Connection to work
with entries such as reports, analyses, queries, agents, metrics, and packages
also to create shortcuts, URLs, and pages, and to organize entries. It is the
starting point to access your BI information.You can use IBM Cognos Connection to create
and run reports and cubes and distribute reports. You can also use it to create
and run agents and schedule entries. Cognos Connection provides a single access
point to applications so you can view and analyse your data. Use the portal to
Wednesday, 10 October 2012
IBM Cognos Report Studio
IBM Cognos Report Studio is a report authoring tool that professional
report authors and developers use to create sophisticated and managed reports. IBM Cognos Report
Studio is a robust report design and authoring tool. Report Studio is a full-blown report generation tool.
With
Report Studio, users can create any business intelligence report that an organization
requires, such as weekly sales and inventory reports, with any data source
(relational or multidimensional). Reports are written in XML which is an enhancement of the universal
web page mark-up language HTML. This means report users don’t have to install
any software on their desktops except a web browser such as Microsoft Internet
Explorer. Using
IBM Cognos Report Studio, report
IBM Cognos Framework Manager
IBM
Cognos Framework Manager is one of the most important component of IBM Cognos
BI Tool.I referred a lot for making this post.Hoping that this post will give
you valuable information about Cognos Framework Manager.
IBM
Cognos Framework Manager is the IBM Cognos BI modeling tool for creating and
managing business related metadata for use in IBM Cognos BI analysis and
reporting.IBM Cognos Framework Manager is the
metadata model development environment for IBM Cognos BI.
It is a Windows-based
client tool that you can use to create simplified business presentations of
metadata that are derived from one or more data sources. Framework
Manager can rapidly create relational and dimensional models through a guided
workflow driven modeling process , check the execution
path of the queries , define filters and
IBM Cognos Business Insight Advanced
IBM Cognos Business Insight Advanced provides a single, integrated
environment for advanced business users that allows
you to author simple reports and explore your data.
IBM Cognos Business Insight Advanced can
be used to perform deeper analysis and report authoring and also advanced data
exploration, such as adding additional measures, conditional formatting, and
advanced calculations.With Business Insight
Advanced, you can create
Tuesday, 9 October 2012
IBM Cognos for Microsoft Office
IBM Cognos for Microsoft Office can be used to work
with secure IBM Cognos BI content in Microsoft Office environment.
People that are more
comfortable with Microsoft Office can use Cognos for Microsoft Office to access
information using the office applications. IBM Cognos for Microsoft Office provides access
to all IBM Cognos report content, including data, metadata, headers, footers,
and charts. IBM Cognos for
Microsoft makes it possible for users to work with Cognos Business Intelligence
content in Microsoft Office applications. You can use predefined reports, or create new
content
IBM Cognos Business Insight
IBM Cognos Business
Insight is a Web-based tool that allows you to use IBM Cognos content and
external data sources like HTML and text sources to build interactive
dashboards which provides a good business environment for better decision
making.
In
Business Insight, objects that you add to a workspace are displayed in widgets. These widgets contain content and interact with each other. Business Insight is a new
WYSIWYG (What You See Is What You Get) workspace in which users can easily create and share interactive dashboards, modify
layout, colors, text, add notations or comments, create calculations and personalize widgets. You can view and open
dashboards and reports, manipulate the content in the dashboards and email
your dashboards. WYSIWYG is a user interface that allows
Wednesday, 3 October 2012
IBM Cognos Metric Designer
IBM
Cognos Metric Designer is the modeling tool used to create extracts for use in
IBM Cognos scorecarding applications.The created extracts are used to map and
transfer information from existing metadata sources such as Framework Manager
and Impromptu Query Definition (.iqd) files.
IQD
contains the query that a user can run against the database to get the data.An
Impromptu Query Definition describes a source table from
Monday, 1 October 2012
IBM Cognos Query Studio
IBM Cognos Query Studio is the
reporting tool for creating simple queries and reports in IBM Cognos Business
Intelligence.
Using IBM Cognos Query Studio,users can
quickly design, create, and save ad-hoc queries and reports to meet reporting
needs that are not covered by the standard, professional reports created in IBM
Cognos Report Studio.It can be used to create self-serve reports that answer
simple business questions.
IBM Cognos Map Manager
Using
IBM Cognos Map Manager you can now create new region layers from existing map
that contains region layers.Each new region within the new layer is made up of
one or more complete regions from the existing region layer.
When
the regions in the supplied maps do not correspond to the way information is
managed and reported you can use this new feature to customize maps.
However,
it is not possible to use portions of one region to form a new region.You can use
Map Manager to load an existing IBM Cognos map file,define the new region
layer, and then save the map with the new layer.
IBM
Cognos Map Manager can be used to;
- convert maps from non IBM sources
- assign alternate names for map features
- assign alternate languages for map features
Subscribe to:
Posts (Atom)
