Answer / vidya

Yes in general we divide the data for ER modeling as master
and detail(transaction) data.

Master data will always be normalized in OLTP system, this
data need changes over course of time not often.

Example: Employee Database
Scenario: Change of Address,Location,active or inactive...

Warehouse is brought into picture only to denormalize these
data using keys concept

Same Example: Employee Database
Scenario: how many visits to onsite has the employee made
for the past 1 year.

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,

---

what is incompactabulity error in sap bo

2 Answers  

---

What is a category?

3 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,

---

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

---

I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )

6 Answers   Exilant, Siebel,

---

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,

---

what do u mean by variable functions ?

2 Answers  

---

What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.

3 Answers   Collabera,

---

Why do we need metrics and sets?

1 Answers  

---

what is zero client and thin client ?

3 Answers   Tech Mahindra,

---