Answer / saurabh

In my understanding you have to use deski not webi for free hand sql .in deski there is no bar for this you can design on your own way....not possible in webi (even if u use custom query also)

Answer / gowthami

You can get the 7th column data also in the report by using free hand sql by following the below steps
assume name of the 7th column is "new"
1.Add some dummy object and go to sql and remove the dummy object field name and put your actual "new" field name

1a. if the dummy object and "new" column is from same table
then no need to change the where clause of sql query
1b. if the dummy object and "new" column is not from same table then need to update the correct join condition in where clause of sql query
2. check 'donot generate sql query based on the result objects'
3.run the report

this way is not advisable. you have to create a object in universe and use it in a report

How to implement LDAP authentication in BOE

1 Answers   Infosys,

---

what are the day to day activities of BO administrator ?

0 Answers   TCS,

---

Which versions are used in the bo dashboard work?

0 Answers  

---

how we improve the performance of report and universe?

4 Answers   Accenture, IBM,

---

What are the advantages of setting up LOVs in the Universe?

2 Answers   Cap Gemini, Deloitte,

---

What Is Snow Flake Schema?

0 Answers   Informatica,

---

How toconnect one to one report?

4 Answers   iFlex,

---

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

---

What is drill across ? can anybody explain me in detail?

1 Answers  

---

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 Answers  

---

What is package in BO

0 Answers   Infosys, Saksoft,

---

Example of how the fantraps and chasm traps works?

1 Answers   IBM,

---