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
How to create a simple table to test triggers in ms sql server?
Explain what is the difference between a local and a global temporary table?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How to identify current user in ssrs report?
What is an indexed view?
How can I check that whether automatic statistic update is enabled or not?
How can we determine what objects a user-defined function depends upon?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
Explain the ways to controlling cursor behavior?
What is NOT NULL Constraint in sql server 2012?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Explain syntax for viewing, dropping and disabling triggers?
Difference between LEN() and DATALENGTH() in sql server ?
What is stored in the mssqlsystemresource database? : sql server database administration
How to list all field names in the result set using mssql_field_name()?
