![]() ![]() |
|
Process Analyzer User Guide | |
Search | Index | |
![]() |
|
![]() |
![]() |
![]() |
Online Transaction Analysis Processing (OLAP) overview(On-Line Analytical Processing) is a technology that uses multidimensional structures to provide rapid access to data for analysis. OLAP enables analysts, managers, and executives to gain insight into data through fast, consistent, interactive access to a wide variety of possible views of information. OLAP transforms raw data so that it reflects the real dimensionality of the enterprise as understood by the user. are inherently representative of an actual business model. Rarely is a business model limited to fewer than three dimensions. Managers typically look at financial data by scenario (for example, actual vs. budget), organization, line items, and time; and at sales data by product, geography, channel, and time. How does OLAP organize its data?OLAP organizes data into cubes, dimensions, and measures. A is a set of data that is organized and summarized into a multidimensional structure defined by a set of dimensions and measures.A is an organized hierarchy of categories (levels) that describe data in the cube. These categories typically describe a similar set of members upon which the user wants to base an analysis. (You can often recognize a dimension by the use of the word "by""sales by city" or "sales by year."). For example, a geography dimension might include levels for Country, Region, State or Province, and City. A time dimension may contain the levels Year, Month, and Day.A is a summation of values in the cube and is usually numeric. Measures are the central values that are aggregated and analyzed.How does OLAP store its data?The source data for OLAP is commonly stored in data warehouses in a relational
database. A A is a subset of the contents of a data warehouse. A data mart tends to contain data focused at the department level, or on a specific business area.
|
![]() |
|
![]() |
|