Revelwood

Your SUPER-powered WP Engine Site

TM1

Tips & Tricks for using IBM Planning Analytics – Creating TM1/Planning Analytics Picklist Cubes

by Leave a Comment

This is a guest blog post by Revelwood’s Shane Bethea.

Did you know Picklists can be used in TM1/Planning Analytics to allow your users to pick values from a predefined, non-changing list of values?  These can be setup as a static list of values, a subset of values from a specific dimension, or all elements within a specific dimension.

Picklists can be associated with a dimension in situations where the definition is always the same.  An example of this would be a Payroll model where you want users to assign each employee to a pre-defined list of job titles.

Picklists can also be created with more flexibility for situations where you want a fluctuating set of definitions.  For example, you may want to have a list of pay period start dates based on the pay method selected for that employee.  If the pay method is monthly then your list can include one set of dates whereas a bi-weekly pay method would entail a second set of dates.  This approach can be created with a Picklist cube.

To create a Picklist cube in TM1/Planning Analytics, simply right click on a cube where you want to have the Picklist and choose “Create Pick List Cube”.

The resulting Picklist cube is created with the name ‘}PickList_<CUBENAME>’.  The new cube will have the same dimensionality of the existing cube plus one extra dimension called }PickList.

Once created, rules can be written for the Picklist cube to determine what values are available in the list.  The example rule below will populate the Picklist value with one of three definitions based on the selected pay method.

Once the Picklist cube and rules have been set up in TM1/Planning Analytics, users will see a different set of dates for the Pay Period Start Date measure based on the method selected for each employee.  This is one example of creating a dynamic Picklist using Picklist cubes, but the possibilities are endless.

IBM Planning Analytics is full of new features and functionality. Not sure where to start?  Our team here at Revelwood can help.  Contact us for more information at info@revelwood.com.  And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Interested in more tech tips for TM1 & IBM Planning Analytics? Check out these blog posts:

IBM Planning Analytics: Using the Full Power of MDX

Creating URLs for TM1 Websheets

Home » TM1 » Page 36

Technical Bulletin: End of Support Dates for IBM Cognos TM1 10.2.x

by Leave a Comment

IBM recently announced the official End of Support dates for two of the IBM Cognos TM1 10.2.x versions:

  • IBM Cognos TM1 10.2.0 will reach End of Support on 2018-09-30
  • IBM Cognos TM1 10.2.2 will reach End of Support on 2019-09-30

By now, most TM1 users are aware of IBM’s transition from IBM Cognos TM1 to IBM Planning Analytics. Planning Analytics contains the full functionality of TM1, including both Excel and Web interfaces, so the concept of migrating can be as simple as upgrading your TM1 version. Planning Analytics currently allows users to continue using both Perspectives and TM1 Web which gives you the opportunity to migrate in phases:

  • Existing Excel reports can use your current Perspectives approach and be migrated to PAx (Planning Analytics for Excel) at a later time
  • Existing Web reports can use your current TM1 Web approach and be migrated to PAw (Planning Analytics Workspace) at a later time

 Planning Analytics Migration Resources:

We’ve created multiple resources including on-demand webinars featuring product demonstrations and technical blog posts to help you understand the opportunity presented with this migration, plan your strategy and make the transition. Migrating from IBM Cognos TM1 to Planning Analytics is a much bigger opportunity than a standard upgrade or basic migration. While the underlying TM1 engine remains as powerful as ever, IBM has made significant changes to the product to improve the user and developer experience.

Do you have any questions about End of Support dates or migrating from TM1 to Planning Analytics? Contact John Pra Sisto at 201.984.3025 or jprasisto@revelwood.com for more information.

Home » TM1 » Page 36

Complex Modeling in IBM Cognos TM1 at New York Blood Center

by Leave a Comment

If you are looking for a great example of complex modeling in IBM Cognos TM1, look no further than the case study on New York Blood Center. Imagine having untold numbers of separate models in disparate systems – such as Excel and Access – all built for a single purpose, but that did not talk to each other? How could you answer simple questions about the data, let alone complex questions?

That’s the situation that New York Blood Center (NYBC) faced. NYBC is one of the largest independent, community-based blood centers in the country. In 2012 NYBC brought in a new CFO, Beth Gibson, who, in turn, brought in a new director of financial transformation a year later. Diane Arritt, who took on the role of Director of Finance Transformation, was charged with taking the old, manual, largely spreadsheet-based financial infrastructure and move to a single, sophisticated system.

