Knowledge base

A view is the way of depicting information in a database. Some options of viewing your data are to arrange your data items in a specific order, re-label, hide or to pre-aggregate certain fields.

A structured query language (SQL) is the standard language for a relational database. The Structured Query Language uses a classic English keyword-oriented set of commands to query, describe, manipulate, and manage data.

Scheduling takes into account different tasks, the time, and the resources to be deployed in order to complete these tasks. It is the ability to determine when a particular process will take place in the future, with special consideration on resource availability, activities, and time constraints.

A role-based security is a user-level security feature that allows you to restrict access to a certain feature in the system based on the user role.In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks. 

Pivot tables enable you to look at data from several dimensions. Such capability is provided in numerous decision support applications under various function names. For example, in a spreadsheet or database, a pivot table provides these views and enables quick switching between them. 

Knowledge management (KM) is the handling of businesses’ intellectual assets in an efficient way. It can involve capturing, developing, sharing and using company’s information in a collaborative environment. 

Information discovery denotes the middle section of enterprise Performance Management and Data Services. It allows decision-makers to access, navigate, analyze, format and share information within the organization. It primarily comprises the Business Intelligence platform, the components of query and analysis, as well as reporting and dashboarding functionalities. 

A gauge refers to a device that visually displays critical information in an easy-to-read format. It is a tool, an instrument or a dashboard device used for checking the conformity of a factor to a desired dimension.

Enterprise resource planning (ERP) refers to a comprehensive software designed for proper resource application and for the optimal use as well as facilitating critical business processes. It is an automated application that supports a range of operational and administrative business processes, such as, financials, time reporting, payroll and workflow management across the entire organization. 

A dimensional hierarchy denotes how data is organized at various levels of aggregation. An analyst uses a dimensional hierarchy to identify various trends at one level, drill down to lower levels to detect causes for these trends, and roll up to higher levels to see the effects the trends have on the whole business.