Blog

Blog

Lease reporting under IFRS 16? Help is here!

Business is all about buying and selling, right? For the most part, yes. But for many companies, it’s also about leasing. For companies in a diverse range of industries, leases make up a major part of their operating expenses. These companies lease office and retail space, vehicles, equipment, machinery and a myriad of other items essential to their operations. Accounting for those leases is a major responsibility for the finance organizations at these companies. As every finance professional knows, the difference of a few percent here or there, in a lease payment or a tax deduction, can have a significant impact on profitability. So the introduction of the new IFRS 16 accounting standard under International Financial Reporting Standards (IFRS) could have major consequences for any company that depends on leased assets to function. Leases recognized as assets and liabilities IFRS 16 introduces a single accounting model for lease reporting. It requires lessees to recognize assets and liabilities on their balance sheets for all leases with a term of more than 12 months, unless the asset has a value of less than US$5,000. IFRS 16 replaces the earlier leasing standard, IAS 17, and for most companies, it takes effect for annual reporting periods beginning January 1, 2019. Under IFRS 16, lessees are required to record leases as assets, representing the right of use (ROU) of the underlying asset, for example, retail space in a shopping mall. The corresponding obligation to make lease payments is recorded as a liability. Lease liabilities are reported at the present value of future payments, with only depreciation and interest cost separated on the P&L. The new leasing standard also removes the distinction between finance and operating leases. Introducing the IBM Planning Analytics Solution Accelerator for IFRS 16 The new reporting regime not only affects lease administration and accounting, it also has the potential to influence numerous decisions companies make about whether to lease or purchase, how to structure lease agreements, and a number of other issues. Fortunately, there is a way to speed and simplify administrative processes and gain the insight management needs to make the right decisions on leasing. The IBM Planning Analytics Solution Accelerator for IFRS 16 is a pre-packaged framework designed to help you manage the complete lease accounting workflow, from contract creation to expiration. The Solution Accelerator includes: A built-in IFRS 16 qualifier, to ensure that a given contract qualifies as a lease under IFRS 16 A calculation engine to calculate future cash flow payments at net present value Rules to calculate the value of both right-of-use (ROU) assets and lease liabilities, including future payments, interest and depreciation Capabilities to integrate IFRS 16 with enterprise resource planning (ERP) and the close, consolidate, and report process Self-service visualizations to help communicate insights quickly Self-service visualizations communicate insights quickly. More efficient processes; more informed decisions As it take effect worldwide, IFRS 16 is sure to produce many changes in how companies structure and use their leases. The Solution Accelerator can help organizations perform the important accounting tasks more efficiently, and provide the insight needed to make decisions about leasing quickly and confidently. To learn more about how the IBM Planning Analytics Solution Accelerator for IFRS 16 works, read all about it in our new solution brief. And if you’d like to learn about just about everything else you can do with IBM Planning Analytics, please join us for the second annual IBM Analytics University conference. It’s offered this year in two new cities, Stockholm, Sweden, September 17-20, 2018 and Miami, Florida October 2-5, 2018. Check out the IBM Analytics University web page for more conference information.  

Blog

User Invitation Improvements