Today, NYBC has a core set of TM1 models to store GL, billing, payroll, AR and AP data. From there, each model was then built out to support NYBC’s reporting and planning needs. Then we created a series of allocation models to allow for the proper distribution of overhead costs across all of NYBC’s reporting lines of businesses. We also created allocation models to allow NYBC to report on costs per unit related to collecting and distributing the blood products.

The TM1 system enables the organization to plan, model, allocate, report and manage the revenue and expense data faster, in more detail and more accurately than ever before. The overall impact of the new financial system is much larger than just the time savings, which is significant. With TM1, changes that previously took more than a day can be done in just minutes.

“Previously, it would have taken us at least three months to map general ledger accounts and accounting units into our processes to do the appropriate reporting for an acquisition,” said Diane Arritt, Director of Finance Transformation. “Now our team was able to produce combined financial results for management the first month we acquired the Community Blood Center of Greater Kansas City. We simply could not have done that without the hierarchies and flexibility of TM1.”

Read the full case study on how New York Blood Center transformed its financial operations with IBM Cognos TM1 by downloading it here.

Read more Revelwood client success stories:

Rayonier Makes Better use of Resources with IBM Cognos TM1

Home » TM1 » Page 36

IBM Planning Analytics: Using the full power of MDX

by Leave a Comment

Many of you know that MDX can be used in your current IBM Cognos TM1 environment to create dynamic subsets and row expansions, but did you know that MDX can also be used to create an entire view of data?

TM1’s initial use of MDX functionality was limited to manipulating one dimension at a time, but IBM Planning Analytics uses the full power of MDX via expressions called tuples and sets.  These expressions define intersections of data which result in a full data set view.

This functionality is built into PAx Explorations and eliminates the need for DBRW functions in your spreadsheet.  When you create a new exploration, Planning Analytics automatically creates an MDX expression that references the current data set.  You can see the expression by clicking on the MDX button within the Planning Analytics ribbon.

MDX in IBM Planning Analytics

After clicking on the button, the full MDX expression will appear.

Detailed MDX in IBM Planning Analytics

This expression can be modified to change the results that appear in the spreadsheet.  In the above example, the columns can be changed to show the subset called “2017Months” instead of using the current subset called “2016Months”.

IBM Planning Analytics gives you the full power of MDX expressions. Not sure where to start? There are plenty of resources online. Our team here at Revelwood can also train you on MDX. And stay tuned for more MDX tips and tricks on our blog and in upcoming newsletters!

Home » TM1 » Page 36

Introducing IBM Planning Analytics Local

by Leave a Comment

IBM Planning Analytics Local, the convergence of TM1 on-premise with Planning Analytics on the cloud is now available! This new release brings many of the great enhancements and performance improvements that IBM has been making in the cloud environment available to on-premise TM1 customers.

I recently hosted a webinar with Dan Bernatchez, our FPM practice leader and Chief Solutions Architect for TM1, to review the new features of the solution and provided a live demo of Planning Analytics Local.

One highlight of the webinar included Dan showcasing Planning Analytics Workspace, which is a completely transformed user experience. This new “face” of TM1 provides a rich, interactive workspace that is visual, intuitive, insightful, social and mobile.

Dan also explained how Planning Analytics Local uses hierarchies for deeper analysis of TM1 data. Essentially it turns attributes into virtual dimensions, saving RAM, increasing query performance and adding flexibility. This enables users to have smaller, faster cubes, to introduce hierarchies to queries as needed, and to do dimension versioning.

Since Planning Analytics Workspace is the one new component that comes at an additional cost, IBM is offering a special 75% discount for existing TM1 customers who purchase it before year-end 2016. For information on this pricing deal, contact me and I can help you.

This webinar was the first in a three-part series showcasing IBM Planning Analytics. Stay tuned for the dates and topics of the next two webinars coming in early 2017.

Home » TM1 » Page 36

Creating IBM Planning Analytics Workspace Content (Part 2)

by Leave a Comment

This blog is intended to continue and build upon the previous blog How to Create IBM Planning Analytics Workspace Content. In this blog, I will provide an overview on building the remaining content (second and third row of visualizations) in the Dashboard below.


Dashboards


