When we go for OLAP , and When we go for OLTP for
generating the reports ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / jay
If we need most recent updated data in reports we go for OLTP
or else we go for OLAP.
| Is This Answer Correct ? | 4 Yes | 3 No |
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
how many user were there
I HAVE USED A PROMPT TO SELECT A COUNTRY IF I REFRESH THE REPORT IT HAS TO SELECT COUNTRY AS INDIA IN DEFAULT AND HAVE TO GIVE THE RESULT? HOW TO ACHIEVE THIS?
What is a universe?
i have 2 fact and 2 dimension tables in my universe . my question is how get the data with two fact tables in a report?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
How to create a report template BO XI R2
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
how many micro cubes can a report can have
U r project in which stage in implementation?
what is crosstab reporting,slice and dise and drill mode??