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

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.

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.

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

Answer / swati

What are the different datamodelling techniques?

Please anybody tell me Is Data integration And ETL programming is same..? Thanks in advance....

3 Answers  

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

0 Answers  

Instead of cms which server you have to use?

2 Answers   CTS,

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

0 Answers   Infosys,

I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.

1 Answers   Accenture,

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

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

1 Answers   Emphasis,

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,

Differences between business objects and web intelligence reports?

0 Answers  

what is the difference between Ranking and sort-out in bo?

2 Answers   iNautix, TCS,

What is the pragma?

2 Answers  

How to change English language to Chinese in BO Desiner (Universe)?

5 Answers   iGate,