When we go for OLAP , and When we go for OLTP for
generating the reports ?

Answer Posted / mallikarjuna reddy

OLTPs are the original source of the data.OLAP data comes
from the various OLTP Databases

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...

1834


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

898


What we need to discuss with designer before starting the universe designing.

2021


Explain about a tricky situation for which you found a very simple solution?

743


Give some information on report bursting?

747


How many universes can be created in a project?

768


In banking domain how many Fact tables,Dimension table are present?

8566


Explain how many universes can be created in a project?

807


explain in detail about type 3?

784


Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1619


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3317


What is object stores?

751


Explain what sort of existing documents should business analysts refer to when starting on a new project?

782


what are the tables used in health care domain project and columns used in report?

4244


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1670