Attending IBM TechXchange in Mandalay Bay, Las Vegas was an exhilarating experience that showcased the cutting-edge IBM technologies shaping various industries today. The conference brought together technologists, IBM Champions, thought leaders, industry experts, and innovators eager to share insights and explore the latest advancements in IBM's technology portfolio. From AI to cloud computing, the event highlighted how these tools are transforming businesses, making operations more efficient, and ultimately driving better decision-making. As an IBM champion we were treated as VIPs with row ...

Planning Analytics Workspace (PAW) offers a robust suite of visualizations, enabling users to create rich and compelling reports and dashboards with remarkable flexibility. However, even with these capabilities, you may occasionally encounter requirements that push the limits of what PAW provides out of the box. One such scenario I encountered was the need to create a column chart comparing Actual vs Budget variance. The twist? Any negative variance should be highlighted with a red bar, while positive variance should be displayed in green, as shown below: PAW’s default settings don't ...

In this blog post, we will showcase the process of exposing the transaction logging on Planning Analytics (PA) V12 on AWS to the users. Currently, in Planning Analytics there is no user interface (UI) option to access transaction logs directly from Planning Analytics Workspace. However, there is a workaround to expose transactions to a host server and access the logs. By following these steps, you can successfully access transaction logged in Planning Analytics V12 on AWS using REST API. Step 1: Creating an API Key in Planning Analytics Workspace The first step in this process is to create an ...

Effective management of Planning Analytics (TM1), particularly with tools like IBM’s TM1, can significantly enhance your organization’s financial planning and performance management. Here are some essential tips to help you optimize your Planning Analytics (TM1) processes: 1. Understand Your Business Needs Before diving into the technicalities, ensure you have a clear understanding of your business requirements. Identify key performance indicators (KPIs) and metrics that are critical to your organization. This understanding will guide the configuration and customization of your Planning ...

For over a decade and a half, my life has been intertwined with the WRX Car Club of NSW, a vibrant community centered around a shared passion for Subaru's iconic rally-inspired cars. What began as a casual interest in high-performance vehicles evolved into a deeply enriching journey that has left an indelible mark on me and my family. I still remember the first time I attended a club event, a curious enthusiast drawn by the allure of the roaring engines and the camaraderie of fellow enthusiasts. It was a world unlike any other, where speed and adrenaline converged with a sense of belonging ...

In this blog post, I aim to demonstrate a simple yet effective technique to display the members returned by a set as a list in Excel. This serves as a quick and efficient method for analysing the results from your static or MDX-based sets. This approach offers an alternative to using the TM1ELLIST function in Planning Analytics for Excel (PAfE), which also returns an array of members based on MDX expression or a set. However, the TM1ELLIST function requires the user to manually enter the formula to view the results and it does not support hierarchies. When you add a SUBNM or TM1Set function ...

In the realm of digital transformation, the concept of digital labor has emerged as a game-changer for businesses seeking efficiency, agility, and innovation. IBM WatsonsX Orchestrate, a powerhouse in the AI and data orchestration space, takes center stage in this digital evolution. This blog explores the pivotal role played by WatsonsX Orchestrate in reshaping digital labor and how it empowers organizations to harness the full potential of artificial intelligence (AI) and data science. Orchestrate allows you to add and train new automations from a variety of sources, enabling users to easily ...

In a recent announcement, IBM unveiled changes to the Continuing Support program for Cognos TM1, impacting users of version 10.2.x. Effective April 30, 2024, Continuing Support for this version will cease to be provided. Let's delve into the details. What is Continuing Support? Continuing Support is a lifeline for users of older software versions, offering non-defect support for known issues even after the End of Support (EOS) date. It's akin to an extended warranty, ensuring users can navigate any hiccups they encounter post-EOS. However, for Cognos TM1 version 10.2.x, this safety net will ...

In an era defined by digital transformation and efficiency, businesses are increasingly turning to automation to streamline their operations. One such powerful tool in the realm of automation is IBM Robotic Process Automation (RPA). In this blog post, we'll delve into the world of IBM RPA, exploring its key features, benefits, and how it is shaping the future of business processes. Understanding IBM RPA: Robotic Process Automation, or RPA, refers to the use of software robots or "bots" to automate repetitive, rule-based tasks within business processes. IBM RPA is a comprehensive solution ...

With the holiday season just around the corner, the air is buzzing with excitement as individuals eagerly anticipate spending quality time with their loved ones. As companies prepare for the annual shutdown, employees are gearing up for some much-needed rest and relaxation. However, amidst the festivities, it's essential to ensure that business operations continue to run smoothly, especially for those facing month-end reporting obligations. Maintaining Business Continuity: The holiday season is a time to unwind, reflect, and connect with family and friends. However, in finance, the show must ...

In today's digital age, businesses are constantly seeking ways to optimize their data management processes. One solution that has gained significant popularity is the migration of planning analytics to the cloud. This strategic move offers several advantages that businesses can leverage to enhance their data management capabilities. Why Cloud? One of the primary reasons why companies are making the switch to cloud-based planning analytics is the instant global presence it provides. By storing data in data centers located around the world, organizations can ensure that their data is accessible ...

In the ever-evolving world of data visualization and reporting, Power BI continues to shine as a leading tool, constantly enhancing its capabilities. The August update brings a slew of exciting features, focusing on making your reporting experience smoother, more precise, and more efficient than ever before. Let's dive into the game-changing updates: 1. New Layout Switcher Tired of the hassle of switching between web and mobile layouts while developing your reports? Say hello to the new layout switcher! Power BI has introduced intuitive buttons, thoughtfully positioned at the bottom of your ...

In today's data-driven world, making informed decisions is not just a competitive advantage; it's a necessity. Power BI, Microsoft's robust business intelligence tool, has emerged as a go-to solution for organizations across various industries. Whether you're a small business owner, part of a dynamic team, or part of a large enterprise, Power BI offers a range of options to cater to your unique data analysis and visualization needs. The Power BI Ecosystem In the realm of business intelligence and data analytics, Power BI stands tall as a dynamic and versatile tool that empowers organizations ...

In today’s highly connected world, IT systems are critical for the success of any business. But as with any technology, these systems can fail. When they do, the repercussions can be devastating. From lost data to lost customers, the impact of a failing IT system can be far-reaching and costly. Fortunately, there are steps businesses can take to avoid great failures of IT systems. By understanding the potential pitfalls and implementing strategies to prevent them, organizations can protect themselves from potentially catastrophic outcomes. 1. Establish a Plan for Regular Maintenance and ...

One of the standout features of Planning Analytics Workspace (PAW) is its ability to create calculations in the Exploration view. This feature empowers users to perform advanced calculations without the need for technical expertise. Whether you're using PAW or PAfE (Planning Analytics for Excel), the Exploration view offers a range of powerful capabilities. The Exploration view supports a variety of functions, such as aggregations, mathematical operations, conditional logic, and custom calculations. This means you have the flexibility to perform complex calculations tailored to your specific ...

When business users inquire about Planning Analytics for Excel (PAfE) or TM1 Perspectives, I often resort to the widely recognized phrase 'Excel on steroids' to effectively convey its true power and potential. PAfE acts as a dynamic complement to their existing Excel skills, bridging the functional gaps between the two tools to boost productivity significantly. Rather than replacing Excel, PAfE expands its capabilities, empowering users to delve deeper into analysis and unlock untapped opportunities. This professional alliance between PAfE and Excel helps businesses leverage their existing ...

Process Mining and RPA are two powerful tools that can help organizations increase efficiency and reduce costs. When used together, they can provide unprecedented visibility and insight into organizational processes, allowing for greater scalability of RPA implementations and unlocking hidden value. With Process Mining, organizations can identify inefficiencies in their processes and use RPA to automate tasks and optimize operations. CFOs recognize the potential of this combination and view investments in Process Mining as a key factor in maximizing returns from RPA. In fact, a 2021 Gartner ...

With the introduction of hierarchies in IBM Planning Analytics, a new level of data analysis capability has been unlocked. This is by far one of the most significant enhancements to the Planning Analytics suite as far as the flexibility and usability of the application is concerned. Benefits of LEAVES Hierarchy One particular useful hierarchy is the LEAVES hierarchy. It offers several benefits beyond data analysis. One that stands out is that it is a “zero-maintenance” hierarchy as it automatically adds leaf level members as they are added in other hierarchies. It can also be used as a master ...

There’s never been a greater need for automation Are you looking for the perfect way to unlock hidden value from your business operations? Look no further than Process Mining and Robotic Process Automation (RPA). When these two powerful software tools are deployed in tandem, organizations can realize millions of dollars in savings and unprecedented operational efficiency. In this blog post, we'll explore how the two work together, what kind of results organizations are seeing, and how you can get started fast. Let's dive in! The current climate of soaring inflation and labor shortages ...

If you’re tired of manually updating your reports every time you need to add a new column in your Dynamic Reports, you're not alone. It can be time-consuming and tedious - not to mention frustrating - to have to constantly tweak and adjust your reports as your data changes. Luckily, there’s a way to make your life easier: Dynamizing Dynamic Reports. By using a hack to make your reports’ columns as dynamic as the rows, you can free up time and energy for other tasks - and make sure your reports are always up-to-date. Read on to learn how to make your reports more dynamic and efficient! The ...

