1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

can we create aliases for every table beforehand? if yes
whar are the disadvantages?

Question Posted / sasikanth

Answers were Sorted based on User's Feedback



can we create aliases for every table beforehand? if yes whar are the disadvantages?..

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

can we create aliases for every table beforehand? if yes whar are the disadvantages?..

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

can we create aliases for every table beforehand? if yes whar are the disadvantages?..

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

can we create aliases for every table beforehand? if yes whar are the disadvantages?..

Answer / 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

can we create aliases for every table beforehand? if yes whar are the disadvantages?..

Answer / swati

What are the different datamodelling techniques?

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Business Objects Interview Questions

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  

How to make hilight the whole row by using ALERTS asof revenue is more than xxxxx?

1 Answers   Emphasis,

Can we have multiple domains?

3 Answers  

what is casual dimension?

1 Answers   CA,

what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,




what is canned universe and canned reports in bo?

1 Answers  

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

0 Answers   Arkema pte Ltd,

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  

What are different types of saving options in web intelligence?

7 Answers  

What are the Input and Output Context Operators.

4 Answers   Bosch, iNautix,

what is traffic lighting in business objects?

1 Answers  

what is main functional differences between BO and COGNOs?

5 Answers   TCS,

For more Business Objects Interview Questions Click Here
Categories