If you have the administrator role, the Planning Analytics user invitation process has been enhanced with two updates to ease the effort of user administration: Set the role when you invite multiple users to join Planning Analytics Workspace. Set the subscription when you invite multiple users to join Planning Analytics Workspace. Set the subscription when you invite users to join Planning Analytics The Planning Analytics user invitation process has been enhanced to allow for subscriptions (IBM Planning Analytics Modeler, IBM Planning Analytics Explorer, IBM Planning Analytics User, etc) to be set during the invitation process.  Until now, when inviting users with the Workspace Administer screen, users were set to the Modeler subscription part creating confusion with administrators.  This enhancement will allow customers to manage their subscription user counts.  It is highly recommended that administrators update the subscriptions for their user community.  For more information on the subscription parts and the relationship to Workspace roles, please visit the "Administer Users" section in the documentation. When inviting a single user, the subscription must be selected to proceed: When inviting multiple users with the "Upload Users" feature, the subscription must be selected after uploading the users and selecting "Invite uploaded users."  For this reason, it makes sense to invite groups of users that have the same subscription:   Set the role when you invite multiple users to join Planning Analytics Workspace. Administrators now have the ability to set the role of users when using the "Upload.  This change in behavior is intended to allow large numbers of users to be quickly onboarded by the Workspace administrator. The recommended process for onboarding multiple users now involve the following steps. Upload users account into Workspace using a CSV file.  The format of the CSV is described when you click the Upload users button in User administration. The role can be optionally set as the fourth column in the csv file.  Make sure the first column is the e-mail address of the users. Once users are loaded into Workspace they must be invited, and accept an invitation.  The invite can be done in batches, up to 100 users at time.  Sort on the status column to group the user accounts that have not yet been invited.  A range of users can be selected by clicking on the first user in the list to be invited, then shift-clicking on the last user in the list you want to invite.  Once a range of users (up to 100) has been selected click the Invite uploaded users button.

Blog

Customize your IBM Planning Analytics Workspace books using properties

You can change the way dashboards, cube views, charts, images, cell views, and text in Planning Analytics Workspace look and behave by setting properties. First, go into Edit mode, then select the object that you want to change the properties for.  If you want to change the dashboard, make sure that nothing is selected first. Then, click the properties button and choose the property. Here we are changing the theme of the dashboard from the default to light: Cube view properties You can change lots of properties for the cube view - you can set the theme, simplify the table, change colors, set when the grid refreshes, and you can set synchronization options and text properties. Here's how you simplify the table: To find out more, see Set cube view properties Making a popup text box by setting properties Did you know that you can make a popup text box by changing the properties of an image or text? Try it out by adding a shape to a sheet: Then change the properties to Pop-up Text and add some information: Finally, switch out of edit mode to test: To find out more, see Add pop-up text to books

Blog

Analyze detailed data by using drill throughs in IBM Planning Analytics for Microsoft Excel

Drilling through on a cell provides detailed data on the cell, and shows you information from the data source. You can drill through on cells in Exploration Views, Custom Reports, Quick Reports, and Dynamic Reports. In this post, we'll go through how to can perform a drill through in IBM Planning Analytics for Microsoft Excel. You can also follow along by watching the tutorial video. This video also describes the difference between a cube drill through and a relational drill through: Ensure that your TM1 cube, view, or relational table has 
drill processes or drill assignment rules defined. These are defined by your TM1 modeler. Highlight the cell you want to perform a drill through on. Check to see whether the cell can be drilled on. If the Drill Through icon is enabled, you can drill through on the highlighted cell. Right-click the cell. Click IBM Planning Analytics. Click Drill through. Click the data source that you want to view the detailed data for. Alternatively, you can also perform a drill through by clicking the Drill Through icon and then clicking the data source you want to view detailed data for. And there you have it! Drill throughs in IBM Planning Analytics for Microsoft Excel. To learn even more about drill throughs in IBM Planning Analytics for Microsoft Excel, see the documentation on the Knowledge Center: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.ug_cxr.2.0.0.doc/t_pax_drill_through.html  

Blog

Top 5 reasons to upgrade from IBM TM1

