Answer / 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

How to move reports one server to another server?

2 Answers   Wipro,

---

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

1 Answers   IBM,

---

how can i provide security to my reports in report studio?

3 Answers   TCS,

---

Write some methods to apply securities in framework manager model?

0 Answers  

---

I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'

2 Answers   Cap Gemini,

---

What are the other methods working as deployment functionality?

0 Answers  

---

Use of Text Source Variable in Report Studio?

2 Answers  

---

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

0 Answers   Bank Of America,

---

what is an sid (surrogate key)?

2 Answers   IBM, Oracle,

---

can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  

---

Define query items?

0 Answers  

---

how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance

0 Answers   HCL,

---