Question { 3457 }

Can some one explain in detail about the following:

What are Traps?
How to recognize the Traps?
How to solve them?

Answer

The are the causes for incorrect results in your reports.
There are two types of traps occurs in the universe, namely
chasm and fan traps.

chasm trap- it occurs when two many to one joins directs
from two fact tables and one end of the joins converges at
the same dimension table.
Because of this you will get inflatted results.

You user contexts to separate both the join paths to resolve
chasm traps.

Fan trap- it occurs when two one to many joins associates
with three tables in a series.
also effect the results same as chasm trap

you solve fan traps using aliases in general

Question { Wipro, 10593 }

Can some one say abt "ALL" in prompt ..

How to get the word "ALL" in the prompt along with the list of values?

Plz give me the steps?

Answer

could you elaborate your question. what exactly you need. do
you want to get the prompt message as ALL or what is it
exactly..