Can any please explain FOR EACH AND FOR ALL?
- 2 Answers
- 22733 Views
- HCL, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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>
| Is This Answer Correct ? | 20 Yes | 0 No |
Post New Answer View All Answers
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Can we create universe with no cache??
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
How to execute the plsql procedure from the report by clicking with mouse?
Explain about a task that really tested your analytical abilities?
What is the difference between datawarehousing and businessintelligence?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How to restrict password to a user while sending a document in .pdf format
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Explain what is the difference between slice and dice and cross tab report?
When to use local filter and when to use global filter?
Is there any other repository domains rather than universe, security, document?
Difference between zabo and webi?
what is xcelsius architecture?
In banking domain how many Fact tables,Dimension table are present?
