Consider the scenario where you have to convert information held in a “categorical field” into a “collection of flag fields” – found in a transactional source. For example, suppose you have a file of transactions that includes (among other fields) a customer identifier (“who”) and a product identifier (“what”). This file of transactional data indicates […]
Posts Tagged ‘TI’
Data Indiscretions
Data loaded into a TM1 or SPSS model will, in most cases, include files consisting of thousands (or hundreds of thousands) of records. It is not reasonable, given the number of fields and records in files of this size, for you to visually inspect all fields in every record (of every file) for missing or […]
Cognos TM1 – Information Staging
Exchanging Information Most enterprise TM1 applications will need to exchange Information with external systems. With TM1’s TurboIntegrator, you can setup a direct connection (with supported datasources) and move information in and out of TM1 objects at scheduled times or “on demand”. An alternative to going the “direct route” is using a method referred to […]
TM1 TurboIntergrator
TM1 TurboIntergrator TM1 TurboIntegrator (or TI) is the programming or scripting tool that allows you to automate data importation, metadata management, and many other tasks. In my recent book: IBM Cognos TM1 Developers Certification Guide- (http://www.amazon.com/IBM-Cognos-Developers-Certification-Guide/dp/1849684901), I discussed advanced techniques for TurboIntegrator (TI) scripting in regards to the current IBM Cognos […]
Navigating Cognos TM1 Cube Types
navigation Cubes are to TM1 what tables are to relational databases. Almost all data stored in TM1 is stored in and accessed from cubes. Do you know the difference between the types of these basic objects? Let’s explore! First, each and every TM1 cube must have at least two and up to […]