In recent years, Octane has been expanding into new markets and introducing its business solutions to help organisations achieve their goals. Octane is an IBM Gold partner based out of Sydney Australia and operates in Australia, India, and UAE with clients located in all parts of the world. Octane's entry into Fiji presents a unique opportunity for businesses in the region to access the company's technological expertise and benefit from its innovative solutions. Octane runs a 24/7 Managed Service operation from its Indian delivery centers and would be training staff and setup a delivery ...

As the world moves towards more data-driven decision-making, businesses are increasingly looking for effective planning and budgeting solutions. IBM Planning Analytics is the go-to for businesses looking for a comprehensive set of tools to help them manage their budgeting and planning process. With Planning Analytics, businesses can access powerful analytics to make more informed decisions, leverage advanced features to create complex models, and gain better insights into their financial data. IBM is constantly improving the functionalities and features of the IBM Planning Analytics ...

Amin Mohammad, the IBM Planning Analytics Practice Lead at Octane Solutions, is taking you through his top 12 capabilities of Planning Analytics, in 2023. These are his personal favorites and there could be more than what he is covering. He has decided to divide his list into PAFe and PAW, as they have their own unique capabilities, and to highlight them separately. Planning Analytics for Excel (PAfE) 1. Support for alternate hierarchies in TM1 Web and PAfE Starting with TM1 Set function, which has finally opened the option to use alternate hierarchies in TM1 web. it contains nine arguments ...

Have all the data but not the full picture ? Business Intelligence is not a software application but rather concept of accelerating and improving decision making; optimizing internal business processes; increasing operational efficiency; driving new revenues; and gaining competitive advantages over business rivals. BI systems should help companies identify market trends and spot business problems that need to be addressed. It encompasses displaying historical data as well as new data as its generated from source systems enabling analysis to support both tactical and strategic decision making ...

One of the interesting things about Octane Red and Blue is that there is no onboarding you can start to ticket on the first day of your subscription. Over time, we are studying tickets that the user creates and anticipate that the user will have the same ticket for the next month so we will create it in advance so that users will no longer make one, that is what we call recurring tickets. There is a lot of automation that we can introduce, and this will no longer require any human intervention needed during the process, and tasks that are ticketed will be automated. Preventative maintenance ...

If you are a TM1 user then you would have surely come across times when you required assistance in support or Development (DevOps) for your implementation. Thousands of companies use TM1 globally for financial and business performance reporting, calculation and presentation of KPIs, allocation, and apportionment, and as a tool for data collection. While having all that factors, a company may also experience pain points like costly consultants for TM1 Development and the struggle to hire a TM1 developer. We have released Octane Blue and Red which allows you access to TM1 developer and support ...

Six months after Tyro implemented Blackline software, Casper Deman, Tyro’s Finance Project lead, joins Octane’s Amendra Pratap, for a fireside chat to discuss life after Blackline. Let’s dive into the learnings from Caspar Deman while implementing Blackline Software in a high-growth organisation like Tyro. Download the full case study at the end of this article. Q. Why don't you give us a quick introduction to your interactions with Blackline Reconciliation? Casper: "I worked at News Corp for eight years. My last role at News Corp for the last probably a year and a half was heading up the ...

Warning: long term use of Excel is lethal for CFOs trying to make data-driven decision-making. Discover how Excel can’t excel when it comes to managing data and what can be done about it. The troubles with Excel are only beginning. Excel not only caps out at a million records, but it also rounds off large numbers using imprecise calculations which compromises the accuracy of your data. Excel is a single-user system. That means it only allows one person to input data at a time. There’s a high chance that someone entering the data does it without regard for storage, backup, and processing best ...

According to the BARC Report 2022, market leaders included SAP, TM1, Oracle, Workday, Board and Jedox. Other popular FP+A tools like Anaplan were rated as challengers. All FP+A software companies were rated on these dimensions: Planning and forecasting Ease of use for business users Portfolio evaluation Ad hoc query and reporting Analysis Infrastructure evaluation Dashboards Formatted reporting Advanced and predictive analytics Scoring Calculating the individual ratings for all criteria and all vendors produces two scores per company: the Portfolio Capabilities score and the Market Execution ...

Caspar Deman, Tyro’s Finance Project Lead, shares his top four tips when considering Blackline Reconciliation. Caspar offers practical advice for Financial Controllers and Financial Accountants, looking to make financial transformation in their organisations. Caspar advises companies adopting Blackline to think about the following: Get rid of error-prone manual consolidations Make it scalable (as early on as possible) Be ready for one-off integration challenges Manage expectations and timeline Download the full case study at the end of this article. 1. Get rid of error-prone manual ...

Instead of using historical sales data, CFOs making financial transformations are shifting to driver-based forecasting. In the Australian construction industry alone, market conditions have moved so quickly in the last 24 months, that history can no longer be trusted to tell the future. In the Australian construction industry alone, market conditions have moved so quickly in the last 24 months, that history can no longer be trusted to tell the future. Forecasting P+L and balance sheets based on actuals and historical data is proving less reliable. The historical data can’t capture the market ...

Australian construction companies that will thrive during the recent consolidation will blend corporate strategy and digital analytic strategy. CFOs will move away from traditional models to adopt digital strategic planning models that rely on data insights while making decisions. Aspen Medical CFO, Moazam Shah, noted some of the key competencies for finance professionals to thrive in a digital world, including knowledge of digital technologies, ability to articulate their use to a wider audience in the business, an ability to learn and adapt to changes in technologies, and to a motivation to ...

120 balance sheet reconciliations, stacks of spreadsheets, and lots of emails – month-end for Tyro Payments was a nightmare. That was until this fintech organisation adopted Blackline Reconciliation. In FY21 more than $25.5 billion in transactions were processed with Tyro, accounting for 24% of transaction volume Compound Annual Growth Rate. Considered the fifth largest payment processor with 600 employees, it only has about 18 people on the finance team. The rapid growth brought increased complexity, risk, and cost in their financial close and reporting processes. So naturally, the team was ...

Home Innovation Builders, Dyldam Developments, Hotondo Homes franchise, Tasmanian Constructions, ABD Group, BA Murphy, Pindan, and Inside Out Construction have all gone bust. It’s time CFOs from the construction embraced financial transformation. Construction giants like Probuild and Condev have collapsed. Many other construction companies are looking at downturns and the huge debt that’ll push them into a similar path to liquidation. Amendra Pratap, Managing Director at Octane, say: “The rate of construction companies falling and going bankrupt is at an all-time high. The major reason behind ...

This white paper was written to describe the level of self-service users can expect from TM1. Download the full white paper in PDF below. This white paper was written to describe the level of self-service users can expect from TM1. To understand what users can expect from TM1, imagine your organisation’s finance office is a house. In this house, users are busy building different kinds of rooms. Popular rooms include budgeting and forecasting. In an adjacent room, analysis of financials is taking place. Down the hallway a report is being created. In addition to the rooms, there is furniture ...

Balancing Flexibility and Standards - IBM Cognos TM1 Govern Data Discovery The world of data has infinite variety…and infinite requirements. No single analytics solution will please everyone. But it is possible to combine the strengths of complementary solutions to help meet the needs of both enterprise IT personnel who crave data governance and the end business users who are hungry for self-service. IBM offers different flavors of analytics to bring you the best side-by-side experience. In today’s blog, I would like to focus on IBM Cognos TM1 Planning Analytics - a unique union of data ...

What is it? Box plots have been around in PAW since version 2.0.63. The purpose of this visualization is to help the financial analysts to view the concentration or distribution of their financial data at a glance, including the summarized statistical information without requiring any sort of data science expertise or delving into the technicalities of writing complex statistical calculations to get this visualization. The benefit of this visualization is that it is quite simple to create, no statistical coding is required with PAW doing all the heavy lifting while the users simply ensure the ...

While reading the excerpts from various books and journals on science direct website, I couldn't help but start thinking of how IBM PA fares against these quality attributes of software, which has precisely led me to write this blog article hoping to share my thoughts with you. As I do this, I am also hoping that this will aid the CFOs and other decision-makers in choosing the right software for their organization based on these key traits. Before we start talking about software quality attributes also known as SQA, let us first understand what it takes to assess the quality of any software. ...

It’s an amazing feeling as we gear up to celebrate Octane’s 5th anniversary. What started as an idea and nurtured by me and my senior leaders is fast transforming into an established and growing enterprise. Five years is usually a significant milestone in a startup’s life as it pushes you into a grown-up zone. It’s been an exciting journey and the pandemic indeed threw some curveballs at us. From Macquarie to Octane I am often asked about the motivation to resign from Macquarie Group to start Octane. Macquarie was an excellent learning ground to nurture one’s entrepreneurial fire. I found a ...

Octane Software Solutions is a cutting edge technology and services provider to the Office of Finance. Octane is partnered with vendors like IBM and BlackLine to provide AI-based solutions to help finance teams automate their processes and increase their ability to provide business value to the enterprise. Qubedocs is an automated IBM Planning Analytics documenter. It generates automated documentation within minutes and ensures compliance and knowledge management within your organisation. So, we're excited to announce our partnership with QUBEdocs - a solution that takes the resources and ...

