can we create aliases for every table beforehand? if yes
whar are the disadvantages?
Answer Posted / mahesh225
We cannot create alias for all tables.
Because alias will make extra table and extra join .This is one of the disadvantage .
For confirmed dimentions we cannot create a alias.
www.futuresoftworld.com
Thanks
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between user and versatile user?
Explain 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)?
What is top business?
How to create Index to the table in the universe designer and how it improves the Query performence
What are the steps to do to use alerts in bo?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain difference between zabo and webi?
What is a fantrap in business objects?
What is report template in b.o?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
What is the difference between business requirement document and use case document.
What is the profile and package?
what will be the contents for a functional requirements specifications
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain what sort of existing documents should business analysts refer to when starting on a new project?