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
What Is Snow Flake Schema?
What task is 98% of the required work of a business analyst?
What we need to discuss with designer before starting the universe designing.
What is thumbnail?
how get the grand total in master-detail report?
Explain what task is 98% of the required work of a business analyst?
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.
How to generate the report from excel sheet?
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...
What is report template in b.o?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
In banking domain how many Fact tables,Dimension table are present?
please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.
Explain when we use aggregate awareness function in designer?
Explain is there any default username & pwd for bo designer & supervisor?