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

Answer Posted / kkreddy

When we need more historical data we will opt for OLAP. And
when we need the real time data or current data we will opt
for OLTP.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What Is Snow Flake Schema?

670


What task is 98% of the required work of a business analyst?

586


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

1828


What is thumbnail?

584


how get the grand total in master-detail report?

1824






Explain what task is 98% of the required work of a business analyst?

610


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

3005


How to generate the report from excel sheet?

590


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1729


What is report template in b.o?

590


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

641


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

8385


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1541


Explain when we use aggregate awareness function in designer?

592


Explain is there any default username & pwd for bo designer & supervisor?

604