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 did u give developed universe to ur client?

1 Answers  

---

Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.

2 Answers   TCS, Wipro,

---

What is a bo repository?

0 Answers  

---

How we can add a comment in universe...?

1 Answers  

---

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  

---

---

Example Country Name is like India/UK or ALL In parameter I selected India or UK it should show only perticular country details in BO.If i select ALL in parameter.It should show both country data in different tables.

6 Answers   TCS,

---

in xir2 how to send reports to end user

2 Answers   TCS,

---

how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how

3 Answers   Keane India Ltd,

---

Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:<servername>/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

0 Answers  

---

When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?

2 Answers  

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

Analysis in business objects?

4 Answers  

---