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
- 10830 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
Define query items?
What is looping and how to avoid it in framework manager?
What is difference between content store and content manager?
5. Which type of report you build more, list, crosstab or chart and why?
What is the difference between a cascading report and drill through report?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How do you Parametermap variables in Quiries?
What are the advantages of cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
Can you define snapshot?
How to do Performence Tunning in Cognos Reports?
What is a Folder?
What are all the components of Report Studio?
how you migrate reports to cognos 8 from previous versions?
Explain what is the difference between native sql and cognos sql?
