Interested to Buy Any Domain ? << Click Here >> for more details...
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
Does full backup break log chain?
What is Federation and Federation Member?
What is clustered vs nonclustered index?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is Federation Root Database?
What are indexes in ms sql server?
What command is used to create a database in the sql server and how?
Explain “row_number()” in sql server with an example?
What is query optimizer in sql server?
How is foreign key related to primary key?
What happens if you delete a table that is used by a view?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
How to handle error or exception in sql?
What are the types of table?
What are the five characteristics of good data?
