Cognos TM1 is enterprise planning software used to implement collaborative planning and provides a completely dynamic environment, for developing reliable personalized forecasts and budgets regularly analyze data for model business requirements. The entire organization and used for results to forecast and budget on better business purpose. In multidimensional 64 bit for memory, OLAP engine gives the exceptional speed performance on analyzing complex and sophisticated models in large data sets on even data streamed.
Are you interested in learning Cognos TM1 Online Training from bangalore? Check Online IT Guru now!
Cognos TM 1 Architecture:
Cognos TM 1 is consists of 3-Tier Architecture Layout on the top there is a Web Client or Web Server and the second tier that contains a Web Application Server and also bottom Tier consists of a Data layer. Tier is separated by firewalls and communication between tiers occurred due to the SOAP and HTTP protocols.
Tier 1 Web Clients: In these Web Client allowed to access TM1 data interact with data in any other supported browser and responsible for managing, the gateway is used for encryption and decryption of passwords, authentication on server to send the request to Cognos BI dispatcher
Tier 2 Web Application Server: A Tier host on Cognos BI Server provides associated services and application server consists of Content Manager, Application Tier Components and Bootstrap service. Cognos TM1 Web Application server runs with java oriented Apache Tomcat server by using this tier Microsoft Excel, worksheet can be changed to TM1 web sheets and allows for export web sheet back to excel and PDF format.
Tier 3 Data: In this tier consists content and data sources and it contains TM1 Admin server and one TM1 server.TM1 Admin server to be installed in any computer of LAN and reside in the same network as TM1 Server version it must be same as the recent version of Cognos TM1 Web.
What are Database connections Management for CognosTM1?
Cognos TM1 used for database in various purposes such as content store database, query database, or metric store database.
Content Store Database: In content Manager Service access content the store and uses single database connection that are per request .It create new database connections required pools connections and reuses existing connections and maintained several database connections on the duration of content manager operation. While other Cognos services are in same computer known as content manager requests are divided into content management and other services. During this case number of connections present in content management may be less than maximum possible connections.
Metrics Store Databases: Metric store database is used for store the information related to metrics it will appear in scorecards. It includes such as
• Metrics performance
• Initiatives, links to related reports, and countermeasures
• Scorecards in membership
Metric Studio is accessed by Metric store database.
Query Databases: Cognos BI server system accesses the query databases. Configure a maximum number of query database connections that obtained for the duration connections are retained, in cleanup thread examines the connections in every minute, any connection is inactive longer than timeout value is removed.
Query database connections are inactive that collected by new request and occur due to a maximum number of connections. It will be reached and inactive connections are not used by the new request. During the oldest inactive connection are terminated and the new connection is created.
Checkout in Online IT Guru now! For Cognos TM1 Online Training Course from hyderabad.