Answer Posted / the_xxx

RATIO_TO_REPORT

This rank function calculates the ratio of a value to the
sum of the values for the entire set.
Syntax

RATIO_TO_REPORT( numeric )

Parameters

*

numeric-- Any numeric data type expression, typically
a reference to a numeric column.

Return Type

DOUBLE PRECISION.
Remarks

Returns a number for each row in the set that is the row’s
ratio to the sum of the entire set. When expression results
in NULL, the function returns NULL. When the sum of the set
is zero (0), the ratio is also zero.

Note: This function cannot be used as an argument in a set
function, moving set function, or rank function. For
example, SUM(RATIO_TO_REPORT(...)) is illegal.
Example

Determine what percentage each product sales is to the total
sales of all products for the last 20 weeks:

SELECT prod_description DESC,

SUM(dollars) as sales,

RATIO_TO_REPORT( SUM(
li_amount )) * 100 AS ratio_dollars

FROM lineitem, product

WHERE lineitem.li_prod_id = product.prod_id

GROUP BY prod_description;

DESC SALES RATIO_DOLLARS

Widget 896931.15 12.88

Basket 514830.00 7.39

Football 507022.35 7.28

Oil Drum 503493.10 7.23

Computer 437863.00 6.29

Chair 429637.75 6.17

Desk 424215.00 6.09

Mesh Bag 421205.75 6.05

Shoelace 417261.00 5.99

Powder 397102.50 5.70

Telephone 394086.50 5.66

Cord 392377.75 5.64

Mouse 389378.25 5.59

Monitor 305859.75 4.39

Case 294982.75 4.24

Cup 236772.75 3.40

Which studio is used to create reports?

1058

---

What are the types of hierarchies?

968

---

what is log in cognos?

1139

---

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

905

---

What are the main services provided by application tier?

930

---

What is drill down and slicing and dicing whats the difference between them?

988

---

what is the difference between filter and condition?

1014

---

---------------Tell me about DWH Concepts?

2074

---

What is a Cube?

1077

---

What are query items?

971

---

How to select multiple values from type-in prompt?

1009

---

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

951

---

what are the features in cognos8ui

1990

---

what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us

2893

---

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2219

---