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

I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help

1 Answers  

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

---

how to schedule a report for even number dates?

2 Answers   HCL,

---

How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.

1 Answers   Cognizant, WinAlliance,

---

Explain the difference between union and group?

0 Answers  

---

---

What are @FUNCTION?

4 Answers  

---

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

2 Answers  

---

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,

---

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  

---

what is incompactabulity error in sap bo

2 Answers  

---

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

What is the sheduling the report? What is the need of sheduling the report?

1 Answers   Wipro,

---