Blog

QueBIT Blog: Grading Your TM1 Application

Posted by: Robin Stevens May 2, 2017 9:15:00 AM
TM1 is a powerful modeling and analysis tool.  It can handle extremely large amounts of data – transactional data, revenue and cost on millions of products, workforce planning for thousands of... Read More

Robin Stevens

Recent Posts

QueBIT Blog: Top 5 Implementation Pitfalls

Posted by Robin Stevens

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.

Read More

QueBIT Blog: TM1 Design Pro-Style: Rules vs. TI

Posted by Robin Stevens

TM1 Design Pro-Style: Rules vs. TI

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.

Read More

QueBIT Blog: Perspectives + Cloud = Café

Posted by Robin Stevens

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! 

Read More

QueBIT Blog: Mastering the TM1 DBRW Excel Function

Posted by Robin Stevens

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

Read More

QueBIT Blog: Three “Little” Dashboard Guidelines that make a big difference

Posted by Robin Stevens

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.

Read More

QueBIT Blog: Excel & Business Intelligence

Posted by Robin Stevens

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.

Read More

QueBIT Blog: Three Ways to Justify an Investment in Budgeting & Planning Software

Posted by Robin Stevens

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.

Read More

QueBIT Blog: Five Benefits of an Integrated Financial Model

Posted by Robin Stevens

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.

Read More

Blog Search

Subscribe to Email Updates

Follow Me