These are few Interview questions i faced.I hope to get
help here.
1.Can we convert a Crosstab to List?
2.How do you approach and who tells you what exactly the
way report has to be developed so that i meets the client
requirements?
3.Can we link the List and Chart thats created in the same
report?
4.Where do you edit sql in cognos8 ?
5.What is the difference between native sql and oracle sql?
6.What is the difference between MOLAP and ROLAP?
7.What is the use of BI in datwarehousing?
8.What are set functions?
9.How do you test a report?
10.What are the variables you find in toolbox?
11.How many types of filters are there in cognos8?
All the answers r welcomed .U can reach me at
vinod.davala@gmail.com
- 4 Answers
- 9255 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / alhad kulkarni
1. A List can be converted to Crosstab but, a Crosstab
cannot be converted to List.
2. This is a very broad question. No one line answer. But
to summarize, answer the following questions - a. What is
the client's business requirement? b. What does he want to
analyse? c. To do so, what functionality client might need
on the cognos report? d. Is the data good enough to fulfil
the cognos report functionality requirement? These set of
questions have much broader implications in terms of report
designing. It needs continuous client interaction to make
sure you are going in the right path.
3. Drill down to the Link/Chart can be specified.
4. tabular SQL. It is one of the components of the Data
Item.
5. Native SQL is what is fired on the database. The other
is Cognos SQL which is Cognos generated SQL to display the
result as per the toolbox item used on report.
6. Refer above answer post.
7. Again, broader question. BI in Datawarehousing is used
to provide interactive analysis to your data in order to
create a DSS (Decision Support System) for an organisation.
8. Union, Intersect, Except.
9. Broader question. There are various attributes to
testing a report - Data, Functionality and Look and Feel.
10. Variables are not there in tool box. They appear when
Condiotnal objects are used. Toolbox has tool objects to
develop reports.
11. Summary filter, Detail filter
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / venkatesh
1.its possible to convert crosstab tolist
because it will contain rows,colums and measures
sameinformation we will convert into list
2.based upon reportrequirement templet only we prepare
reports which repots the client want
3.yes we will link the list and chart using drillthrough
4. we edit sql in properties pane
5.MOLAP used to for cube development
rolap used for relational operations
6.BI datawarehousing used for bussiness opertions analysis
7.to running a report or validate a report
8.group filter,summery filter.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / raja
06.
MOLAP ROLAP HOLAP
MOLAP (multidimensional OLAP) tools utilize a pre-
calculated data set, commonly referred to as a data cube,
that contains all the possible answers to a given range of
questions. MOLAP tools feature very fast response, and the
ability to quickly write back data into the data set
(budgeting and forecasting are common applications).
Primary downsides of MOLAP tools are limited scalability
(the cubes get very big, very fast when you start to add
dimensions and more detailed data), inability to contain
detailed data (you are forced to use summary data unless
your data set is very small), and load time of the cubes.
The most common examples of MOLAP tools are Hyperion
(Arbor) Essbase and Oracle (IRI) Express. MOLAP tools are
best used for users who have "bounded" problem sets (they
want to ask the same range questions every day/week/month
on an updated cube, e.g. finance).
ROLAP (relational OLAP) tools do not use pre-calculated
data cubes. Instead, they intercept the query and pose the
question to the standard relational database and its tables
in order to bring back the data required to answer the
question. ROLAP tools feature the ability to ask any
question (you are not limited to the contents of a cube)
and the ability to drill down to the lowest level of detail
in the database. Primary downsides of ROLAP tools are slow
response and some limitations on scalability (depending on
the technology architecture that is utilized). The most
common examples of ROLAP tools are MicroStrategy and
Sterling (Information Advantage). ROLAP tools are best used
for users who have "unbounded" problem set (they don't have
any idea what they want to ask from day to day; e.g.,
marketing). It is very important to pay close attention to
the underlying architecture of ROLAP tools, as some tools
are very "scalability challenged."
HOLAP (hybrid OLAP) addresses the shortcomings of both of
these technologies by combining the capabilities of both
approaches. HOLAP tools can utilize both pre-calculated
cubes and relational data sources. The most common example
of HOLAP architecture is OLAP services in Microsoft SQL
Server 7.0. OLAP vendors of all stripes are working to make
their products marketable as "hybrid" as quickly as
possible. It is critically important to closely examine the
architectures of these "repackaged/repositioned" offerings,
as their "HOLAP" claims may be more marketing hype than
architectural reality.
| Is This Answer Correct ? | 3 Yes | 0 No |
Sales person are there in one company How to do Bursting on this particular requirement?
How to test a cube?
Can you define cognos decision stream?
hi guys, i think this would be a simple question but i was asked. what is total time taken to develop a report from getting requirement document from the client? dont reply as it depends,i am expecting something else.
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
Tell me about Schemas?
What are the different uses of a repository manager?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
---------------What is Dimension?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
Teradata 