If it ain’t broke, don’t fix it, right? Well, yes and no. Your company probably had lots of systems and processes that worked just great—back in the day. But you wouldn’t trade them for the tools and capabilities you use today, correct? In the same way, although we hope that you love IBM TM1, we think you’ll like IBM Planning Analytics even better. Why? Because we took the powerful, multi-dimensional calculation engine of IBM TM1 and added capabilities that can make your planning, budgeting, forecasting and analysis faster and more flexible than ever before. We listened to feedback from TM1 users around the world. And we put everything we learned into IBM Planning Analytics. An upgrade designed around your needs IBM Planning Analytics provides a unified Web, Excel, and mobile experience for both finance and non-finance users. It goes beyond automating manual tasks and improving process efficiency. It offers new cognitive capabilities that help you uncover predictive insights directly from internal and external data. Plus, it’s deployable on premises or on the cloud. Here are 5 more great reasons to upgrade: IBM Planning Analytics Workspace – the interface that revolutionizes TM1
 Workspace is the customizable interface that is the new face of TM1. It supports reporting, analysis and write-back with an interactive viewer that makes it easy to navigate multi-dimensional cubes and share results with others. This interface has been praised by customers and analysts alike for its ease of use. And with more than 25 different images, charts, maps, and scorecards, Workspace lets you create compelling visualizations quickly. It’s also mobile, so you can work with Workspace books at your convenience, on an iPad or other tablet device. IBM Planning Analytics for Microsoft Excel
 The IBM Planning Analytics for Microsoft Excel add-on is the successor to IBM Cognos Analysis for Microsoft Excel (CAFE). It gives you Excel access to the IBM TM1 database with superior performance over wide-area networks. It lets you retain full Excel functionality and formatting when moving data between TM1 and Excel, and integrates smoothly with Workspace, sharing a common UX, Cube Viewer, and Set Editor. [caption id="attachment_8465" align="alignnone" width="650"] Figure 1: Access through the familiar Microsoft Excel interface.[/caption] Hierarchies The “hierarchies” capability in IBM Planning Analytics provides both technical advantages and business-user benefits. With hierarchies, you’re not limited to the traditional definition of cubes. You have the flexibility to perform in depth, granular analysis, exploring data by attributes such as customer, product, sales program and more. You can model attributes and drill into them without having to create a new dimension or add elements (members) to the hierarchy. You can also see the intersections of several hierarchies within the same dimension, so you can drill down to find data points never before possible. Planning that’s ready for GDPR
 The European Union’s new General Data Protection Regulation (GDPR) is another very good reason to upgrade. GDPR takes effect May 25, 2018, and it’s important for all of your business processes to be ready. IBM Planning Analytics will be GDPR-ready when the regulation takes effect. Learn more at the IBM GDPR web page: No long migration process
 New capabilities notwithstanding, upgrades are still a headache, right? Nope, not here. In spite of the solution’s new name, the upgrade to IBM Planning Analytics is not really a migration. You just install it and go, using your current model and mode of operation. Once again, if you love IBM TM1, we think you’ll like IBM Planning Analytics even better. So, check it out. Learn more about why now is the right time to upgrade, and schedule a 30-minute upgrade strategy call and/or product demonstration with your IBM representative. Visit the IBM Planning Analytics website to learn more about why so many of your peers have already made the switch.

Blog

Use drag and drop to create a new dimension or hierarchy in Planning Analytics Workspace

You can drag and drop a file onto the dimension editor to create a new dimension or a new hierarchy of an existing dimension in Planning Analytics Workspace. When you import a file in this manner, you can create parent/child relationships in a dimension or hierarchy, and even create or update attributes.  This simplifies dimension or hierarchy creation, but there are a few things you need to know before you start: The file must be correctly formatted. You must have modeler privileges. Planning Analytics Administration must be configured and running. Drag and drop is not currently available in IBM Planning Analytics Workspace Local. To get started, open a new dimension or a new hierarchy of an existing dimension. In either case, the dimension editor must be empty; you can't use drag and drop if any members already exist in a dimension or a hierarchy. Next, drag and drop your file onto the dimension editor. Finally, identify the structure of your source file, then click Import to create your new dimension or hierarchy. The animation below briefly illustrates how to use drag and drop to create a new dimension, but you can find complete details in Drag and drop files to add dimension members and attributes.  

Blog

Adding and executing APIs in IBM Planning Analytics for Microsoft Excel