We have made it easier for your users to access Planning Analytics with Watson (TM1) Training. This week we launched our online training for Planning Analytics with Watson PAW and PAX; available online in instructor-led, 4-hour sessions. Planning Analytics with Watson (TM1) Training This training provides the ideal time for you to spend some of your allocated training budgets; often assigned but never utilised on something that you can actually apply in your workplace. We have made it easy for you to book your training online in a few easy steps. IBM has been consistently improving and adding ...

Have all the data but not the full picture ? Business Intelligence is not a software application but rather concept of accelerating and improving decision making; optimizing internal business processes; increasing operational efficiency; driving new revenues; and gaining competitive advantages over business rivals. BI systems should help companies identify market trends and spot business problems that need to be addressed. It encompasses displaying historical data as well as new data as its generated from source systems enabling analysis to support both tactical and strategic decision making ...

Starting 1 April 2021, "with Watson" will be added to the name of the IBM Planning Analytics solution. IBM® Planning Analytics with Watson will be the official product name represented on the IBM website, in the product login and documentation, as well as in marketing collateral. However, IBM TM1® text will be maintained in descriptions of planning analytics' capabilities, differentiators and benefits. What is the "Watson" in Planning Analytics with Watson? The cognitive help feature within Planning Analytics with Watson is the help system used in IBM Planning Analytics Workspace (Cloud). ...

The blogs brief about the challenge faced post enabling the Audit log in one of our client's environment. Once the audit log was turned on to capture the metadata changes, the Data Directory backup scheduled process started to fail. After some investigation, I found the cause was the temp file (i.e., tm1rawstore. ) generated by the audit log by default and placed in the data directory. The Temp file is used by audit log to record the events before moving it to a permanent file (i.e., tm1auditstore). Sometimes, you may even notice dimension related files (i.e., DimensionName.dim.), and these ...

IBM Planning Analytics provides the functionality of Data Spreading at Consolidations to users for faster planning and analysis in TM1 Architect, TM1 Perspectives, IBM PAW and TM1 Web. You can evenly distribute a value across a range of cells or increment all values in a range of cells by a percentage. The problem comes in when there are a greater number of users involved in Data Entry, and if the Dimensions in the Cube have more elements and intersections. For instance, if multiple users perform Data Spreading at the consolidated level at the same time, this slows down the overall ...

Ever wondered how good it would have been to merge multiple dynamic reports next to each other for doing your analysis from disparate reports, only to be realise that it can’t be possible? Fortunately, Power Query is here to our rescue and that’s what we will be looking at in this blog post. So, to start with, what is Power Query? Power Query, also known as Get & Transform in Excel 2016, is an Excel interface that finds data from wide range of data sources and performs data transformations using its ETL processing editor called Power Query Editor. Power Query then creates queries and ...

In my previous blog articles, I have covered various use cases of Dynamic Arrays(DA) and some of the capabilities it offers. In case you missed it, I would strongly recommend you go through them (see links below) before proceeding with reading this blog. What are Dynamic Array formulas and why you should use them Data Analysis using Dynamic Array formulas In continuation of that, I will cover another use case where I would further highlight the power of DA when used with PAfE. With that being said, ever since I learnt about Dynamic Arrays in Excel, I was very fascinated and always wondered ...

The Blog shows how to use TM1 Rest API to extract, filter, select only specific details/properties from the dimensions, all the metadata extracted from TM1 Rest API will be in JSON. If this is your first time on TM1 Rest API, then it is recommended to visit the link below which covers the introduction and helps with getting started on TM1 Rest API. https://blog.octanesolutions.com.au/introduction-to-tm1-rest-api Here, we will be using Go_New_Store TM1 Sample Instance in windows environment and Chrome Browser with JSONView Extension https://:/api/v1/ AdminHost: The Server name where the Admin ...

With the recent update from TM1 to Planning Analytics, IBM has introduced PAW (Planning Analytics Workspace) which can be utilized to Develop Dashboard, Reports, Graphs, Workbooks, Views etc., as per any individual’s Requirements. But if these Workbooks and Views are accidently deleted, then it will be impossible to restore them unless you have a backup of those objects. Also, IBM does not take backups of these Books and Views developed in PAW. Hence its necessary for us to have a backup procedure and Restore them if required. To perform this backup and Restore activity, make sure you have ...

The much awaited major release of Workspace is out now. The new version Planning Analytics Workspace 2.0.57 is available for download for on premise installs. Cloud version will follow in Mid October. Planning Analytics Workspace was released on 11th December 2015. This new look and feel and the features like workflow, AI forecasting, the rich visualisations and virtual dimensions + the features TM1 was born with - the write back, On the fly Consolidations and excel integration will now take TM1 to the next level... TM1 is putting the final nail in the coffin for its competitors! Here is a ...

