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
What is exporting and importing utility?
What is outer join in sql server joins?
Can you roll back the ddl statement in a trigger?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Can a cursor be updated? If yes, how you can protect which columns are updated?
How to end a stored procedure properly in ms sql server?
What is CTE in SQL
What is the server name in sql server?
What are the advantages of user defined function?
Tell me what is normalization? Explain different forms of normalization?
What are the different methods available under sqlcommand class to access the data?
What is a raid and what are different types of raid configurations?
How to rename an existing column with sql server management studio?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is the impact on other user sessions when creating indexes?
