Answer / nisha

List Query is simple select Query
Where as Cross tab query will have group by function used.

List will show data in detail level.
Crosstab will show data in summarized level.

For ex:

List

Product Price Year
1A 12 2012
2B 10 2011
1A 23 2011
2C 45 2012
1A 50 2011

Crosstab
Year
Product 2011 2012
1A 73 12
2B 10 0
2C 0 45

Please explain the different stages in creating a report in cognos report net?

0 Answers  

---

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this

2 Answers  

---

how will optimiz the performance of sql in FM ?

2 Answers   Infosys,

---

write a query to display to 10 max record from the employee table?

8 Answers   HCL,

---

please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.

0 Answers  

---

how to create calculate column in report studio

4 Answers  

---

What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  

---

Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

0 Answers  

---

Interval Prompt's Usage? Example for usage in Project

2 Answers   Cap Gemini,

---

What is snapshot thumbnail

3 Answers  

---

What is main advantage datawarehousing over oracle?

0 Answers  

---

What is meant by alternate drill down with ex?

0 Answers  

---