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])

Explain about a time when you discovered a more efficient way to do a work task?

0 Answers  

---

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

---

What is detailed Object

1 Answers   IBM,

---

Table A, Table B is there, that colums are different like tabl A contian (A varchar(9), B varchar(2), date), table B contian(D varchar(10), E varchar(2), F date) , i want 2 compare mismath datatype length in both table, how? do you know any in built function?

2 Answers   iFlex,

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

---

What are the types of errors you faced while creating a report from two different data providers

3 Answers   IBM,

---

What is DSS?? (Defination of DSS)

2 Answers  

---

explain about Prompt with example?

4 Answers   CSC,

---

WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?

1 Answers  

---

What happens in BO when a user logs in to Infoview and a rich client like webi?

2 Answers   TCS,

---

filename would be GCP_ARS_BO_TM_BERT MMDDYYYYHH24MISS.xls. how to do it?

2 Answers   IBM,

---

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,

---