How to create reports using dynamic array formulas in Planning Analytics TM1 In our previous blog (https://blog.octanesolutions.com.au/what-are-dynamic-array-formulas-and-why-you-should-use-them), we discussed about Dynamic Array formulas and highlighted the key reasons and advantages to start using DA formulas. In this blog, we will try to create a few intuitive reports based on custom reports built on PAfE. The data set we will be using is shows the employee details in “Employee” cube with the following dimensionality: Dimension Measure Year Department Version Name/Desc Sr.No Current Salary ...

What are Dynamic Array formulas and why you should use them? In this blog article (and few other upcoming blogs), I am going to write about the capabilities of Dynamic Array (DA) functions with examples and demonstrate to you some great features it has that I believe can empower the PA Analysts to do all differently sorts of data analysis in a simpler and much more intuitive way, thereby enhancing their productivity. To start off, lets first understand what Dynamic Array functions actually are? To put it simply, the DA functions are those functions that leverages Excel’s latest DA calculation ...

2020 has been an interesting year for us ! Celebrations This month Octane celebrates our 4th anniversary. Never imagined that we would be celebrating with our team members across different geographies via online gifts and Teams meetings. Normally we fly in all our team members to one location for the weekend and have a great time bonding. However with the global pandemic we had to adapt as the rest of the world is. The journey so far On the whole, reflecting back on the journey so far on our anniversary 2020 certainly has thrown in an riveting challenge. Having started from a small shared ...

We might often get a request from users that TM1 session has logged. As per the client requirement and standards, need to increase or decrease the session timeout. Changing the session timeout is a trade-off, it should not be too big or too small. If it’s too big then many inactive sessions can lead to server performance issues. If it is too small, then the user experience might be affected. Each application of TM1 has its separate session timeout parameter. Jump into the respective section, depending upon your need. TM1Web 1. Go to \IBM\cognos\tm1_64\webapps\tm1web\WEB-INF\configuration and ...

Renaming the element name – SwapAliasWithPrincipalName In Realtime Scenarios, sometimes we get the requirement to correct/update the Principal element name(s) in a Dimension. This would relatively be easy if the dimension is being used in one cube. In case where the dimension is used in multiple cubes, updating element name(s) without affecting the data of all the cubes, is a bit challenging. Either we export data of the cube and change the element name(s), then import the data and validate cube before and after the element change. Or deploy the Bedrock process, which requires the reboot of ...

Many Developers like to stay away from the topic call Feeders in TM1 / Planning Analytics world but on the other side we cannot avoid Feeders as it plays the most crucial role while Modelling the data flow. Sometimes, dealing with Feeders may result in 2 major issues: 1. Over Feeding - Performance issue. - RAM consumption. 2. Under Feeding - Totalling issue To avoid this there is a small concept called Feeder-Less Feeding where we can avoid writing Feeders and Feeder related issues.   About: Feeder-Less Feeding is a Concept of Modelling the data in such a way where you write a Rule in TM1 ...

DataFusion is a TM1 connector developed by Octane. It was borne out of the frustration clients were facing extracting data out of their IBM Planning Analytics application into other enterprise Reporting tools like Power BI, Tableau and Qlik. Typically this was set up as a manual task that required an IT or Finance person to drop a csv and upload into Reporting tools. This created a number of issues. Firstly it required the operator to ensure that the correct slab of data has been captured and uploaded. It also created a risk as end users would have to rely on operator to perform this task on ...

REST stands for REpresentational State Transfer. It is web standard-based architecture and uses HTTP Protocol. TM1 REST API is a type of web service which can be used to perform create, read, update, and delete operations on TM1 objects or data. Therefore, we can maintain a TM1 model, manage TI processes, chores, dimensions and query data that is stored in the model. TM1 REST API provides an Open Data Protocol (OData) Version 4 compliant interface to TM1 server, which allows clients to query and update data sources that are hosted by TM1 Server. The OData standard defines a set of rules and ...

I recently came across a problem statement at a client site and thought it would make good content to share for my blog article so without further ado here it goes... Background: The customer uses PA Local with native TM1 security and has recently added a new TM1 instance. As we are aware, to be able to login to PAW, the user’s login credentials must be same on all TM1 servers. Now the challenge was the users normally change their passwords from TM1Web login page which means they have to login twice to change their passwords – one for each server. I considered this a little problematic ...

In this article I would like to share a very useful tip on how we can use different methods to adding images in Planning Analytics Workspace; one that is very well known, one that is lesser-known and one that is relatively unknown. I intend to touch base on the first two methods while focusing more on the latter one. But before I begin, as I write this blog article, there has been more than 2 million confirmed cases of COVID-19 worldwide with over 130,00 deaths and I wish to take a moment on behalf of Octane Software Solutions and express our deepest condolences with all those and their ...

In light of the heightened level of concern related to the spread of Coronavirus (COVIS-19) we want to provide an update on the actions Octane is taking to safeguard the health-being of our clients, our associates and their families. All of our 7 offices around Australia, India and Middle East are continuing to serve the needs of our clients. For your and our safety we are following the guidelines in respective countries public health authorities. We are monitoring the situation daily and continue to take guidance from public health authorities. There are number of steps we have taken as part ...

Gone days, where we had no control/alerts mechanism on the TM1 database, CPU/memory it consumes, react at the nick of the moment before TM1 server crashes. I am sure all TM1 lovers, administrators and business users who had these experiences in the past would connect to what I am referring to. For all new Planning Analytics users, in earlier versions of TM1/ Planning Analytics, we had little overview on how much on RAM/ memory can a TM1 instance use/utilize or have an inbuilt alter mechanism. TM1 Database Alert Mechanism: Issue: Most of you know, TM1 Server loves memory/RAM, more memory ...

This blog explains a few TM1 tasks which can be automated using AutoHotKey. For those who don't already know, AutoHotKey is open-source scripting language used for automation. 1. Run TM1 Process history from TM1 Serverlog : With the help of AutoHotKey, we can read each line of a text file by using loop function and content is stored automatically in an in-built variable of function. We can also read filenames inside a folder using same function and again filenames will be stored in an in-built variable. Therefore, by making use of this we can extract Tm1 process information from Tm1 Serverlog ...

IBM has identified a defect within the code introduced in TM1 10.2.2 Fixpack 7, part of all other releases before 2.0.9. This defect causes data loss within the cubes even after performing SaveDataAll activity with in TM1 server. Let us get into the details. What is the defect : Possibility of losing data even after SaveDataAll activity is performed. This defect (APAR PH19984) has been identified recently by IBM. This will only trigger when below conditions are met. No-SaveDataAll : If SavedataAll not performed since TM1 Server was rebooted. Lock Contention : Lock contention specific to ...

Octane turned 3 this year and to put icing on the cake Octane just attained the status of IBM Gold Business Partner. Sounds a bit of founder’s cliche, however it really has been an extraordinary journey. It all started with a passion to fill a gap in the market. Biggest task though was building a team that is equally passionate and sold on the idea of transforming how a vendor could play a more strategic role in partnering with clients to shape their Data and Business Intelligence objectives to deliver actionable insights. After having interacted with most of the vendors in this space over 15 ...

IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and/or from TM1 Web. This blog is dedicated to clients who have either recently adopted PAX or contemplating too and sharing steps on how to trace/watch TI process status while running process using Planning Analytics for Excel. Steps below should be followed to run processes and to check TI process status. 1. Once you connect to Planning Analytics for Excel, you will be able to see cubes on the right-hand side, else you may need to click on Task Pane. 2. Click on the middle icon as shown ...

IBM, with the intention of adding new features to Planning Analytics ( TM1) and to its Visualization and reporting tools Planning Analytics Workspace and Planning Analytics for Excel new release are happening at regular intervals. New version for Planning Analytics Workspace, Planning Analytics for Excel comes out every 15-40 days, for Planning analytics new version comes out every 3-6 months. In this blog, I will be discussing about the version combinations to be used between these tools to get better/optimum results in terms of utilization, performance, compatibility and bugs fixes. ...

If you are thinking of moving to Planning Analytics, then this document can help you in selecting the best Operating System (OS) for your PA installation. Planning Analytics currently supports operating systems listed below: Windows Linux At Octane, we have the expertise of working on both Windows and Linux environments and number of clients asked which one is the best-fit for their organisation? Although its looks like a simple question but hard to answer, we would like to highlight some aids of both to help you to select the best-fit for your organization. WINDOWS Versions Supported for ...

Before you read further, please note, this blog details secure Gateway connection used for Planning Analytics deployed “on-cloud” Software as a Service (SaaS) offering. This blog details steps on how to renew secure gateway Token, either before or after the Token has expired. What is IBM Secure Gateway: IBM Secure Gateway for IBM Cloud service provides a quick, easy and secure solution for establishing link between Planning Analytics on cloud and a data source; Typically, an RDBMS source for example IBM DB2, Oracle database, SQL server, Teradata etc. Data source/s can reside either ...

IBM, in Planning Analytics Workspace’s 2.0.45 release however has addressed some limitations by extending the flexibility to users to upload the fonts and color themes of their choice in Workspace and apply it in their visualisations. One of the common complaints that I constantly hear from users and have myself put up with when using Planning Analytics Workspace is its lack of available fonts and color pallets for its visualisations. The lack of this flexibility put a hard restriction on designing intuitive interfaces and dashboards as we’re limited by only a certain fonts or color ...

This article talks about different extensions/files seen in Data directory and how they are co-related to front-end objects that we see in architect. Since, TM1 is an in-memory tool so all objects seen like cube, dimension, TI process etc seen in Architect are saved in data directory with a specific extension and in a specific way to differentiate them from the other objects. By understanding these extensions/files, it comes easier in finding objects and deciding which objects are needed to be considered to backup or moving a specific set of changes. Consider the case of taking an entire data ...

Since the launch of Planning Analytics few years back, IBM has been recommending its users to move to Planning Analytics for Excel (PAX) from TM1 Perspective and TM1 Web. As every day new users migrate to adopt PAX, it’s prudent that I share my experiences. This blog will be part of a series where I would try to highlight and make users aware of different aspects of this migration. This one specifically details a bug I encountered during one of the projects in which our Clients was using PAX and steps taken to mitigate the issue. What was the problem: Scenario: when a Planning Analytics User ...

This blog broaches all steps on how to install IBM Secure Gateway Client. IBM Secure Gateway Client installation is one of the crucial steps towards setting up secure gateway connection between Planning Analytics Workspace (On-Cloud) and RDBMS (relational database) on-premise or on-cloud. What is IBM Secure Gateway : IBM Secure Gateway for IBM Cloud service provides a quick, easy, and secure solution establishing a link between Planning Analytics on cloud and a data source. Data source can reside on an “on-premise” network or on “cloud”. Data sources like RDBMS, for example IBM DB2, Oracle ...

IBM Watson™ Studio is a platform for businesses to prepare and analyse data as well as build and train AI and machine learning models in a flexible hybrid cloud environment. IBM Watson™ Studio enables your data scientists, application developers and subject matter experts work together easier and collaborate with the wider business, to deliver faster insights in a governed way. Watch the below for another brief intro Available in on the desktop which contains the most popular portions of Watson Studio Cloud to your Microsoft Windows or Apple Mac PC with IBM SPSS® Modeler, notebooks and IBM ...

As you plan to adopt IBM Planning Analytics cloud, it’s important to understand what it takes. This blog highlights areas you will be involved-in when you upgrade from on-premise TM1 10.x.x to Planning Analytics on Cloud. The good thing about cloud is that it comes with TM1/PA and all of its components like Planning Analytics Workspace, TM1 Web installed and configured. Meaning lesser effort. Also, all future release upgrades are taken care by IBM keeping you up to date with the latest and greatest. So let’s quickly look at the steps as you set yourself up: Welcome Kit Once the cloud servers ...

IBM Planning Analytics (TM1) vs Anaplan There has been a lot of chatter lately around IBM Planning Analytics (powered by TM1) vs Anaplan. Anaplan is a relatively new player in the market and has recently listed on NYSE. Reported Revenue in 2019 of USD 240.6M (interestingly also reported an operating loss of USD 128.3M). Compared to IBM which has a 2018 revenue of USD 79.5 Billion (there is no clear information on how much of this was from the Analytics area) with a net profit of 8.7 b). The size of global Enterprise Performance Management (EPM) is around 3.9 Billion and expected to grow to ...

This Blog details IBM Planning Analytics On-Cloud and On-Premise deployment options. It focusses & highlights key points which should help you make the decision; “whether to adopt Cloud Or stay on Premise” IBM Planning Analytics: As part of their continuous endeavour to improve application interface and better customer experience, IBM rebranded TM1 to Planning Analytics couple of years back which came with many new features and a completely new interface. With this release (PA 2.x version as it has been called), IBM is letting clients choose Planning Analytics as Local SW or as Software ...

Yes .. You read it right !! … IBM is ready to start “End of Support” for TM1 10.2.x version by 30th September 2019. IF you are a User / Owner / Stakeholder of any application which is on TM1 10.x versions then yes this would mean an immediate attention needed and would need necessary action. What does End of Support Mean ? Though End of Support (EoS) doesn’t mean your application will stop functioning but involves other risks. Few are listed below. No further development to this version. No further enhancement happening to this version.. No bug fixes. No new code updates. No more Standard ...

PM Hub – Why go Hub-less? As a part of Planning Analytics for Excel version 2.0.42 release on 13th May 2019, the PAX has gone PMHub-less, meaning it no longer requires Performance Management Hub, also known as PMHub. So what does that mean for you? But before that let’s first understand what roles does PMHub play in IBM Planning Analytics architecture framework. What is Performance Management Hub? To put it simply, it is a web based application in Application layer within a typical server framework and a web based user interface that provides necessary application services wherein ...

