What is OLAP?

OnLine Analytical Processing (OLAP) is a Business Intelligence (BI) reporting system. OLAP gives the user with the capability to sum, count, average and do other easy arithmetic operations on groups of data. An OLAP report has calculates and dimensions. Measures are the data values to be displayed. Dimensions are characteristics of the measures. OLAP reports are known as OLAP cubes, although such reports are not limited to three dimensions.

 

Posted Date: 7/4/2013 9:18:20 AM | Location : United States

Ask an Expert

Related Discussions:- What is olap, Assignment Help, Ask Question on What is olap, Get Answer, Expert's Help, What is olap Discussions

Write discussion on What is olap
Your posts are moderated

Write your message here..

Related Questions

Need for client server computing, Need for Client Server Computing- Client/... Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

What is relational model feature, What is relational model feature? A r... What is relational model feature? A relational model feature is much more data independence than some other database models.

What is database files , The database files accept the actual data and ... The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

What is called an evaluation primitive, What is called an evaluation primit... What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.

Explain what is aggregation, Explain what is Aggregation? Aggregation:... Explain what is Aggregation? Aggregation: Aggregation is an significant concept in database design whereas composite objects could be modelled during the design of database a

What is trigger, What is trigger?  Triggers are statements that are exe... What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

Case study, what problems are raised by the database? why is it so controve... what problems are raised by the database? why is it so controversial? why is data quality an issue?

What is use of generating such tables, What is use of generating such table... What is use of generating such tables? How can you create temporary tables? When you require a table only for a short time after that you want it to disappear automatically you

Prove that a relation which is 4nf must be bcnf, Prove that a relation whic... Prove that a relation which is 4NF must be BCNF.   Ans Let R be in 4NF.  Suppose it is not in BCNF.  Hence, there exists an FD X→Y in R such that x is not a super key. Although

Create a database model, Submit the table creation statements (including co... Submit the table creation statements (including constraints) for the Database Model. Submit them all in a single script file. Also submit a document explaining what test data yo