In this article we delve into the DBRW function in IBM Cognos TM1. Read on for our rundown of what it is, when to use it, and how to fix it when it's broken.
Gary Quirke and I had the pleasure of organizing and presenting “A Power Users' Guide to the TM1 SDK and Planning Analytics” at the 2016 IBM Vision conference on Orlando, Florida. Our goal for the presentation was to provide attendees with a picture of the possible with the TM1 SDK, targeted toward both non-programmers and programmers who simply want to understand the alternative ways in which we can solve real business problems, new and old, using the powerful TM1 SDK tools that IBM has provided, which include the REST API, Java Extensions and TM1 Web APIs. We received very positive feedback, so thank you to everyone who was able to attend!
Try Googling “TM1 Performance problem” and a lot of advice comes up. Some of it contains useful information, for example http://www-01.ibm.com/support/docview.wss?uid=swg21454290.
And then there is the “shot in the dark” stuff like this which is only helpful if your problem happens to have this one cause (and is useless otherwise): http://pic.dhe.ibm.com/infocenter/ctm1/v10r1m0/index.jsp?topic=%2Fcom.ibm.swg.ba.cognos.tm1_api.10.1.0.doc%2Fc_tm1serverperformance_n802b4.html
TM1 10.2.2's release was, probably not coincidentally, in advance of the IBM Vision 2014 conference in Orlando. Continue reading to find out more about the release.
TM1 Brings Light to Emergent BioSolutions’ Financial Planning and Forecasting
For a lot of finance departments, the thought of sitting down to prepare the annual budget can send shivers down spines. After all, budgeting and planning season can be a messy endeavor, full of tabbed Excel spreadsheets, back-and-forth budget approval requests, and a MASTER budget sheet that needs constant corrections before it is finalized. All of these tasks are issued manually through email requests and via the physical distribution of documents and reports. And to make matters worse, there has to be swift coordination between all business units, as well as the executive management teams.
What if budgeting didn’t have to be so complicated or error-prone? Emergent BioSolutions—a global specialty pharmaceutical company—found out the night-and-day difference that an automated, integrated budgeting and forecasting solution can make. It represents a complete cultural change for Emergent. This exciting transition meant going from static, once-a-year budgeting and forecasting, to a dynamic, rolling forecast.
According to Felipe Alcorta, Director of Financial Systems & Analysis, “We are constantly on a rolling forecast. 9 months into the year, we’re already 3 quarters of the way to establishing a budget before the planning period actually begins.”
There are seven learning styles that make it challenging for instructors and design teams to meet the individual learning needs of their students. In order to provide an effective training class, you need to incorporate:
This article will give you a high-level overview of TMQ and what it means for your TM1 Applications. Read on for an introduction to some of the research QueBIT Labs is doing to maximize the benfits of MTQ.