Answer / ojas

Scenariao: We have multiple cities and their respective
Population in a perticular State and Nation.

FOR EACH:
This is used when we want the total population for each
State. Then it will be:
Sum(<Population>)For Each <State>

FOR ALL:
This is used when we want the total population that
includes all the states. Then it will be:
Sum(<Population>)For All <State>

Answer / nameer

For Each :
Used to add the dimension to the calculation context.
eg: sum([sales_revenue] For Each ([quarter])) IN ([year])
For All :
Used to remove the dimension from the calculation context.
eg: sum([sales_revenue] For All ([quarter])) IN ([year])

what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?

1 Answers   TCS,

---

Can any please explain FOR EACH AND FOR ALL?

2 Answers   HCL, Infosys, TCS,

---

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers  

---

IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?

1 Answers   Accenture,

---

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

2 Answers   Accenture,

---

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  

---

i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)

0 Answers  

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

how to schedule a report for even number dates?

2 Answers   HCL,

---

What is the aggrigate navigation ? can anybody explain me with some practical example?

1 Answers  

---

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

5 Answers   Cap Gemini,

---

What is thin client And thick client..?

2 Answers  

---