Answer Posted / tarukhemu

Consider you have one dimension linked to two fact tables. One fact contains branch wise revenue and another fact contains branch wise sales. For example:
Fact 1: Branch Revenue
101 1000
201 2000
201 1500
Fact 2: Branch Sales
101 5
201 10
Now if you want to display Branch,Revenue as well as sales,then the data in report will appear as follows:
Branch Revenue Sales
101 1000 5
201 2000 10
201 1500 10

As per Fact 2,Branch 201 has Sales=10,but in report it displays Sales as 10+10=20,which is wrong.
Hence by looking at the report data,you can identify a trap.
Note: This is a case of Chasm Trap

Explain what are the steps to do to use alerts in bo?

1024

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1058

---

What is a bo repository?

988

---

Can we Save (save as) WEBI Doc as DESKI?

8035

---

What Is Snow Flake Schema?

1145

---

What is the difference between datawarehousing and businessintelligence?

1036

---

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

4942

---

Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

982

---

what is the difference b/w the refresh and buffered data?

2268

---

i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2043

---

Explain 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)?

977

---

How can you first report in Business Objects by using broadcast agent?

3001

---

How to restrict password to a user while sending a document in .pdf format

2272

---

What Is The Difference Between Oltp And Olap?

1065

---

Explain which versions are used in the bo dashboard work?

1039

---