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

What is the use of linling the universes?Thanks in advance

2 Answers  

---

Which command using Query Analyzer will give you the version of SQL server and operating system ?

1 Answers  

---

Any body help me...what are challenges did u face in Business object project?

1 Answers  

---

i am using Business Objects 6.1(a) facing a problem. ie when we save report in xls format then in xls sheet pictures are inserted into rep file are not come. Is it a bug. Give me answer as soon as possible. Thanks in Advance

3 Answers   TCS,

---

When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,

---

can any one say me exactly when and where alias and context are used in resolving a loop. If possible try to give me a scenario also.

3 Answers  

---

What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

1 Answers   Fidelity,

---

What is shortcut join?could give any one example?

8 Answers  

---

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

how to create a derived table in designer? i need steps regarding derived table

1 Answers  

---

what is confirm dimension ?

11 Answers   IBM, Wipro,

---

what is drill down?

5 Answers   TCS,

---