Answer / ravi kumar garre

One of the most interesting and valuable dimensions in a
data warehouse is one that explains why a fact table record
exists. In most data warehouses, you build a fact table
record when something happens. For example:

When the cash register rings in a retail store, a fact
table record is created for each line item on the sales
ticket. The obvious dimensions of this fact table record
are product, store, customer, sales ticket, and time.
At a bank ATM, a fact table record is created for every
customer transaction. The dimensions of this fact table
record are financial service, ATM location, customer,
transaction type, and time.
When the telephone rings, the phone company creates a fact
table record for each "hook event." A complete call-
tracking data warehouse in a telephone company records each
completed call, busy signal, wrong number, and partially
dialed call.
In all three of these cases, a physical event takes place,
and the data warehouse responds by storing a fact table
record. However, the physical events and the corresponding
fact table records are more interesting than simply storing
a small piece of rev enue. Each event represents a
conscious decision by the customer to use the product or
the service. A good marketing person is fascinated by these
events. Why did the customer choose to buy the product or
use the service at that exact moment? If we only had a
dimension called "Why Did The Customer Buy My Product Just
Now?" our data warehouses could answer almost any marketing
question. We call a dimension like this a "causal"
dimension, because it explains what caused the event.

what is prompt? Cascading prompt? Syntax

5 Answers   TCS,

---

How many universes can be created in a project?

0 Answers  

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

7 Answers  

---

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  

---

HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?

4 Answers   CitiGroup,

---

---

When is the Repository created?

1 Answers  

---

I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps

17 Answers   IBM,

---

What is a category?

3 Answers  

---

how can i add two different reports in the same document?

5 Answers   TCS,

---

Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?

2 Answers   HCL,

---

Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva

1 Answers  

---

which is the best way to resolve loop context r alias why?

3 Answers  

---