Create or Open a Book

  • Open up Planning Analytics Workspace, create a new Book or open up an existing book.


Steps to Create Units by Month

  • Drag and Drop a view from the Revenue Cube onto your canvas (we are using Revelwood’s Big Apple demo database for these examples).
  • Update the View so the Rows are the Products and the Columns are the Months that you want to report on.
  • Click on the amounts in your view, and select ‘Edit the Title’ from the blue Toolbar above your View and type in ‘Units by Month (000’s)’. The results will look like the following:


Steps to Create Units by Region

  • Click on the amounts in your view, and select ‘Duplicate’ from the Toolbar.
  • Drag and Drop that view to the right of the first view.
  • Swap the Product Dimension with the Region dimension, so the Regions are on the Columns.
  • Edit the Title to be ‘Units by Region (000’s)’. The results will look like the following:


Steps to Create Gross Margin by Period

  • Navigate to the Applications Folder of Revelwood’s Big Apple demo database.
  • Select the ‘Gross Margin by Period’ report.
  • Drag and Drop that report below the Units by Month (000’s) view.
  • Align and Size it as required.
  • The results will look like the following:
  • Click the amounts in your Units by Region view and select ‘Change Visualization’ from the blue toolbar above your View and select ‘Column’.


The result will be:


Summary

We’ve walked through the steps to create a simple Dashboard that includes Cube Views, Visualizations and Excel TM1 worksheets. Additional items that can be added to a Dashboard include; Media, Action Buttons, Web pages, Images and more. In short, IBM Planning Analytics Workspace is a powerful reporting tool providing you with new ways to analyze data, plan and access your content.

Want to learn more about IBM Planning Analytics? Email us and we’ll show you how powerful it can be for your company.

Read other Tech Tips blog posts:

Important Things to Consider When Changing your COA Structure

Securing Data from IBM Cognos TM1 On-Prem to IBM Planning Analytics

How to use IBM Planning Analytics Workspace

How to Create IBM Planning Analytics Workspace Content (Part 1)

Home » TM1 » Page 36

IBM’s Cloud Strategy and How Revelwood Can Help

by Leave a Comment

IBM is investing heavily in its analytics solutions, which means lots of things are changing for the better. At Revelwood, we see it as our job to help our clients interpret these changes to better understand how they might affect your organization in a practical way.

One critical component of IBM’s strategy has been the move to cloud. Not only has IBM acquired cloud-based companies like Softlayer to address the world’s infrastructure and platform needs, but it is migrating virtually all of its software solutions to the cloud, as well. TM1 moved to the cloud back in early 2014. Late last year, TM1 Cloud was reincarnated as IBM Planning Analytics (IPA), which includes TM1 and much more.

Here is a quick summary of the key components that are part of IPA:

  • TM1 – Multidimensional database engine (same as on-prem)
  • TM1 Web – Web environment, including Websheets, cube browsing, etc. (same as on-prem)
  • CAFÉ for TM1 – Excel add-in for TM1, including new functionality not available in Perspectives (Perspectives is also supported in IPA, but only for administrators as a means to publish Websheets)
  • Planning Analytics Workspace – a visual, self-service dashboard and lightweight reporting and data capture tool to interact with TM1 data (New!)
  • Watson Analytics – self-service cognitive discovery and prediction (New!)
  • Cognos BI – business intelligence and robust reporting against the TM1 data source (New!)

Moving to IPA on the cloud has its advantages, as well as some considerations to be aware of. For example, not all existing functionality in on-premise TM1 is ready for the cloud just yet. We’ll be covering more on IPA in upcoming blogs, so be sure to check back here often.

What we at Revelwood find most compelling about IBM’s direction is the dual “on-premise or in-the-cloud” strategy. Your organization can choose the right solution at the right time. We can help you understand the differences, develop a roadmap for migration, structure your renewal contract to include the cloud option and, of course, work with you on the migration itself. Just let us know and we’ll get the conversation started.

Who at Revelwood should I call, you ask? Great question. If you haven’t met him already, you should meet John Pra Sisto. John joined Revelwood last year as our first ever Client Success Manager. Yes, his entire purpose at Revelwood is to ensure that our clients are happy and successful. If you don’t know who to turn to, contact John. He can be reached at 201.984.3025 or jprasisto@revelwood.com.

Thanks for listening…we look forward to hearing from you.

