Answer / shamanth

Pivot option is available in Format -> Table -> Pivot.
By using this option we can pivot databy placing variables
in columns, rows or the body.We can drag a variable from on
e folder to another folder.

Also we can hide/show the variables/columns.

what is the difference b/w star and snowflack schema in dataware house?

8 Answers  

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  

---

any body can give hirarchy of bussness object...i mean who will see reports after reports developing is fineshed...then next....

2 Answers  

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

---

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1 Answers  

---

How to get the data from the two different sourcess

2 Answers   IBM,

---

Difference between Decode and Case?

1 Answers   NIIT, TCS,

---

i want to use prompt for select the country names. eg, india. japan. america. like that. which delimeter is used for to seperate the countries?

5 Answers   TCS,

---

What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,

---

What is the use of Surrogate key in BO?

8 Answers   IBM,

---