Answer Posted / babisri

There was a report for me in which I had to show 10 measures in a pie chart.

Solution- I have created a structure in Bex Query and by using the structure I made a new variable in BO which are the 10 sum of 10 measure and used the variable in report to show the 10 measure in pie chart.

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1203

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

1071

---

What is the profile and package?

2341

---

What is the difference between absolute and relative div positioning?

1095

---

Explain is there any default username & pwd for bo designer & supervisor?

1057

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1145

---

Explain when to use local filter and when to use global filter?

1401

---

How were the reports scheduled and how to resolve unexecuted documents?

2721

---

How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2342

---

In banking domain how many Fact tables,Dimension table are present?

8850

---

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1261

---

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

2196

---

Explain what task is 98% of the required work of a business analyst?

1171

---

If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?

2253

---

how to create metric universe ?

2399

---