1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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.

Question Posted / coolani


2. We have asked to create a repots showing sales by region in order to determine which regions ar..

Answer / Vishal Ruhela

In Cognos, you can create a cross-tab or a list report with sales data grouped by region, category, and subcategory. Use aggregate functions like SUM() for revenue and COUNT() for quantities. You can use filters to focus on specific regions and subcategories.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

How to create a Ratio in Cognos Report studio Reports?

1 Answers   IBM,

what is the main advantage of impromptu over cognos reportnet?

1 Answers  

What is the use of Generated Prompt? Where is it used in realtime project?

3 Answers   HCL,

What are user classes?

1 Answers   HCL,

I have the below IBM COGNOS 8 Certification latest Dumps: COG-112: IBM Cognos 8 BI Author COG-122: IBM Cognos 8 BI Administrator COG-125: IBM Cognos 8 BI Data Warehouse Developer COG-132: IBM Cognos 8 BI Metadata Model Developer COG-135: IBM Cognos 8 BI OLAP Developer COG-145: IBM Cognos 8 BI Multidimensional Author COG-180: IBM Cognos 8 BI Professional Recently new questions also have been updated in this Dump. If interested,mail me on kris.bi121@gmail.com with Exam Code and Exam name

37 Answers   Cisco, L&T,

is there any difference between operational database and data base?if yes what r they?

1 Answers  

How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.

4 Answers   TCS,

faq's on cognos

0 Answers  

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

2 Answers   TCS, Tech Mahindra,

What are the best practices while building a Cognos Framework Manager Package ? As in, what calculations would you not like to be handled in FM and rather get it directly from Database.

3 Answers  

how u migrate the reports from impromptu to reportnet???

3 Answers   Wipro,

How to upgrade drivers in Cognos 8?

1 Answers  

For more Cognos Interview Questions Click Here
Categories