Answer / joel rodrigues

Fact tables are tables with lots of measure values and are
uniquly identified by a key, also a fact table can have a
foreign key. For Example custumer fact table is connected
to loan fact table via customer_id, and each record in loan
fact table is uniquely identified by a primary key on
cod_acct_no. Similarly customer table can be connected to
Savings fact table through customer id.

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

Tell me the difference between cmc and cms?

4 Answers   Wipro,

---

What problems you have faced while creating an universe? tell me an incident and how you went about solving it?

1 Answers   Fidelity,

---

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

3 Answers   CTS,

---

Is there any other repository domains rather than universe, security, document?

0 Answers  

---

what is tuning of business reports ?

5 Answers   Business Intelligence Analytics, Oracle, TCS,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?

1 Answers   Virtusa,

---

1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?

2 Answers   TCS,

---

How to get the data from the two different sourcess

2 Answers   IBM,

---

Why do we need metrics and sets?

1 Answers  

---

IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?

1 Answers   AG Technologies,

---