Analytical Processing

15.Metadados: They are given regarding data. Metadados examples of are the descriptions of elements of data, descriptions of types of data, attributes/domnios properties, bands/, methods and processes. 16.Multidimensional Expression (MDX): Projected for Microsoft as a standard for consultations and exchange of data in a multidimensional source of data. 17.Online Analytical Processing (OLAP): Application that takes care of to the solicitations of the synthesis users, analysis and consolidation of data. It possesss the capacity of visualization of the information from different perspectives. The functionality of a tool OLAP is characterized by the dynamic multidimensional analysis of the data, having supported the final user in its activities, such as: 17.1.Drill Up/Down: It consists of exploring different levels of details of the information. With drill down divides an item of summary in its detailed components, as for example, one year is divided in semesters, that are divided in trimesters, later in months, until arriving in days.

Drill up is the same process, however in the opposing direction; 17.2.Drill Through: It occurs when the using one passes of an information contained in a dimension for one another one. For example, analyzing it dimension ' ' Tempo' ' , it is decided to analyze the information for ' ' Regio' ' ; 17.3.Drill Across: When the user polishes an intermediate level inside of one same dimension. For example, the dimension time is composed per year, semester, trimester, month and day. The user will be executing one drill across when it to pass of direct year for semester or month; 17.4.Slice & Dice: It makes possible the alteration of the vision perspective. It serves to modify the position of an information, to change lines for way columns to facilitate the understanding of the users and to turn the necessary cube whenever; 17.5.Alertas: They are used to indicate situations of prominence in elements of the reports, based on conditions being involved objects and 0 variable.