Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10506 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the size of database for you project?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Can you define bitmap index?
how u will design the report if the objects are available
Define report item?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
what is the procedure for scheduling conditional rendering?
Can you define slice?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Explain the difference between native sql and cognos sql?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
----------------------What are the User Securities?
whats the difference between previous version of cognos and cognos 8 BI?
What are the advantages of using cognos sql?
What are shortcuts? Where it can be used? What are the advantages?
