Answer / sivakumar

if you want to restrict the row manually.

Go to universe parameter and click on control tab and tick
the option limit size of result set to, and enter the row
(for ex : 1000), so ones you ran the report you can view
only thousand rows.

I am trying to save the XI report to CSV format. the csv file not displaying columns in order. all the columns are misplaced. the report size is 12MB Can any one tell me why the columns are incorrect position when XI report converted into CSV format?

3 Answers  

---

What is the pivot option ? what is the need of it?

1 Answers   Infotech,

---

Explain about MTD(Month To Date) and YTD(Year To Date) with one example and where you use this in your project?

2 Answers   TCS,

---

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  

---

GENARALLY WHAT ARE THE PROBLEMS ARE FACING WHILE CREATING REPORTS?

1 Answers  

---

Can anybody explain me ? without creating the alias can we resolve the fantrap?

4 Answers  

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---

What is Indexing? how did u implement indexing?

0 Answers   TCS,

---

What is the use of Surrogate key in BO?

8 Answers   IBM,

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

what is fantrap and chasmtrap ?

5 Answers   Tech Mahindra,

---

what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,

---