These are few Interview questions i faced.I hope to get help here. 1.Can we

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

Question Posted / vinod

4 Answers
10667 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab ..

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

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab ..

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

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab ..

Answer / raja

10. Types of Variable are

Boolean
String
Language

Is This Answer Correct ?

3 Yes

0 No

These are few Interview questions i faced.I hope to get help here. 1.Can we convert a Crosstab ..

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

Post New Answer