Answer / santhosh

Fantrap means one-to-many joins of the tables it is
detected by visval analysis. By using fantrap problem is
many rows than expected. Through aliases,context and check
mutiple sql statements for each measures option we can
solve this problem.


chasm trap means two or more many to one joins converge on
to a single lookup table

Answer / krish

Chasam Trap:

chasm trap means many-to-one and one-to-many join relation
converge on to a single lookup table, because of this we
get incorrect results i.e., cartision product, We will
resolved by using some times alias, some times context,
some times shortcut join and check mutiple context for each
measures option.

Fan Trap:

Fantrap means one-to-many and one-to-many join relation of
the tables it is detected by visval analysis, because of
this we get incorrect results i.e., cartision product,
We will resolved by using some times alias, some times
shortcut join and check mutiple sql statements for each
measures option.

Answer / shiva

these two are the loop problems
fantrap-fanning out of one to many leads to one to many
relation ships
chasamtrap-converging two fact tables into single lookup
table
fantrap can be solved by alias
chasamtrap can be solved by context

Answer / nmr

fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.

Answer / nmr

fantarp is nothing but 2 one to many realation turned as 1
one to many realation.
the report doesn't get exact results ,
we can solve it useing contexts,
chasm trap 2 many to one realtionship tuned in to one
doesn't fetch exact results
we can solve the problem useing alias or context
based on require ment.

What are steps to be taken care to create a good Universe?

2 Answers  

what are cascading prompts explain with steps

4 Answers  

what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,

Any body help me...what are challenges did u face in Business object project?

1 Answers  

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,

What is the difference b/w the simple Universe and Complex Universe?

2 Answers  

How many universes are required for a single project,and how many reports are required for a single Universe.

2 Answers  

Is it necessary to give joins to the aggrigate tables in the universe?

2 Answers  

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

0 Answers  

can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?

3 Answers  

HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE

2 Answers  

Instead of cms which server you have to use?

2 Answers   CTS,