PAW Local Distributed is an upgrade to Planning Analytics Local Workspace that can be deployed in a container orchestration engine using either Docker Swarm by Docker or Kubernetes - an open source by Google, for high availability, fail-over, scalability, and fault tolerance in multiple application servers or virtual or even cloud machines. Architecture: The Planning Analytics Workspace Distributed is run on a Swarm mode by deploying the application on multiple Docker nodes (with unique node ids) also known as Swarm. Docker Engine CLI could be used to create a swarm and deploy and manage the ...

In the latest version of PAX (2.0.44) as well as PAW (2.0.44), IBM has added a new capability to allow the views to be shared between PAW and PAX using Planning Analytics Workspace Content Store. What does this mean for us? We can now save the views in content store and share it across to be accessed from either PAW or PAX which was not possible earlier. This further strengthens the integration and make the PAX and PAW interoperation even more seamless which a good step as far as usability and software portability is concerned. Steps to access the views from PAW content store from PAX: We ...

This article shows how to drill down to the next level in a visualization within Microsoft Power BI, when a filter is applied using a Slicer. This could be applied even if multiple selections are made within the slicer. For example – We have a car with 3 model series (L Series, S Series, T Series) in the slicer. Business requires to show the values at this level when no selection is made. Once a selection is made, the visual should show the next level in the hierarchy. Visualisation without any filter selected (Shows the top level): Visualisation with single filter selected (Shows the next ...

In this article, we will be seeing how to take a complete backup of IBM PAW and, also how to restore/revert the complete PAW Application using a backup. Environment: Windows Server 2012 R2 IBM PAW Version: 2.0.37 VMware: Oracle VMware Prerequisite Virtual machine for PAW should be up and running. Make sure to use the Root User ID for below steps. (What is Root User ID? Well, the user ID used for installing IBM PAW in that System and that user ID we are referring it has Root User ID here. In Case, if you are not sure which is root User ID then find which User folder the PAW VM is placed) Now, ...

With a variety of business intelligence applications at your disposal, it’s worth investigating the best and comparing your needs against each product to get the best return on your investment. Here are three ‘must-haves’. 1. Customisable workspace With a business intelligence application like IBM Planning Analytics, you can enjoy a single and consistent environment in which to manage your KPIs. So whether you need to measure business performance, evaluate and alter plans, expose gaps or test-drive the impact of potential scenarios on your business activity, you can do so in an interactive, ...

Despite the rampant growth of new data, constantly evolving technologies and the digitalisation of entire sectors, there are a few facets of business that will never be eliminated entirely: volatility, uncertainty and risk. But with business intelligence tools, you can keep your organisation on the right track and reduce the inherent risks of day-to-day operations. Here’s how. A complete, all-in-one business tool When seeking out a business intelligence tool to adopt in your organisation, you’ll want one with speed, agility and flexibility, so it provides a return on your investment. With IBM ...

The role of financial planners and analysts has expanded from assessing and reporting to data science. That’s why there’s a very real need to adopt the best financial planning software. Financial planners and analysts are now expected to have comprehensive knowledge of to access and collect information from business intelligence (BI), enterprise resource planning (ERP) and other data sources. But without the right software to support them, their struggles are compounded. The financial team’s daily struggles There are many issues that financial planners and analysts face on a daily basis, ...

The right business intelligence software can help companies beat out the competition and become market leaders in their industry. We reveal how to leverage three key benefits of business intelligence software - and overcome some potential drawbacks! 1. Integration across disparate business systems In order to derive the best strategic insights, you typically need to analyse data from across a number of different systems. Your company’s operational results, for example, require a financial perspective. That means your business intelligence solution should be able to integrate data from various ...

Whenever User enters data in Websheet (Form), last entered data will be present on Form. If User needs to enter new record, it becomes tedious to clear data from each of the text box, if Form comprises good number of text boxes. This will not be best way of utilizing User services. To avoid or improve efficiency of User, TM1 can be designed in better way using multiple Cubes. Create 2 named cubes, lookup cube (Test_Lookup) and cube which contains data (Test_Emp) Below are details of Dimensionality and structure of cubes Input Form where User can create new record, update record. Clear Button: ...

Most of the times business would like to generate reports in different formats to show data in different periods. They might be interested to display each set of data in different fonts, colors with capability of Row expansion. The easiest way to develop those kind of reports is, using TM1 Active Forms. To achieve this functionality using Active Forms, developer should know how to make each data set independent of each other so that none of them have influence of other. Let’s see how to create multiple active forms in single websheet as shown below: Above both data sets are displayed using ...

Picking the right business intelligence tools for your organisation is essential in the current era of big data. With information coming from all angles, it’s imperative to leverage the best software to make sense of your data and parse it into actionable, meaningful decision-making. Why do you need business intelligence tools? In their most basic form, business intelligence tools allow you to ‘see’ your data. This means you can watch how your data creates patterns and correlations. That information – including statistics and current trends – can then be used to formulate plans for the ...

In our hyper-connected business world, organisations are often siloed and sometimes spread across multiple locations. Combine that with the fact that the majority of employees are ‘hooked in’ to company-wide systems via their smart devices, and you have a raft of users able to access data and alter it. The problem? This often creates version-control issues that not only impact productivity and the effectiveness of your business intelligence (BI), but can harm your reputation and profitability. What is a ‘single version of the truth’? When discussing ‘truths’ in the form of BI, it’s important ...

Writing rules can save a lot of trouble also can be tedious sometime, but what’s more troublesome than writing rules?! feeders ofcourse. One or the other time we all have wandered in the “feeder”land thinking if there was a way out. No matter how efficient we think we write the feeders, there are times it can mysteriously lead to underfeeding or overfeeding. So, this blog explains the scenarios of how feeding a consolidation, feed from a consolidation work and how it contributes to overfeeding. And this can help to take different approach next time you think of feeders and make it not so ...

Predictive analytics: Predictive analytics is the practice of extracting information from existing data sets in order to determine patterns and predict future outcomes and trends. A way to predict the future using data from the past. Predictive analytics brings together advanced analytics capabilities spanning ad-hoc statistical analysis, predictive modelling, data mining, text analytics, optimization, real-time scoring and machine learning. These are tools that help organizations discover patterns within the data and go beyond knowing what has happened to anticipate what is probable to ...

This article talks about Business Intelligence and Business Analytics, things in common and about differences between one another. This blog also talks about the paybacks for an organization once these are adopted. Let’s start ... Though Business Intelligence and Business Analytics sound similar and are being used interchangeably by many, they do have differences. Business Intelligence ( BI ) :- Term Business Intelligence, though exist for long, have been used by wider audience from late 90s . Intelligence with in Business comes from the data being captured. Business Intelligence has been ...

As we have entered to this era of Data, we might be thinking that why is this Data Science field is so popular ?, why are companies and multinationals investing so much on this field of Data Science?. The answer is simple, because they are making profit out of it. This field has become very crucial and popular in todays market. Now let’s see the definition of Data science, according to Wikipedia Data science is a multi-disciplinary field that uses scientific methods, processes, algorithms and systems to extract knowledge and insights from structured and unstructured data. Some of the common ...

There’s no question that more and more enterprises are employing analytics tools to help in their strategic business intelligence decisions. But there’s a problem - not all source data is of a high quality. Poor-quality data likely can’t be validated and labelled, and more importantly, organisations can’t derive any actionable, reliable insights from it. So how can you be confident your source data is not only accurate, but able to inform your business intelligence decisions? It starts with high-quality software. Finding the right software for business intelligence There are numerous business ...

Smart businesses are seeking out new ways to leverage the benefits of their big data analytics programs, and the self-service model is coming up trumps. By placing the onus directly on business users, enterprises are empowering customers with insights-driven dashboards, reports, and more. But it’s not the only bonus. Arguably an even greater upside for organisations is that it alleviates the talent shortage that often comes with big data. With most companies only employing a handful of data experts who can deliver analytics insights to customers, the self-service model means they are freed up ...

Many businesses have already turned to Octane and partnered with us to help turn their data into meaningful insights. So if you've wanted to connect your Planning Analytics to Power BI, you're not alone and now with us you can. Octane has developed a way you can work directly with IBM Planning Analytics (powered by TM1) and Microsoft Power BI! We've had a number of clients who have wanted to integrate Planning Analytics and Power BI without using external proprietary software we at Octane can say that we've answered the market's call. Planning Analytics powered by TM1 is one of the worlds ...

Yesterday I was fortunate to attend an IBM partner day based on IBM Cloud Private for Data or ICPD and thought to write this blog for you who might not know what the platform is or does. This platform balances the individual data needs of your business by providing an integrated self-service, agile, enterprise-ready platform to significantly improve the governance around the collection, organisation, dissemination and analysis of your data but this isn't the best part. ICPD utilises modern microservices applications to enhance your data assets and analysis with machine learning (ML) and ...

What's interesting to note is that Planning Analytics Workspace (PAW) version 2.0.40 and 2.0.41 are combined so that the release of Planning Analytics Workspace 2.0.41 aligns with the IBM Planning Analytics for Microsoft Excel (PAX) release. With several fixes applied to both PAW and PAX in this version; this post will focus more on the enhancements and features. However, should you want to review the fixes, you can find those here. Features: With this release, you will now be able to create and edit drill through rules and processes in Workspace. Also finding users who don't have any ...

The long-awaited release of Planning Analytics 2.0.7 is finally here! I know a lot of you like me were eagerly awaiting this release and in particular wanting to get into the nitty-gritty details of all the documentation and testing. Luckily for those that are not, I have summarised it all into the below — so happy reading there's lots for you and your team to consider. With this release comes some significant enhancements which I'll get to in the section below. We will also part with several items which are marked for depreciation, replaced in some shape or form. As IBM advises: Updates to ...

Forward-thinking enterprises are using business intelligence and analytics to navigate through their digital transformation – one that could see them expand both physically and fiscally at a rapid pace. The ability to harness this data and use it to make business decisions, however, poses challenges. This is particularly true for organisations that haven’t previously had the technology nor the manpower to sift through all the historical data they’ve accumulated in their daily activities. Think about it – by 2020 it’s predicted there will be 5,200GB of data for every individual on the planet. ...

The prevalence of artificial intelligence (AI) can be felt across countless industries, with the technology helping businesses modernise through automation, business analytics, strategy and more. Even governments are recognising how critical AI is to the future of enterprise, with the 2018-19 Australian federal budget committing $29.9 million over four years to bolstering our AI and machine learning (ML) capabilities. So it’s clear that AI is here to stay. But how can you use AI to derive actionable business insights? After all, the point of adopting any technology should be to use it to your ...

In this article we will quickly go through the steps required to make your excel calculation mode defaulted to ‘Manual’. When working on websheets, it is advisable to keep the calculation mode to Manual to prevent repeated recalculation of formulas for any cell change when the calculation mode is Automatic. The default calculation mode could be set to Manual by following the below steps: Step 1: Close all excel workbooks and open a new workbook. Step 2: Change the Excel calculation mode to Manual (File - Options - Formulas) Step 3: Save the workbook in ...

You heard it right – Is your organisation still on TM1 10.2.X and haven’t upgraded to PA? If yes, this is the blog for you as your existing TM1 application is prone to Multiple Security Vulnerabilities … Blog tries to reflect upon the cause and effect of the issue/s, possible interim remediation plan/s and the foolproof solution. Security Vulnerabilities Customers who are still using the IBM Cognos TM1 10.2 and IBM Cognos TM1 10.2.2 are prone to unauthenticated attacks, excessive stack memory issues and other threats. Listed below are the security Vulnerabilities; OpenSSL could allow a remote ...

Thank you if you have come back for more! Hope our last blogs of this series Unravelling TM1 : Lesser Known Facets – Part A & Part B were meaningful. In this part we will unearth & explore few more of these lesser known gems. As always, if you like what we do and want to associate; subscribe to our Blogs at http://blog.octanesolutions.com.au TIP 7: Uses of User-Defined Global Variables User-Defined Global Variables declared within a TI using functions StringGlobalVariable (for string variables) and NumericGlobalVariable (for numeric variables) though rarely used and meant for specific ...

Business trip to Australia… the prospect itself is enough to make a dead man stand up and dance. More so as Swetha, Sasi & I were travelling to be in 2 of the worlds “best cities to live in. We visited Perth & Sydney; No..no 3 cities in fact, we transited via Melbourne airport. I know what you thinking, but it does count as we got to “check-in” Facebook... Haha, see SMART!! Before I start, very important to note the itinerary we were on as it boosted our flaunt status back in India! Why ?? Well it had so many check points and an envious schedule which had us touching 4 countries & ...

This Tuesday (25th Sep 2018) Octane Solutions proudly hosted a meeting for Senior Finance, IT Executives and Experts representing various companies and industries. The event was kicked-of by Mr. Amendra Pratap (MD, Octane Solutions) and Mr. Thomas Maddocks (ANZ Software Sales Leader - Commercial, IBM). This was followed by a solution demonstration conducted by Mr. Kevin Jessop (Lead FPM Solution Specialist, IBM) and a panel discussion. Thank you to all who attended our Executive Breakfast event; We were pleasantly overwhelmed with the response and excitement in the room. Redefining Planning ...

Thank you if you have come back for more! Hope our last blog Unraveling TM1 : Lesser Known Facets – Part A was meaningful. In this part we will unearth & explore few more of these lesser known gems. As always, if you like what we do and want to associate; subscribe to our Blogs at http://blog.octanesolutions.com.au Function TM1RPTROW We know TM1RPTROW is a salient function when building demand and rolling forecasts in Planning and Budgeting models Although everyone is aware of the fact that parameters like Dimension Subset, MDX Expressions are a part of TM1RPTROW, developers tend to ...

No matter how much we think we know about TM1, there are always these set of conditions that make you think “what-if there was a better way”??!! For example, not having to write a bunch of codes just to delete the subsets after using it in a Source View Or not writing the same area definition twice. What-if this could be done with less or no coding at all! This blog and its subsequent part will focus on showcasing few of such many lesser known features in TM1. These little tricks and tips are a step towards better code management and of course peace of mind. TIP 1. One area definition for two ...

Welcome back, for those who had read Part A of this blog, hope you would have tested Parallel Interaction and benefitted from it. For those who haven’t, you can read it at http://blog.octanesolutions.com.au/caveat-around-concurrent-data-loads-part-a This blog builds upon the previous one and focusses on improving performance by Parallel Interaction, it highlights TM1 facets worth consideration while an object is locking. Synopsys Tips towards improvements around support for concurrent read/write and/or parallel execution of turbo integrator process enabling higher efficiencies and ...

IBM has recently launched its Planning Analytics version 2.0.5 (on 25th June 2018); this article captures highlights of what’s new, improved and denounced. New / Improved/ Deprecated Features & Fixes: - New: Planning Analytics Administration agent. Totally new, part of IBM’s strategy to brand PAW as a Single interface for all types of users. In this release, once PAA agent has been configured, it enhances Planning Analytics Workspace user’s interaction with metadata and data. Helps users to drag and drop dimension members to achieve new Dimensions, Attributes. Users can drag and drop ...

I want to keep this blog very simple so that people who do not know the concept of blockchain can understand it. Target audience – anyone who can read English. What is a Blockchain? In very simple terms blockchain is a chain of blocks where a block means data. A more sophisticated definition was given by Don & Alex Tapscott, authors Blockchain Revolution (2016): "Blockchain is an incorruptible digital ledger of economic transactions that can be programmed to record not just financial transactions but virtually everything of value." Most of you might think, there we go again, why another ...

One of the most neglected and least prioritised activity among the grand scheme of development, in my opinion, is applying correct formats to data, both in cubes as well as standard web reports. In all fairness, if you’re one of my kind (occasionally-fall-into-a-slack type) who often miss out on this detail, then you have arrived at the right place. In my defence, I still feel that given the number of data points that one must apply formatting, it is only natural to miss a few, which then gets picked by business in live environment. Well, this blog is all about how you save yourself from such ...

In TM1, if a TM1 Cube has huge of volume of data and rule calculation, there is possibility that TM1 takes longer time to open a cube view, to look at the issue with performance would be TM1 View Caches (Stargate Views). The Stargate view contains only the data for a defined section of a cube and does not contain the formatting information and browser settings that are in a view object. The purpose of a Stargate view is to allow quicker access to the cube data. To fine tune and control the Stargate Views, TM1 provides couple of settings namely VMM (View Maximum Memory) and VMT (View Minimum ...

With users unceasingly (almost perennially) demanding higher data upload speed and concurrent transfers, this blog offers insight and considerations one should keep in mind while simultaneously executing a Turbo Integrator (TI) process. It also highlights steps to avoid TI looping and/or thrashing. Synopsys Consider a single user loading data into a cube from source (such as ODBC, Text files, another Cube, etc.) via a TI process for a specific data segment such as a given scenario, period & component, may not experience any wait times. However, when it comes to concurrent users ...

While working for a particular client project, I was asked to review an existing long running Turbo Integrator (TI) process and find out ways to optimise its processing time, without compromising on the business functionality. Synopsis: A process was created to adjust the amount between cost centres and products based on defined From and To mapping in a mapping cube. A simple example could be, amount from one cost centre be adjusted to multiple centres within its division or a consolidation of centre within a division mapped to same consolidation but for a different product. To achieve this, ...

In this blog, would like to introduce you to a new feature called "Compare Sandboxes"; this feature, an extension to Planning Analytics Workspace’s existing capability, shall be available both on Cloud and in Local versions. What is a Sandbox? (Jump to “Feature Explained” section if you are an existing TM1 user & know this well) A Sandbox lets you create your own personal workspace, your own version where you can enter & store data-value-changes without impacting the base (actual) data. A sandbox is not a copy of the base data, but a separate overlay or a layer of your own data values ...

The last 3 weeks has been great in that it has showed an avenue that I had yet to explore in Planning Analytics, debugging. To say it has been highly frustrating at times is an understatement, however I know I only get stressed when I’m learning a difficult concept. It sometimes hard when looking at code that isn't' documented, exactly why this or that piece of code is necessary. Debugging work has benefited me in understanding and developing a methodology to enable me to learn the overall logic and flow of a model/system. Understanding and being able to follow personalised instead of best ...

If you haven't seen already the latest version of Cognos Analytics is now available for you to download. Luckily you won't need to read the about the latest changes. You can view this youtube clip which will explain what's new in it's reporting, dashboarding, stories and the portal for IBM Cognos Analytics 11.0.11. If you don't have the time some advanced features include using custom polygons and points for mapping. Also included is data caching in dashboards and stories, as well as support for Portal Pages, and controlling object visibility. To download the software you can find the ...

Let me preface this blog by saying that my trip to India was so insightful, culturally rich and filled with great people that it was hands down the work trip of a life time. Amendra may have had other plans but for me this trip was about creating new connections and deepening my understanding of our cross border colleagues from all our offices. Upon reflection I can easily say that we weren't colleagues for very long and are now people I consider friends. Well some of them, in-particular those who didn't want to Shoot me?! I still don't know where the finger guns came from but I suspect thats ...

Most who are still on Cognos Business Intelligence software version 10.2.x would know that the software version was due End of Service this April 2018. It was quite dreading for existing users who had not planned an upgrade to Cognos Analytics (or C11 as it is called within IBM) just yet as it wasn’t really a straight forward version upgrade but a complete overhaul in the way you would interact with Cognos BI; more intuitive, user friendly and insightful but requires a bit of learning and a little more unlearning. GOOD NEWS!! IBM has just announced a new support option – Continuing Support ...

In this blog, let me explain you about one of the hidden/unused feature from IBM Cognos TM1. Before we start, let me ask you a question - Have you ever come across below requirements or related issues while working with TM1? Urgent requirement - Management needs new consolidation within a Canned report to meet their business needs. An Ad hoc requirement from business to get new consolidation member at the earliest. An alternative roll-up request from the Boss - for a better analysis using existing data. Stakeholders request to have additional consolidations which may be part of ad hoc ...

For starters, God's algorithm is a notion originating in discussions of ways to solve the Rubik's Cube puzzle, but which can also be applied to other combinatorial puzzles and mathematical games. It refers to any algorithm which produces a solution having the fewest possible moves, the idea being that an omniscient being would know an optimal step from any given configuration (source wiki). With the constant barrage of messaging these days, almost pushing you over to adopt cloud, does the choice between “To Move” or “Not To” almost feel like cracking the “God’s Algorithm”? Well, hopefully by ...

This blog will cover an information regarding moving the data between cubes using Rules and Feeders. Questions to be asked before we get started with the topic... Why do we need to move the data to another cube which is having similar dimension structure….?? Can’t we just modify the existing cube….?? Answers “we can modify the cube” and “there is no need to create a duplicate cube “, although there can be a few exceptions like dependent cube(s) which might have been used to create report which sometimes a client may request not to modify. Ideally the data can be moved between cubes using TI ...

One of the major challenges of promoting code to successive instances is packaging the code for promotion and finding a slot for downtime. Not to mention the sequence of steps required to carry out the procedures and to communicate to one and all about the impending downtime. Adding to this difficulty is finding downtime when users are accessing the application from across the globe.So irrespective of deployment size, either major or minor, the deployment process is never going to be easy. However you can potentially overcome this using one of the TM1 Suite tools. To achieve this the ...

In this weeks blog, our team make it our duty to shine some light on right tool your company can choose to meet your business needs. We will cover the much discussed benefits of installing and using IBM's Planning Analytics workspace on Windows 2016. Contents What is PA and PAW PAW and Windows 2016 Benefits on PAW on Windows 2016 What is PA and PAW? Planning Analytics ("PA") is the next version, or can be considered as the next generation of TM1. IBM enhanced TM1 functionality and features and embraced new tools to its' suite. This new enhanced TM1 has been rebranded as PA. IBMs PA has the ...

Contents How to Create Dynamic Parameters for TM1 How to Build a Scorecard using TM1 Architect How to Enhance TM1 Security on a 'Need to Know' Basis How to Use Stargate Views for TM1 Cube Viewer How to Create Dynamic Parameters for TM1 The CheckFeedersMaximumCells is a dynamic parameter that allows users to restrict and control performing check feeders operation in a cube for a selected number of cells. As per the documentation, the default value is 3,000,000, meaning feeders for consolidation with up to 3 million intersections could be checked against, by default. Case in point: I’ve added ...

As business implements more and more technology to streamline their operations the benefits of saving time, minimising costs, increasing productivity and better accuracy are starting to be realised. This means this is hardly a trend that will fade anytime soon. If you or your business are not 'there yet' it’s better to catch up now rather than being left behind with the rest of the competition. We've moved on from the times when cloud technology was an unknown territory for especially for Accounting and Finance but the industry players are now fully aware, prepared or in cloud. This leaves us ...

The last week have been great in that I have been grinding away at our Planning Analytics + Workspace work and preparing myself for workshops and presentations. I am happy with how it is progressing in terms of content and the approach that we are taking. Working from home for majority of the last week has been a saving grace too. The extra 2 hours I get that isn’t wasted in commute into the office is a gift. The transition from office environment back into the hibernation cave of home and actually being able to complete work productively I thought would be more of a challenge than I have ...

It has been an interesting last month of slow but steady improvement in my TM1 / Planning Analytics journey and soon I'll be off to to teach a small team about how to use Planning Analytics + WorkSpace (PAW). It should be interesting considering I am relatively new with the product and now have been tasked to teach others how to use it! I’m not too worried about it however, last week I spent sometime with the client and Martin; who's taught me that I can handle myself under those situations, especially with the knowledge he has given me and what I've learnt about the product. I think the ...

As a TM1 consultant, one of our challenging tasks is improving performance. Often dynamic subsets cause memory leakage and in turn affect performance. Let’s discuss, how to convert dynamic subset to static subset with an example. For Example, the “account1” dimension in SData instance has dynamic subset called “All Members”. Any operation done in the dynamic subset like delete/insert, will make subset has static. The below snippet of code to covert the dynamic subset to static (TI process can be downloaded in the bottom of the blog). Before running the above code After running the above code ...

Good bye 2017! We're about to set our new year resolutions, and ready to jump into 2018! Not without some hard earned rest though. Next year like every year though undoubtedly you'll come across the same problems as this year, and maybe a couple of new ones but it's this guide that I hope you read and come back to because when I've done so it has helped me. So.... In 2018, your 8 steps to SUCCESS will be 1) Get things done The first step as a manager or developer that you need to deploy is embodying a culture of accomplishment, which will help you as success leads to success. Next year let's ...

Loss vs Gain? As we know – one thing that is constant is change and in the technology the change is always for the advancement from current and improvising the existing features. IBM has made significant changes to its Financial Performance Management product and has rebranded TM1 to IBM Planning Analytics. Rebranding TM1 to Planning Analytics does not mean you are going to lose existing tools like Architect, TM1Web, Perspective, Performance modular, Insight etc. IBM has enhanced the existing tools and improvised them. Few among many are listed below. The Cognos TM1 Web UX is totally ...

IBM Planning Analytics Local is the new version of TM1 which was released by IBM in December 2016. IBM has rebranded TM1 to IBM Planning Analytics Local. Get used to using the name Planning Analytics instead of TM1 IBM Planning Analytics is a fast, easy, flexible and complete self-service planning and analytics solution, build on a modern cloud architecture, using as its core, a new generation of the proven TM1 in-memory calculation engine. IBM Planning Analytics is available both as an on premise and cloud based solution. Below is the list of features added to the new version of TM1 aka IBM ...

Although we as devlopers solve problems and that gives us a feeling of success and empowerment, I landed on the realisation that by documenting a problem not just jumping in and fixing it; helps make better decisions. Ok now some of you might ask How did you get there? Others might say well yes of course. I'd like to think that it’s not for any of the obvious reasons you might think of. Let's see. Not all problems will provide a eureka moment but a couple, even one on a particular subject can lead to the formulation of a business transformation initiative. Yes it's happened and while my heart ...

How to utilize TM1 Planning Analytics functionality for your Technology Allocations Allocation Technology and other Service charges back to the departments is typically a difficult exercise for most organisations. There is a large amount of different data sources , data mapping, calculations and reporting capability required. This is just for the actuals – forecasting accurately is usually a bridge too far for most organisations. It does not have to be this difficult! Why do we need to allocate charges – It largely influences the behavior and ensures that departments incur appropriate level ...

As the CFO of your company, your organisation relies on you for more than just numbers. Yes, spreadsheets and financial reports are the hallmarks of your profession. But what about business intelligence and forecasting? Today, the explosion of data available in business matches the explosion of competition in today’s markets and CFOs need to harness that wealth of data to compete. CFOs need better business intelligence tools to identify upcoming opportunities and grab them before their competitor does. They also need to foresee potential losses and advise on how to mitigate risk. In short, ...

IBM Cognos TM1 supported by Planning Analytics is the ideal technology for making Excel-centric budgeting, forecasting, financial reporting and any spreadsheet-based analytical application scale to the enterprise. IBM's TM1 for Microsoft Excel brings the power and familiarity of Excel to the arena of modern enterprise performance management. Planning Analytics, on the other hand, enables business and financial analysts, line-of-business managers and others to explore and analyse data from a variety of different sources—including IBM Cognos TM1 and IBM Cognos Business Intelligence—without IT ...

Is your organisation not realising the full potential of your IBM TM1 implementation? A quick and easy way to increase your productivity, reduce cost and risk is to ensure your users are properly trained in your TM1 model. The best deployed TM1 models can have limited engagement and usefulness if your users are not using it properly TM1 models are built ground up and almost always unique to the organisation so a stock TM1 training usually does not help. 4 Key features of a effective TM1 training delivery Training is tailored to the needs of your users - Almost all TM1 models are unique to ...

In this article is not about being a master and his trusted advisor, this is about trying to find out what are the necessary traits for a successful consultant. I'll be comparing the ideas of 'Master of one' Vs 'Jack of All' Vs 'Master of All'. Let's start from the last one 'Master of All' and with a bit of self reflection, do you really think it is possible for anyone to be a master of everything? I am not quite a believer of this, although, theoretically it is possible but practically in the ever changing world it is impossible to master all the technologies because human psychology says ...

Often times, when we as a developer are loading the data from a particular source and intend to create a view to debug the data for analysis and troubleshooting, typically we do it by creating the view and subsets and assigning the subsets to the view in Prolog tab. The elements from the source are then added to the subset in data tab by using SubsetElementInsert function. This will work seamlessly as long as there is only one record for one element in the source. As soon as the TI encounters multiple records of each element, it starts to add that element again in the subset resulting in ...

By default a numeric value in TM1 is 0. If an attempt is made to store a zero in a cell of the cube, that storage request is ignored. If we input 0 for an intersection, TM1 treat it as NO value instead of 0 value. Instead we can use the UNDEFVALS function. This is to be defined in the Rules file which will enable the end user to input 0 value. Scenario Let’s create a simple cube with 3 dimensions Cube Name: Test Dimension: Actvsbud Region Month Fill up dummy values in cube for the intersection, Actual, all the months and United States Region Open Rule file for Test Cube and type UNDEFVALS; ...

It's hard in our industry particularily when when starting to guage how good you are or how much you know in relation to the products, especially when you don't get to mix and mingle with other Planning Analytics or TM1 developers. Worse is that you don't get to see / hear about other implementations / environments. The aim with this blog is to feature every so often different things you can do to keep work feeling fresh, help, and to push you in different directions. You don't necessarily know how good you are if you're not covering off the basics. So lets start there. Step 1: Can it be done ...

With today's increase in data volumes it is becoming more important to handle the high demand (either loading or accessing) of data conccurrently or in parallel. This blog will assist you by noting the benefits, enabling the functionality, as well as giving you an example. Let's start with the what parallel interaction / concurrency is and it benefits: It's a IBM server feature allowing concurrent operations (read/write). The concurrency operations can be performed on the same cube object. Writing to a cube will not lock it. This means that it will not wait for readers using the same cube to ...

I have been closely following and writing about trends in the business intelligence market over the past three years. During this time, I can’t say that we’ve seen any “radically new” trends, and I don’t expect any to emerge in the second half of 2017. What I have seen, so far in 2017, is the “evolution” of the dominant trends driving a dynamic BI market. The global business intelligence market is expected to reach USD 26.50 billion by 2021, growing at a CAGR of around 8.4% between 2016 and 2021 (Zion Market Research). Here are the 5 BI trends predicted to most influence the BI market in 2017 ...

This may be the most cost effective and scalable method to take your TM1 application to the next level. There are many reasons why outsourcing your TM1 support and development could be the right solution for your organisation: - Access to highly skilled TM1 developers on demand in a cost effective way - Models built a couple of years ago haven't evolved with the business - Lack of ownership within the organisation - Shortage of skilled TM1 specialists capable of managing the application In today's blog, we would like to list and discuss the five key benefits of outsourcing your TM1 support ...

IBM is truly living up to its principles of a focus on customer outcomes, restless reinvention, and diverse empowered teams. I believe there is no better reflection of this that IBM’s latest release of Planning analytics (powered by TM1) No one anticipated that the next iteration would be a such a quantum leap forward. Both in terms of intuitive use, and cutting edge looks; it is refreshing to see IBM invest in this software to bring it ahead of the competition. That’s right I said ahead. To start, with certain installations you will be able to integrate with Watson, that’s right Watson! ...

Element Security is to set security at dimension element level. Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object. Element security will be defined in} ElementSecurity_.cub. By default element security is set to WRITE access to all the members Different type of Access Privileges Admin: Members of the group can access, update, reserve, lock, and delete the element. They can also grant security rights to other users for this object Lock: Members of the group can view and edit an element and can ...

