Exploring TM1 in Crows Nest, New South Wales, Australia | Computer company

Exploring TM1

Locality: Crows Nest, New South Wales, Australia

Phone: +61 1300 136 755

Address: 133 Alexander Street 2065 Crows Nest, NSW, Australia

Website: http://www.exploringtm1.com/

Likes: 224

Add/Update information

Reviews

Tags

• Computer company

22.01.2022 Each month IBM will release a new version of the PAW server components, usually alongside a new version of Planning Analytics for Excel (PAX) . There will almost always be a new version of both when a new version of the TM1/Planning Analytics core is released. Here we run you through step-by-step how to upgrade the PAW server on Windows Server 2016.

21.01.2022 Have you ever lost your TM1 Administrator password? Thankfully, there is a really simple solution to this frustrating problem. Check it out!

20.01.2022 Picklists in TM1 are a great way for you to ensure that users only enter (or in this case select from a validated list) a value from a standard dropdown list of options. They are the equivalent of data validation in Excel.

18.01.2022 Put simply, Skipcheck forces the TM1 engine to skip the checking of empty cells in a cube. It is used in conjunction with Feeders to force TM1 to open intersections that would have otherwise not been used for a calculation. It is a really useful function making your TM1 model much more efficient. For example, if you have 30 days in the month and data for only 9 of those, the Skipcheck function will skip the other 21 and only aggregate the 9 days with data.

17.01.2022 TM1 views can be very slow to regenerate after data has been loaded or rules modified. It can be a real pain. Thankfully there is the ViewConstruct function that will pre-calculate a view so it is ready to use in either Planning Analytics for Excel, Planning Analytics Workspace, Architect or Cognos BI. Check it out!

17.01.2022 ATTRS stands for ATTRibute String, in other words it returns the contents of a string attribute from an element in a dimension in TM1. It's an easy to use and can be done in both Rules and TI Processes. It's definitely well worth checking out if you aren't familiar with it already!

16.01.2022 Do you need a hand changing TM1 to use Cognos Security? Configuring TM1 to use Cognos security allows you to use your corporate directory server (like Microsoft’s Active Directory) and move the addition of users and placement of users into groups into that company-wide directory server.

15.01.2022 Have you ever wondered how to generate a dynamic subset using MDX that contains JUST the immediate children of a parent from a TM1 dimension? https://exploringtm1.com/children-mdx-for-next-level-only-/

14.01.2022 Do you know what all the TM1 file extensions mean? Here is a complete list of all the file extensions, their directory and a description of each one.

13.01.2022 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.

12.01.2022 How do you take a value from one period and roll it to the next in TM1? This is a really simple task in TM1 Check out how we do it with this article!

12.01.2022 We tested to see how much faster it is to use an extract and load via a turbo integrator process vs using a direct link in a TI process. You'll be surprised at how much faster it can be done!

07.01.2022 Having troubles with your model and want to speed up its performance? Check out this article on how you can cut down the calculation overhead for rules in a multi-year forecasting model!

07.01.2022 We want to give you a downloadable tm1s.cfg. This comes with suggested edits to the tm1s.cfg, folder structure, Cognos Configuration settings and screenshots of all the steps involved. It's all in this article.

07.01.2022 You may find yourself in a situation where you need to do some basic foreign exchange calculations. Thankfully, we have you covered. We came up with this method for foreign exchange calculations and it worked wonders!

06.01.2022 Calculating the number of days in a month is paramount for a lot of financial calculations, but what about applying this to a model? It's a simple problem and an equally simple solution. Here is what we came up with to do this...

03.01.2022 If you are like us, navigating through the IBM website can be a chore. This handy article has both the direct support link and a quick guide on how to fill out a case to get the most efficient response!

01.01.2022 Whenever you perform an upgrade to PAW (Planning Analytics Workspace), it is a really good idea to run a backup. This article here walks you through exactly how to do this in 5 easy steps.