Answer / nareshkumar

Aliases are references to existing tables in a schema. An
Alias is a table that is an exact duplicate of the original
table with a different name. The data in the table is
exactly the same as the original table. An alias breaks a
loop by using the same table twice in the same query for a
different purpose.

Answer / g.v.subramanyam

alias is logical popint to alternate to the table name.this
can be used to resolve the loops.

Answer / swades

An alias is a logical pointer to an alternate table name.
Exact copy of the original table.Establish a one-one join
between the original table and the table which is aliased.
The aggregatre results should be canned on to the aliased
table and not the original table.

Answer / vams_gk

alias is a logical table of existing look up table.using
alias we can resolve looops

Answer / raga

one user prefrom different roles is called alias


eg
two dept are there sales , HR
user of sales working in HR with different row is called
alias

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in

2 Answers  

---

When to use local filter and when to use global filter?

0 Answers  

---

what is fantrap and chasmtrap ?

5 Answers   Tech Mahindra,

---

what is report tracing in bo

5 Answers   Satyam, TCS,

---

---

hi,in crystal report xI after select stantderd report Data window appear when ever i click Repository folder it ask me system/user name and p/w and when ever i put my info it says:Tranport falier :comunication error,can any body tell me what to do i already reinstall this s/w 3 times(every thing is working with same user name and p/w like xcelsois,webi,deski,desinger,cmc u name it..thanks

0 Answers  

---

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers  

---

is there any way to know how long the report executes and how many records will be returned before hitting the "run" option?

3 Answers  

---

I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)

3 Answers  

---

Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)

3 Answers   BirlaSoft, TCS,

---

How many built-in objects are created in Business Objects repository?

2 Answers  

---

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  

---