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


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1751


What sort of existing documents should business analysts refer to when starting on a new project?

626


What task is 98% of the required work of a business analyst?

582


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3291


How to create Index to the table in the universe designer and how it improves the Query performence

2126






how to prepare the documentation in business objects and where to get the requirement?

1789


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

604


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

939


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1763


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

516


What is the functional & architectural differences between business objects and web intelligence reports?

564


Explain what is aggregate table and aggregate fact table ... Any examples of both?

616


How to restrict password to a user while sending a document in .pdf format

1867


Explain is it the job of a business analyst or systems analyst to draw the class diagram?

595


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

559