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 the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

---

When any new universe changes are deployed how does the end user get the view of the new classes/objects added(aprt from specs doc)?

4 Answers   IBM,

---

Hi, Webi report is created using universeA and this report needs to be shifted to UniverseB.So when i am trying to change report to new universeB from edit query properties, the report just hangs at the point of changing source to target.The reports which hangs mainly are the crosstab reports that has large data and many formulas. Any help on this is much appreciated. Thanks

1 Answers  

---

What is the use of Surrogate Key in BO?

2 Answers   CTS, IBM,

---

There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance

1 Answers  

---

When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?

2 Answers  

---

12. Report is running very slow and How do you increase its performance? 13. In infoview, I want to provide the hyperlink to view the report in pdf format or other format. is it possible to do it. 14. There is one report and need to add new cloumns which are not there in database. what is your approach.? 15. Did you face any ambiguous queries and how do you fix it?

3 Answers  

---

When to use local filter and when to use global filter?

0 Answers  

---

Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance

1 Answers  

---

What is scope of analysis ?

3 Answers   L&T,

---

What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?

2 Answers  

---

what is universe

4 Answers   TCS,

---