The TurboIntegrator Debugger is a simple tool which allows users to set breakpoints and step through TurboIntegrator processes to identify possible issues or errors in your scripts. The TI Debugger is available for Planning Analytics Local. Steps to configure TM1 Server can be found in the link below: https://developer.ibm.com/recipes/tutorials/ibm-tm1-turbointegrator-debugger/ KEY FEATURES Process List User specified breakpoints View object locks on the TM1 server Save and edit TI scripts live INTERFACE The interface is very simple and user friendly with familiar tabs like Prolog, Metadata, ...

As per the IBM’s guidelines, the following points must be taken into considerations pertaining to Planning Analytics on Cloud. The tm1s.cfg file must exist in the base directory Any folders that you create must be below the base directory The location or the name of the base directory cannot be changed The existing tm1s.cfg file must not be replaced from another server. Link: https://www.ibm.com/support/knowledgecenter/SSD29G_1.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.10.3.0.doc/c_tm1_cloud_faq.html In addition to the above, the following config parameters in tm1s.cfg file must not be modified ...

Sandbox, also known as Personal Workspace is your personal work area where you can edit the data values as many times as you want and keep the changed data separate from the base data. Sandboxes and Personal Workspaces are private to each user and cannot be seen by other users. Your data values are viewable to others only when you commit them back to the base data. A Personal Workspace is a special, default sandbox that is unnamed and always where you work if that capability is turned on. To find out more about Sandbox, go the following link: ...

