Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can more than 1 metric be applied on an analytic in business objects?
Explain about a tricky situation for which you found a very simple solution?
What is the difference between condition & filter?
in sap bi we have wad, then why we go for sap bo
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Explain what are the steps to be taken to schedule the report?
What is the difference between business requirement document and use case document.
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Did you face any problems while creating reports? Name? Solutions?
Explain when to use local filter and when to use global filter?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
Explain what task is 98% of the required work of a business analyst?
