Answer / g.v.subramanyam

data warehouse is used for to store the large volumes of
data.it can be used for future forecasting.it is the
collection of key pieces of information that can be used for
to take the dession by the managers.

Answer / handy

The main aim of data warehouse is in analyzing the large
volumes of data so that it can be helpful in taking business
decisions

Answer / vams_gk

for reporting one day details also enough.but analysis
means we need comparision means we need some old data is
called historical data.the data ware house saves historical
data ,we con't to any data base manuplations.


where is in normal databases we arte able to maintain some
extent of data .after that for entering new data u need to
delete the old data.

BUT in Data ware house u are able to stote years of records
no need to delete the old data

Answer / nameer

Datawarehouse(OLAP):
To store historical or years of data, we use datawarehouse.
So it will be usefull for managerial people to analyse
theire current scenario with old one and take some usefull
decision in the future to improve their business.
We load the data into datawarehouse using some ETL tool
which is called datawarehousing where as in normal database
we use insert operation. in datawarehouse no delete,update
or insert operation is used. Only select operation is used.
It uses the dimensional modelling(star or snowflake) schema
which will speed up the retrieval of data comapred to
ordinary database.

can we create aliases for every table beforehand? if yes whar are the disadvantages?

5 Answers   AG Technologies,

---

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 Answers  

---

in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.

3 Answers  

---

Instead of cms which server you have to use?

2 Answers   CTS,

---

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

2 Answers   NTT Data,

---

How to check for a particular value from one column with the list of values present in another column in Webi reports?

2 Answers  

---

without creating the business view is there possible to create & generate the Crystal reports?

3 Answers   TCS,

---

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

---

What are the Different Data Providers support in Web Intelligence and DeskTop Intelligence?

3 Answers   Perot Systems,

---

1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?

1 Answers   iGate,

---

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,

---

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---