Answer Posted / kamal
OLAP
>Online Analytical Processing (OLAP) is a popular and
powerful data analytical method.
>It explores the complex data structure and presents the
information
OLAP functionality is:
• Multidimensional -- OLAP services provide a wide
variety of possible views or a multidimensional conceptual
view of the data by supporting a dimensional aggregation
path or hierarchies and/or multiple hierarchies.
• Easy to understand -- The data mart designed for
OLAP analysis should handle any business logic and
statistical analysis that is relevant to the application
and the developer, while at the same time, keeps it easy
enough for the target user.
• Interactive -- OLAP helps the user combine business
information through comparative,. The users are allowed to
define new ad hoc calculations as part of the analysis and
can report on the data in any desired way.
• Fast -- OLAP services are usually implemented in a
multi-user client/server mode and offer consistently rapid
responses to queries, regardless of database size and
complexity.
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is table join?
What is the use of toad or sqldbx.?
How to get @@error and @@rowcount at the same time?
How to edit table in sql server 2017?
do views contain data ?
How can I track the changes or identify the latest insert-update-delete from a table?
Explain primary key in sql server?
How to perform backup for certificates in sql server? : sql server security
How do I debug a stored procedure in sql server?
What is side by side migration in sql server?
What is logon trigger?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to assign new column names in a view?
explain declarative management framework (dmf) in sql server 2008?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