In TM1 rules, an alias could be used in defining the target area (area definition), within rule calculation as well as in Feeders. However, few things must be kept in mind when using Alias in the Area definition of the cube. As the rule is now using the attribute value to dictate the rule calculations, it adds a potential risk of inadvertently updating the alias by the users thereby resulting in incorrect calculations. This could be mitigated by applying security on control objects. TM1 establishes cube dependency as the calculations are now dependent on alias values which resides in a ...

TM1 / Planning Analytics is a robust tool. Typically with other software vendors you need to rely on 3rd Party applications to test. This is not the case with TM1 depending on the type of testing you need done. There are 3 major factors that need to be taken into consideration to define whether you are doing adequate software testing time, cost, and quality. Time and cost is easy to measure but the hardest thing to measure is quality. Especially with manual testing or human testing. In executing the same steps over and over we tend to find short cuts for not doing things the right or long ...

Choosing or even switching consulting companies is never an easy choice. Sometimes competitors make that easy be ruining relationships but being the newest on the scene also comes with inherent challenges. Although we have the best in the business, and we are landing new large clients being the latest player in the market is hard. Especially with customers who think all consultants provide the same. At times Price seems to be the only way a customer tries to tell us apart but what’s on offer is always VERY different. So here we are doing something else different, let us tell you about the ...

