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
Answer Posted / 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 |
Post New Answer View All Answers
Why cognos decision stream is used?
Explain difference between powerplay transformer and power play reports?
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 to merge 2 crosstabs thans
How do you improve the performance of the Cognos Analytics report
what are the names of the reports that you prepared?
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.
-----------------What is Determination Model?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
What is the information present in the cognos configuration file?
Explain what is the main advantage of impromptu over cognos reportnet?
What are the advantages of shortcuts?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What is the difference between set functions and filter function in dimensional data?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?