Posts Tagged ‘TM1 training’

Primary Practices for Examining Data

SPSS Data Audit Node       Once data is imported into SPSS Modeler, the next step is to explore the data and to become “thoroughly acquainted” with its characteristics. Most (if not all) data will contain problems or errors such as missing information and/or invalid values. Before any real work can be done using […]

Performance Testing TM1Web Applications with HP LoadRunner

If you’ve ever attempted to perform a performance test on a TM1 application, you know that there is not really an effective way to manually create sufficient load on a model. Getting “real users” to execute application operations – over and over again – is nearly impossible. Thankfully, an automated testing product can solve for […]

Cognos TM1 – View and Subset Maintenance Considerations

TM1 TurboIntegrator is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks. Scripts built with TurboIntegrator or “TI”, can be saved, edited and, through the use of chores, be set up to run at regular intervals.  TI scripts can be used to process existing TM1 data […]

Using IBM SPSS Statistics to Analyze Your Data

No matter what the tool or technology used, data analysis always involves 4 simple steps: Pull together data, Pick the appropriate analysis process or procedure to be performed on that data, Point out (designate) the variables in the data that you are interested in and finally, after performing the selected process, you can Peruse the […]

IBM Cognos TM1 Server Environments and Model Migration

IBM Cognos TM1 employs a distributed, client-server architecture that consists of the IBM Cognos TM1 server to which a combination of different clients can connect. The TM1 Server manages access to the Cognos TM1 data directory for Cognos TM1 clients. The data directory is where files are migrated from and to and this “migration of […]

Leveraging Existing Cognos TM1 Components

Abstract Eventually, you will (hopefully) have developed and delivered something in TM1 that is unique enough (and adds significant value) that you’ll want to leverage it in other models. Leverage Considerations Before leveraging your component, the following must be considered: General Business Requirements (do your business requirements match the delivered components business specifications?) Component Mechanics […]

Loading Cubes – with Cognos TM1 Performance Modeler

So we’ve created a sample, simple cube in Modeler (this cube has only 2 dimensions) and we want to load some data. To do that, you can (like in TM1 Architect) right-click on the folder “Processes”: And then provide a name for the new process: Performance Modeler now presents the “edit process” panel with the […]

Desktop analytics – IBM Cognos TM1 and Insight

So just how easy is it to perform simple forecast modeling using Cognos Insight? Let see. First, I took an MS Excel file and did a “Get Data” and “Import Data…” On the “way in”, Insight let me examine my file and exclude fields I didn’t care about and also (most importantly) tell it which […]

TM1 Modeling Best Practice – Optimally Locating Solution Logic

To insure that acceptable levels of performance and maintainability can be achieved, an “architectural purist” (like me) will want to recommend that when implementing your Cognos TM1 model, great care be taken when deciding where you implement the specific logic that the solution requires. Although there will always be “room for exception” (for example to […]

IBM Cognos Business Intelligence 10.1 Dashboarding

        Living on the east coast while working on the west coast presents the problem of what do to on the bi-weekly 6 hour plane rides. Fortunately, I was offered the opportunity to be a technical reviewer of Ankit Garg’s IBM Cognos Business Intelligence 10.1 Dashboarding Cookbook (PACKT Publishing, 2012, July). Garg […]

IBM Cognos TM1 Certification

Certification           The benefits of earning a certification in Cognos TM1 are many. These include: A self-assessment of your skills Identifying areas of greater strengths and/or weakness Building a killer resume, industry acceptance and prestige. With Cognos TM1, the COG-310 (developer certification) is the exam you’ll want to prepare for. It […]

Cognos TM1 User Experience

The Quandary I’ve literally written a ton of VBA code over the years to “enhance” my end user’s experience. For example, I’ve often slapped a button on a worksheet or toolbar and used the E_PICK to pop-up a dimension subset editor allowing a selection of particular element and then using that selection to drive changes […]