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
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
is it possible to export the webi reports to crystal reports?with out using businessview?
How we drill up week to month?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain about a task that really tested your analytical abilities?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Did you face any problems while creating reports? Name? Solutions?
explain in detail about type 3?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
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 ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain what would you consider as your biggest achievement and why?
What is object stores?