can we create aliases for every table beforehand? if yes
whar are the disadvantages?
Answers were Sorted based on User's Feedback
Answer / saranv
In the Designer you can create allias for the table. U had that option in menu
bar.You just select the table and type the alias name. This is used to avoid some
looping and trap problem.
Other than Complex univese structure i dont no about the disadvantage
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / satishe
u can create alias for very table but its better not create
alias for fact tables.If unnecassarily alias are created
for evey table the universe structure will be complex.so
more number of tables will be present in your schema.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / kiran
There are no any disadvantages for creating aliases..it is
good practice in the projects to create aliases for all the
original db tables and create joins between them, rather
than using original db tables..when we do intigrity check
on this universe it throws all the errors that those
original tables have no joins ...this is the only problem
what I see, by creating aliases..
other then that aliases are used to resolve loops and traps.
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain the SQL Queries activated to data base from Data provider in BO ?
11.what are the features in BO?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
What happens in BO when a user logs in to Infoview and a rich client like webi?
Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?
what is universe null
What are the steps to taken care to improve the Report performance?
how to link 3 fact tables
what is meant by report busting
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
What is a Set?
whats the diff between break and section