It is almost always advantageous to be able to “make sure” your Cognos TM1 environment is “ready for use” after a server restart. For example, you may want to: Create a backup Load the latest sales data Initialize security Etc. Hopefully, you know what a TM1 chore is (“a chore is a set of tasks […]
Jim Miller
Mr. Miller is an IBM certified and accomplished Senior Project Leader and Application/System Architect-Developer with over 30 years of extensive applications and system design and development experience. His current role is National FPM Practice Leader. His experience includes BI, Web architecture & design, systems analysis, GUI design and testing, Database modeling and systems analysis, design, and development of Client/Server, Web and Mainframe applications and systems utilizing: Applix TM1 (including TM1 rules, TI, TM1Web and Planning Manager), dynaSight - ArcPlan, ASP, DHTML, XML, IIS, MS Visual Basic and VBA, Visual Studio, PERL, Websuite, MS SQL Server, ORACLE, SYBASE SQL Server, etc. His Responsibilities have included all aspects of Windows and SQL solution development and design including: analysis; GUI (and Web site) design; data modeling; table, screen/form and script development; SQL (and remote stored procedures and triggers) development and testing; test preparation and management and training of programming staff. Other experience includes development of ETL infrastructure such as data transfer automation between mainframe (DB2, Lawson, Great Plains, etc.) systems and client/server SQL server and Web based applications and integration of enterprise applications and data sources. In addition, Mr. Miller has acted as Internet Applications Development Manager responsible for the design, development, QA and delivery of multiple Web Sites including online trading applications, warehouse process control and scheduling systems and administrative and control applications. Mr. Miller also was responsible for the design, development and administration of a Web based financial reporting system for a 450 million dollar organization, reporting directly to the CFO and his executive team. Mr. Miller has also been responsible for managing and directing multiple resources in various management roles including project and team leader, lead developer and applications development director. Specialties Include: Cognos/TM1 Design and Development, Cognos Planning, IBM SPSS and Modeler, OLAP, Visual Basic, SQL Server, Forecasting and Planning; International Application Development, Business Intelligence, Project Development. IBM Certified Developer - Cognos TM1 (perfect score 100% on exam) IBM Certified Business Analyst - Cognos TM1
Connect with Jim
Blogs from this Author
Rounding out Cognos TM1
Currently there are 4 options for rounding numbers in Cognos TM1. They are: Rounding in reports. Rounding during loads. Rounding with the Cube Viewer. Rounding with rules. Rounding in Reports The most popular method to apply rounding in TM1 is in reporting. Cognos TM1 leverages MS Excel for reporting and supports all of the formatting […]
Simple Cognos TM1 Backup Best Practices
How do you create a recoverable backup for a TM1 server instance (TM1 service)? What is best practice? Here is some advice. Note: as with any guideline or recommendation, there will be circumstances that support deviating from accepted best practice. In these instances, it is recommended that all key stakeholders involved agree that: The reason for deviation […]
An Architectural Approach to Cognos TM1 Design
Overtime, I’ve written about keeping your TM1 model design “architecturally pure”. What this means is that you should strive to keep a models “areas of functionality” distinct within your design. Common Components I believe that all TM1 applications, for example, are made of only 4 distinct “areas of functionality”. They are absorption (of key information […]
A Practice Vision
Vision Most organizations today have had successes implementing technology and they are happy to tell you about it. From a tactical perspective, they understand how to install, configure and use whatever software you are interested in. They are “practitioners”. But, how may can bring a “strategic vision” to a project or to your organization in […]
IBM OpenPages GRC Platform –modular methodology
The OpenPages GRC platform includes 5 main “operational modules”. These modules are each designed to address specific organizational needs around Governance, Risk, and Compliance. Operational Risk Management module “ORM” The Operational Risk Management module is a document and process management tool which includes a monitoring and decision support system enabling an organization to analyze, manage, […]
The installation Process – IBM OpenPages GRC Platform
When preparing to deploy the OpenPages platform, you’ll need to follow these steps: Determine which server environment you will deploy to – Windows or AIX. Determine your topology – how many servers will you include as part of the environment? Multiple application servers? 1 or more reporting servers? Perform the installation of the OpenPages prerequisite […]
IBM OpenPages Start-up
In the beginning… OpenPages was a company “born” in Massachusetts, providing Governance, Risk, and Compliancesoftware and services to customers. Founded in 1996, OpenPages had more than 200 customers worldwide including Barclays, Duke Energy, and TIAA-CREF. On October 21, 2010, OpenPages was officially acquired by IBM: http://www-03.ibm.com/press/us/en/pressrelease/32808.wss What is it? OpenPages provides a technology driven way […]
Configuring Cognos TM1 Web with Cognos Security
Recently I completed upgrading a client’s IBM Cognos environment – both TM1 and BI. It was a “jump” from Cognos 8 to version 10.2, and TM1 9.5 to version 10.2.2. In this environment, we had multiple virtual servers (Cognos lives on one, TM1 on one and the third is the gateway/webserver). Once the software was […]
Perficient takes Cognos TM1 to the Cloud
IBM Cognos TM1 is well-known as the planning, analysis, and forecasting software that delivers flexible solutions to address requirements across an enterprise, as well as provide real-time analytics, reporting, and what-if scenario modeling and Perficient is well-known for delivering expertly designed TM1 based solutions. Analytic Projects Perhaps phase zero of a typical analytics project would […]
Exercising IBM Cognos Framework Manager
In Framework Manager, an expression is any combination of operators, constants, functions, and other components that evaluates to a single value. You can build expressions to create calculation and filter definitions. A calculation is an expression that you use to create a new value from existing values contained within a data item. A filter is […]
Framework Manager – Creating a Parameter Map
A session parameter is a variable that IBM Cognos Framework Manager associates with a particular session. Examples include (current user name, current active language, current date and time, and others). Parameter maps are a method for substituting different values with different keys. A parameter map can be thought of as simple data “look-up table”. Each […]