Bi-kipedia SQL Query A query is a question to a database, translated in a SQL-language which results in a particular data set being returned. Thursday, 7 August 2014
Bi-kipedia Snowflake schemas Two "dimensional modeling” techniques are generally used for modeling the data structures within a data warehouse context. These are the "star schema” and "snowflake schema” techniques. Both find their roots within the Kimball dimensional modeling techniques. Properties of the snowflake schemas : Thursday, 7 August 2014
Bi-kipedia IBM InfoSphere Metadata Workbench IBM InfoSphere Metadata Workbench is a comprehensive metadata solution, unifying data sources, ETL processes, business logic, data quality rules, data models, Business Intelligence reports, and business terminology into a single repository. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Operations Console The IBM Cognos TM1 Operations Console is new in IBM Cognos TM1 version 10.1. This web application tier component is developed for administrators in order to be able to monitor the activity of the TM1 servers on the network. The tool is installed on a Java-based web application server and needs specific configuration before it can be used.The web-based monitoring tool gives a better understanding of how Cognos TM1 server and user loads are working. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Performance Modeler The IBM Cognos TM1 Performance Modeler is the updated version of what was previously called IBM TM1 Contributor Administration. One big difference in IBM Cognos TM1 version 10.1 is that there is now a ‘Model Design' and an ‘Application Design' tab. Thursday, 7 August 2014
Bi-kipedia IBM Cognos Insight IBM Cognos Insight exist in 2 versions. The desktop standalone version or the version which can be accessed through the IBM Cognos TM1 applications portal. Both versions offer exactly the same functionality. They allow to import tabular data from eg. Excel sheets directly into IBM Cognos Insight by drag and drop. The data immediately shows up in a workspace area where users can analyze and visualize their data. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Configuration The IBM TM1 Cognos Configuration is new in IBM Cognos TM1 version 10.1. This administrator component is provided with this new release to manage common tasks and configuration for the following TM1 Components:TM1 Admin Server,TM1 Application Server andTM1 Excel Service.The different services and the different TM1 servers can be stopped and started from one single point now. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Admin Server The IBM Cognos TM1 Admin Server is an application tier component. This process keeps track of all Cognos TM1 servers running on a network. An Admin Server runs on a computer better known as an Admin Host. The moment a Cognos TM1 server starts, the server registers itself with an Admin Server that is running on a specified Admin Host. The Cognos TM1 clients reference the Admin Server to determine which Cognos TM1 Servers are available. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Server The IBM Cognos TM1 Server is an application tier component and manages requests from IBM Cognos TM1 clients. It loads cubes and dimensions into memory and responds by executing calculations, consolidations and updates. Via the Cognos TM1 Server administrators can also manage security by granting or denying permissions to different server objects like cubes and dimensions. Thursday, 7 August 2014
Bi-kipedia IBM Cognos TM1 Application Server The IBM Cognos TM1 Application server runs on a java-based web application server. The TM1 applications allow you to design, deploy and run planning and contributor applications on Cognos TM1 data. The tool interacts with components like Cognos TM1 Performance Modeler and Cognos Insight. Thursday, 7 August 2014