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
- 10718 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
explain how to create powerplay reports?
What are various types of gateways in cognos?
What are all the components of Report Studio?
What is the difference between low affinity and high affinity connections?
What do you understand by the term 'dynamic cube'?
Can you define report item?
9. What was the most complex type of report you dealt with?
How to select multiple values from type-in prompt?
--------------Diff b/w ODS and OLAP?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is an olap designer? describe the starschema grouping ?how can i add a new column
for existing report ,when it is not present even in model &
dataabase? 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.
Please explain the different stages in creating a report in cognos report net?
