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 is ment by For each For all function. In which case we use the option in BO?

2 Answers   IBM, TCS,

---

What are the major problems will occur while migrating to the one version to another version?

2 Answers   CTS,

---

how will you move the universe/report from development to production?

3 Answers   TCS,

---

IS THERE ANY OTHER TOOL AVAILABLE TO DESIGN/CREAT UNIVERSE? EXCEPT UNIVERSE DESIGNER

3 Answers   IBM, TCS,

---

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,

---

WHO ARE THE USERS OF THE REPOSITORY?

6 Answers   AG Technologies,

---

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

1 Answers  

---

how to connect one to one report? Explain with example?

5 Answers   TCS,

---

What is the difference between datawarehousing and businessintelligence?

0 Answers  

---

How to hide objects or columns?

6 Answers   Infotech,

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

0 Answers  

---

What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,

---