Answer / pk

Architecture of the project means..
1.Your Source and Target System.Source systems: like mainframe,oracle,people soft,db2.
2. Landing tables: these are tables act like source. Used
For easy to access, for backup purpose, as reusable for
Other mappings.
3. Staging tables: from landing tables we extract the data
Into staging tables after all validations done on the data.
4.Loading strategy like which u applied type 1,2 or 3.
5. Dimension/facts: these are the tables those are used for analysis and make decisions by analyzing the data.
6. Aggregation tables: these tables have summarized data
Useful for managers who wants to view monthly wise sales,year wise sales etc.

How to Avoid the overlaping the blocks in WEBI.

3 Answers  

---

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  

---

What are the steps to be taken to schedule the report?

0 Answers  

---

when and where we use @varialble function

1 Answers  

---

How we can add a comment in universe...?

1 Answers  

---

---

How do you restrict access to rows of a database?

2 Answers  

---

i want to take a report 10 records per page. How to take it? is there any paging option in BO?

5 Answers   Cap Gemini, IBM,

---

how many micro cubes can a report can have

3 Answers  

---

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  

---

what is difference between global filter an query filter in web intelligence?

3 Answers  

---

can anybody tell me how many classes where there and objects in each class

3 Answers  

---

Difference between scope of analysis in webi and in deski?

1 Answers   CA,

---