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

IBM,

What is render variable?Where do you exactly use in developing a report?

IBM,

What are user classes?

HCL,

What is conditional Formatting?

HCL,

What are variable report studio?

HCL,

What snowflake and Starschema?

HCL,

How many fact tables you have in your project?

HCL,

Where do you edit cognos sql in report studio?

HCL,

what are burst options you have?

HCL, IBM, TCS,

Where do you set security levels for users in reports?

HCL,

What is content store?

HCL,

What is content Manager?

HCL, Kekran Mekran,

What is the complex report you faced in real time?

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

IBM,

can we join 2 different queries? One has 10 columns and other has 5+ columns?

IBM,