The simple answer to what makes a good TM1 consultant is anyone who can do their programming in turbo integrator, write business rules, feeders, and perform an installation of TM1. Can it really be that simple? If those are the qualities of a consultant then what does it mean to be a TM1 developer? This is where the confusion starts. If the above are qualities of a TM1 developer (which is the first stage of becoming a TM1 Consultant) that means we are yet to discover the answer to the question. Know that the expectation of a consultant is over and above that of developer. So what should you ...

Background Virtual Dimensions will change the game of Analysis with Planning Analytics (Powered By TM1) You can use Product, Customer or Employee Attributes in your slice/dice/pivot tools as ‘Virtual Dimensions’ without having to physically define them as a dimension when creating the cube You can add virtual dimension at any time after the cube exists, so your analysis opportunities are endless Cubes can now be half the size and twice as fast bec ause you don’t need physical dimensions to drive analysis And further, you can add fresh new data to your analysis ‘On the Fly’ with no disruption ...

What happens when a user attempts 3 incorrect passwords in TM1? When the user attempts the 4th time he/she will get a message saying: “The maximum number of login attempts has been exceeded” How do we resolve this? Option 1: Admin user to go to Security and then to Client/Groups And then clear that user’s password and re-type a new password And then shoot an email to the user saying your temp password is xxxx and please follow the steps to change your password (which is for the user to login using his new temp password and then go to Security and select change password) Option 2: Another ...

TM1 has got multiple control cubes. One of the control cube which was introduced with the release of planning analytics is }StatsByRule Control cube. With the help of this control cube a number of rule related stats can be viewed This cube has got 3 dimensions }Cubes – Each cube on the TM1 server is included as an element in this dimension }LineNumber – elements 1 through 10,000. The elements correspond to line numbers in a TM1 rule. }RuleStats – Contains elements that correspond to the information and statistics that are stored for rules on your TM1 server, Including Element Description Rule ...

Budgeting and Forecasting is a key function provided by the Finance team. Its no secret that most of the teams dread the budgeting period. Not only it ends up being a manual data crunching and bogged down in spreadsheets it also is a soul destroying exercise as many Finance professionals go through the motions knowing that the numbers they are generating are not relevant and cannot be reliably used to make key enterprise decisions. Organisational complexity is growing. Business demands more insights, better granularity and driver based projections. With evolving business environment ability ...