Here at QueBIT, we have developed hundreds of solutions for our clients. That’s as expected, it’s our business! We strive to get input from business users prior to implementing their new systems. Standing up a new, automated solution (planning, sales forecasting, or operational) is exciting, and can be transformative for an organization and its employees. We don’t want you to have to re-create the wheel, when implementing a project. If you’re looking at automating a new system, here’s a cheat sheet to help you avoid common pitfalls.
If you’re a TM1 user, you know rules are how you work business logic into your model. You probably calculate things like salaries and sales, and you may even have more complex calculations in your model such as exchange rates and allocations.
Organizations using IBM Cognos TM1 have many options for front-ends. There are a lot of good options out there, including some important new arrivals. This post discusses one of the newer front ends, Café, that has some useful new properties heretofore unavailable, most notably, the ability to utilize TM1 in Excel over a Wide Area Network (WAN.) Anyone that’s ever tried to use the Excel Perspectives add-in over the WAN will appreciate this new capability!
IBM Cognos TM1 is a great planning, forecasting and reporting system. One of its functionalities is to communicate meaningful results to different stakeholders. Many types of reports are used as a vehicle to achieve that goal. One of the common ways to drive most reports is with the DBRW function. While some users are familiar with it, most users only notice the function when they see the error message “*KEY_ERR.”
Effective dashboards form the backbone of a powerful business intelligence strategy, as well as the essential entry point in becoming an analytics-driven organization. Dashboards support fast and effective decision-making, provide valuable insight into key performance indicators, and make reporting simple and fast.
Over just the past few years, technology has created a massive shift in how finance organizations operate and how they’re expected to perform. For more than 20 years Excel has led the field as a business finance tool, but now alternative tools such as Google Spreadsheets and a variety of BI software platforms have matured and begun to edge into Excel’s business. At the same time, new financial modeling, database, and analytics software has entered the market to provide deeper, real-time capabilities that help companies optimize every aspect of their business.
According to an April 2015 survey, fewer than half of finance leaders are satisfied with their organization’s budgeting methods. This will come as no surprise to anyone who has been involved in the lengthy, sometimes mind-numbing process of assembling and re-keying data in order to create a budget document that may simply be set aside as soon as it’s complete. Some organizations require as much as eight months to complete the budgeting process, at which point all of the painstakingly collected data is eight months obsolete.
Nobody intends to create a cumbersome labyrinth of financial modeling systems, yet it happens to even the best of organizations. As the business adds new departments, software, and leadership, financial models are pasted together to meet growing needs. Each team uses data from ERP, HR, General Ledger, and other systems in order to create reports and make decisions. Unfortunately, the larger the organization grows, the more disconnected the models can become.