IBM Planning Analytics for Microsoft Excel features an IBM Cognos automation API, which helps users automate many of their tasks. In a previous post, we went through how you can set up Planning Analytics for Microsoft Excel. Today, we'll continue from where we left off and show you how you can pick, add, and execute API functions. If you haven't seen our post on setting up Planning Analytics for Microsoft Excel for API use, you can check it out here. You can also follow along by watching the tutorial video: First, double-check your CognosOfficeAutomationExample.bas file and ensure that the following exists: m_oCOAutomation is defined as an object m_oCAFE is defined as an object There is a Property Get statement for CognosOfficeAutomationObject() There is a Property Get statement for Reporting() Next, insert a new module. This is where you'll be adding your own API functions. Browse to our documentation on the Knowledge Center and choose the API functions that'll help you automate your tasks. In this example, we'll be using the Create function. This function allows us to generate Exploration Views from a combination of host system URL, server name, cube name, and view name. It's extremely useful for quickly generating the same report over and over. In many cases, you can copy the example from the documentation. Paste the example into the new module that you inserted. You may have to adjust the formatting and replace some of the values with ones that suit your needs. When you've done that, save the module and return to the workbook. Now you can select your API function from Macros and execute it! As you can see, we quickly and easily generated a new report using our parameters. There are many ways to use the IBM Cognos automation API in Planning Analytics for Microsoft Excel. Go ahead and see how it can help you automate your tasks.

Blog

We’ve improved your support experience!

We appreciate the opportunity to have you as a client.  IBM continually strives to seek new and better ways to improve the support experience we offer you.  With that in mind, we’re implementing some enhancements to our support model by launching a new IBM Support Community that all IBM products will move to over time. We are pleased to advise you that this weekend we have moved all client support – including discussion forums and support case management – for the following IBM Business Analytics cloud services to the new Support Community: IBM Cognos Analytics on Cloud IBM Cognos Controller on Cloud IBM Planning Analytics IBM Watson Analytics We know that you may have other IBM products that will also be migrating to this new support experience. Watch out for further information on the specific timing of this from the relevant support teams. Within the new Support Community, self-service capabilities are available to allow for better ease of use, including: Discussion forums where you can ask questions, help answer questions from other users, and interact with knowledgeable IBM staff Simplified search capability powered by IBM Watson to view knowledge artifacts, forum discussions, and support case history Support case creation/updates Ability to attach documents for review by support staff …and much more! We invite you to view the following short videos that provide an overview of the initial experience that will continue to evolve and become richer over time. Introducing the IBM Support Community: Search https://mediacenter.ibm.com/media/t/1_hjcvgybl Introducing the IBM Support Community: Forums https://mediacenter.ibm.com/media/t/1_dnpmr6oi IBM Support Community: Open and manage Cases https://mediacenter.ibm.com/media/t/1_47uqs38j During this weekend’s transition to the new Support Community your active support cases will be moved first followed by your case history, and can be found under the Cases tab once you have signed in. You can access the new support experience by following these steps: Go to  https://www.ibm.com/mysupport To participate in the discussion forums, and to submit and manage your support cases, you will need to sign in. If you sign in to your IBM Business Analytics cloud service using the same user name and password that you use on your organization’s network then you can sign in to the IBM Support Community the same way. Otherwise you should sign in using your IBMid user name and password. Note that this is not the same as your IBM Client Success Portal user name and password that you most likely use today to submit and manage your support tickets for your IBM Business Analytics cloud service. If you do not have an IBMid, you can sign up for one here: https://www.ibm.com/account/us-en/signup/register.html. Note that in the new support experience you will, by default, receive a notification email whenever an update is made to one of your ongoing cases. Please do not reply to this notification email as this will not update your case. The notification email contains a link directly to your case where you can review the details of the update and respond appropriately. You can configure your email notification preferences for support cases and discussion forum updates. Please see the following community release update for further information, https://www.ibm.com/mysupport/s/article/Case-Email-Notifications. If you experience a problem with the IBM Support Community (such as a login issue, etc.), we are here to help.  Please submit your issue via the link found near the end of each page in the community and someone will get back to you as quickly as possible. We hope you enjoy the enhancements of this new IBM support experience and always welcome your feedback.

Blog

VIDEO: Resolve Gateway Issue with #Planning Analytics Workspace on Windows Server 2016

In this video, you'll learn how you can resolve issues connecting to IBM Planning Analytics Workspace on Windows Server 2016.

Blog

VIDEO: Change default ports for #Planning Analytics Workspace on Windows Server 2016

In this video, you'll learn how to change default port numbers in IBM Planning Analytics Workspace on Windows Server 2016.

1 2 3 12