Bi-kipedia Cube The fundamental structure for data in a multidimensional (OLAP) system. May contain dimensions, hierarchies, level and measures. Sunday, 22 March 2015
Bi-kipedia Data Dictionary A repository that keeps detailed definitions regarding the data warehouse logical and physical data models. Sunday, 22 March 2015
Bi-kipedia Level Levels are an implementation of the hierarchies that represent the level of detail viewed in a dimension. As an example, for a time dimension hierarchy, we have levels for year, quarter, and month. Sunday, 22 March 2015
Bi-kipedia Prototyping The construction of a partial system to demonstrate some aspect or aspects of the intended system behavior in order to gain user acceptance or to establish technical feasibility. Sunday, 22 March 2015
Bi-kipedia Anaplan Anaplan is a web-based enterprise platform for business planning, budgeting and forecasting. Anaplan is also the name of the company that created the platform. Sunday, 22 March 2015
Bi-kipedia Forecasting Forecasting is a way of using historical data and future business plans to forecast the future. A forecast will reveal where the business is going to. Forecasts are revisions to the finalized budget. i.e. You have a 2015 annual budget and your 2015-Q1 Forecast would be your revisions to the Q1 budget figures for the 2015 year. However you would still have both your annual budget and your forecasts as finalized documents for reporting and comparison purposes. Sunday, 22 March 2015
Bi-kipedia Aggregation The process of summarizing or combining data. It can be used to speed up query performance. Facts are summed up for selected dimensions from the original fact table. The resulting aggregate table will have fewer rows, thus making queries run faster. Sunday, 22 March 2015
Bi-kipedia End user layer The End user layer is the user interface on top of the multidimensional structures designed for data access tools. Here, the technical layer (databases & relations) is transformed into a business layer, understandable for the end-user. Sunday, 22 March 2015
Bi-kipedia Entity relationship diagram (ERD) A diagram that pictorially represents entities, the relationships between them and the attributes used to describe them. Sunday, 22 March 2015
Bi-kipedia Radio frequency identification (RFID) Transponder technology for the contactless recognition of objects. The heart of this technology is the so-called RFID tag, a small computer chip with a miniature antenna. It can be used on transport and goods packages as well as sales units and products. When the chip receives the radio signal from a reading device, it automatically transmits the stored data wirelessly. Transmission is based on radio frequencies. The tags are passive; they do not require any battery or maintenance. Sunday, 22 March 2015