Search

Dimensions have properties. They describe the characteristics of the dimension members. Some properties are mandatory, others can be defined by the user

Used by the currency conversion business rules. Balance sheet accounts are typically flagged as END, as they are converted at END rate, Pal accounts are typically flagged as AVG.

The rates are stored in the Rate application. It is a supporting application used in planning and consolidation applications.

This component of the SQP BPC Software allows the administration user to maintain the BPC Server. Actions like restoring or creating BPC backups are done using this component. It also allows to check the application integrity.

Transformation files allow administrators to set up the rules for reading data from an external source and putting it in the proper form for your BPC database. Transformation files are Microsoft Excel files that contain one worksheet, named Instructions. The Instructions worksheet has three sections named options, mapping and conversion.

As Business Intelligence is becoming mature and more of a commodity, there is pressure to achieve things in a faster & cheaper way. In terms of data warehouses & business intelligence this means automation. For example, on a daily basis, we are building & populating fact tables or adding slowly changing dimensions type II functionality to dimensions over and over again.

IBM Cognos Business Insight Advanced is a web-based module that is used by advanced business users and professional report authors to create and analyze reports on relational and dimensional data. Within Business Insight Advanced you can start creating reports without understanding the underlying technology. The functionalities which you can find within tools like Report Studio, Analysis Studio and Query studio are brought together in Cognos Business Insight Advanced.

TM1 Turbo Integrator is part of the IBM Cognos TM1 solution. TM1 Turbo Integrator is used to create dimensions and cubes based on ODBC data sources or flat files. Within Turbo Integrator the developer can make use of advanced scripting features and can create and schedule chores. Turbo Integrator can be considered to be the Extract, Transform and Load utility for use with TM1. TM1 Turbo Integrator is part of TM1 Architect in which a complete TM1 model is build. 

IBM Cognos TM1 is an On-Line Analytical Processing (OLAP) software tool that provides analysis of data stored in a database. IBM Cognos TM1 is a client-server environment which stands for "Tables Manager 1".

An IBM Cognos TM1 TI Process stands for a Turbo Integrator Process. It lets developers import data into cubes from data sources including ASCII files, ODBC and other cubes.