Category Archives: Administration
Persistent Feeders can dramatically decrease the time required to restart a TM1 model. Here is an explanation of what Persistent Feeders are and instructions on how to implement them in your TM1 model.
When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn off transaction logging for a TI using the command CubeSetLogChanges.
Have you ever had an inexplicable change to TM1 data? You know, when a user comes to you and says, John (in my case), the data in TM1 has changed since I looked at it last month? Well, if you have, here is the solution. And it is really easy!
This is a comprehensive guide to configuring TM1 to use Cognos CAM security. It includes why you might connect Cognos security to TM1, TM1 environment changes and how to deploy and configure the BI Interop files to your BI application and gateway servers.
Here we present a fully worked example of how to create element level security for an organisation that requires complete lockdown for entire branches of a dimension. It uses element level security down to the N level, applied via a TI.
TM1 and Excel can now share the same serial date system by the use of UseExcelSerialDate=T in your tm1s.cfg file. Here is the details on this development in Planning Analytics. This means that day number 1 is 1-Jan-1900 in both systems.
Launching CAFE or Planning Analytics for Excel (PAX) can cause errors if the PC is not configured to conform to IBM’s supported environment. Here we go through how to get it all sorted!
How do you join text files in a TI when loading into TM1? In this post we discuss a method to emulate an SQL join in a TI where a csv or text file is the source for the Turbo Integrator process.
Ever needed to create a text file from a data source and you have no tools available to interrogate it? We are doing a cloud Planning Analytics project for a client where they are using an ERP called Finance Plus over a database called Visual Foxpro. Mmmm, I hear you read – why is this relevant for me? Well, Visual Foxpro is a very close relative of dBase – a … Continue Reading
Updated April 2018 – with supported environment for Planning Analytics Local v 2.0.4 and Windows Server 2016 We are about to start a new project with a client where they will be using Planning Analytics local (i.e. the new version of on premise TM1). They have asked about the server specifications and what needs to be installed. IBM have a great tool that gives all this information, but it can … Continue Reading
Search Exploring TM1
- Active Forms (1)
- Administration (56)
- Architect (2)
- Code Sample – Downloadable (9)
- Cognos BI (15)
- Cognos Disclosure Management (1)
- Cognos Express (51)
- Cognos Insight (13)
- Cubes (3)
- CubeSpy TM1 Server Monitor (2)
- Dimensions (24)
- Events & Networking (1)
- Excel (9)
- Exploring TM1 Site (2)
- Formatting (1)
- IBM Cognos TM1 (96)
- InfoCube Spark (1)
- MDX (4)
- Performance Modeller (13)
- Perspectives (3)
- Planning Analytics (7)
- Planning Analytics Excel (4)
- Planning Analytics Workspace (1)
- Rules (45)
- SPSS (6)
- TM1 10.1 (32)
- TM1 10.2 (18)
- TM1 Administration (23)
- TM1 Contributor (3)
- TM1 pre 10.1 (13)
- Training (1)
- Training Material (32)
- Turbo Integrator (84)