Home » TM1 » Page 36

QUBEdocs Streamlines TM1 Documentation

by Leave a Comment

Understanding and documenting existing IBM® Cognos® TM1® models can be a time-consuming process. When making changes to complex models, it is challenging to fully understand the implications of these changes to ensure issues or inaccuracies won’t arise. Having made the changes, documentation must be also updated.

I recently sat down with our partner, Scott Felten, General Manager of QUBEdocs, to talk about the benefits of using QUBEdocs for TM1 documentation.

Q: What is QUBEdocs?
Scott: QUBEdocs is a proven solution for addressing the everyday challenges of TM1 analysts, developers and administrators. By delivering meaningful documentation of TM1 models, it virtually eliminates many of the time-consuming tasks associated with managing and making risk-free changes to TM1 models.

Q: How does it work?
Scott: QUBEdocs automates and centralizes the documentation of TM1 models, by allowing you to tag model constructs such as business rules, models, processes and applications. Integrating closely with TM1, it pulls information from vast numbers of underlying TM1 source files enabling you to organize your model and delivering an otherwise-unavailable consolidated view:

  • Depicting models visually
  • Delivering hard to find information to developers, administrators and end users in a meaningful way
  • Displaying comprehensive model dependencies
  • Enabling impact analysis of proposed changes
  • Highlighting errors through integrity checks
  • Tracking changes to meet corporate governance requirements
  • Capturing and reporting on changes over time or between environments
  • Maintaining documentation as changes are made

Q: What benefits can an organization expect from using QUBEdocs?
Scott: QUBEdocs significantly decreases the cost of managing your TM1 implementation, adding significant value to your business. QUBEdocs automatically generates documentation for TM1 models and uses a simple framework for translating the technical aspects in TM1 into your own business language ‘as you go’ resulting in time and resource savings. Presenting comprehensive TM1 model information in a meaningful way, QUBEdocs empowers users to logically and visually interrogate their model – making them less likely to make errors that result in support costs. Users and developers can clearly see dependencies within complex models, depict the models visually and search entire models. This allows them to effectively anticipate the impact of changes before making them.

Want to learn more about QUBEdocs? Contact John Pra Sisto.

Read other Tech Tips blog posts:

IBM Planning Analytics: Using the Full Power of MDX

Important Things to Consider When Changing your COA Structure

Securing Data from IBM Cognos TM1 On-Prem to IBM Planning Analytics

How to use IBM Planning Analytics Workspace

Home » TM1 » Page 36

Cash Flow Modeling with IBM TM1

by Leave a Comment

As a senior consultant with Revelwood for nearly seven years, I’ve had the opportunity to design and develop a large number of TM1 models for various aspects of budgeting, planning and forecasting. Some client engagements are very straightforward – simply transition the business from spreadsheet-based budgeting to TM1. This gives them greater flexibility and visibility while significantly reducing the amount of time spent on the budgeting process. All good and necessary stuff to properly manage an organization’s finances in today’s fast-paced business environment.

But every now and then, I’ve also had the opportunity to design and develop a TM1 model that’s completely new – not just a “standard” financial accounting activity, or a modification required for a specific industry. And that’s when my job is really fun.

One recent client engagement is a perfect example of doing something new in TM1. We developed a cash flow model designed specifically to reflect the reality of the business situation along with addressing the complexity of a multi-billion dollar business. Often, finance executives and analysts look at a forecast and focus on net income, sales or profitability. But what’s equally important is the impact those variables will have on cash.

On one hand it’s pretty simple. The more net income you have, the more cash you are going to have. However, our client wanted to say, “Based on our forecast, if I keep $100 million in cash, how much will I need to borrow or repay on my debt?” To get to this, we needed the model to reflect the entire business, including the forecast net income, capital expenditures and shareholder dividends. It needed to include everything we know about all the transactions, and how they impact the end result.

This may sound very different from “traditional” forecasting, but in fact, it’s just taking it one step further. At its simplest, it’s about taking all the known information and modeling that information so that the client can look at it in a different way. And that, to me, means there is always something more we can do with TM1. It’s not limited to basic budgeting and forecasting. In fact, operationally, you can measure any metric or KPI and create dashboards for them. Projects like this one – ones that push TM1 past the basics – are fun and engaging to work on.

Home » TM1 » Page 36