IBM TM1, Agentic AI & Finance Transformation Insights

Planning Analytics Workspace Local Distributed

Comment_Icon_black0
Alarm_Icon_12 min

PAW Local Distributed is an upgrade to Planning Analytics Local Workspace that can be deployed in a container orchestration engine using either Docker Swarm by Docker or Kubernetes - an open source by Google, for high availability, fail-over, scalability, and fault tolerance in multiple application servers or virtual or even cloud machines. Architecture: The Planning Analytics Workspace Distributed is run on a Swarm mode by deploying the application on multiple Docker nodes (with unique node ids) also known as Swarm. Docker Engine CLI could be used to create a swarm and deploy and manage the ...

Line_2015

Views integration in PAX and PAW

Comment_Icon_black0
Alarm_Icon_13 min

In the latest version of PAX (2.0.44) as well as PAW (2.0.44), IBM has added a new capability to allow the views to be shared between PAW and PAX using Planning Analytics Workspace Content Store. What does this mean for us? We can now save the views in content store and share it across to be accessed from either PAW or PAX which was not possible earlier. This further strengthens the integration and make the PAX and PAW interoperation even more seamless which a good step as far as usability and software portability is concerned. Steps to access the views from PAW content store from PAX: We ...

Line_2015

Drill Down Using Slicer in Power BI

Comment_Icon_black5
Alarm_Icon_14 min

This article shows how to drill down to the next level in a visualization within Microsoft Power BI, when a filter is applied using a Slicer. This could be applied even if multiple selections are made within the slicer. For example – We have a car with 3 model series (L Series, S Series, T Series) in the slicer. Business requires to show the values at this level when no selection is made. Once a selection is made, the visual should show the next level in the hierarchy. Visualisation without any filter selected (Shows the top level): Visualisation with single filter selected (Shows the next ...

Line_2015

IBM Planning Analytics Workspace (Paw) Full Backup and Restore

Comment_Icon_black0
Alarm_Icon_13 min

In this article, we will be seeing how to take a complete backup of IBM PAW and, also how to restore/revert the complete PAW Application using a backup. Environment: Windows Server 2012 R2 IBM PAW Version: 2.0.37 VMware: Oracle VMware Prerequisite Virtual machine for PAW should be up and running. Make sure to use the Root User ID for below steps. (What is Root User ID? Well, the user ID used for installing IBM PAW in that System and that user ID we are referring it has Root User ID here. In Case, if you are not sure which is root User ID then find which User folder the PAW VM is placed) Now, ...

Line_2015

Manage Your KPIs with Business Intelligence Applications

Comment_Icon_black0
Alarm_Icon_13 min

With a variety of business intelligence applications at your disposal, it’s worth investigating the best and comparing your needs against each product to get the best return on your investment. Here are three ‘must-haves’. 1. Customisable workspace With a business intelligence application like IBM Planning Analytics, you can enjoy a single and consistent environment in which to manage your KPIs. So whether you need to measure business performance, evaluate and alter plans, expose gaps or test-drive the impact of potential scenarios on your business activity, you can do so in an interactive, ...

Line_2015

Business Intelligence Tools: Steering in the Right Direction

Comment_Icon_black0
Alarm_Icon_14 min

Despite the rampant growth of new data, constantly evolving technologies and the digitalisation of entire sectors, there are a few facets of business that will never be eliminated entirely: volatility, uncertainty and risk. But with business intelligence tools, you can keep your organisation on the right track and reduce the inherent risks of day-to-day operations. Here’s how. A complete, all-in-one business tool When seeking out a business intelligence tool to adopt in your organisation, you’ll want one with speed, agility and flexibility, so it provides a return on your investment. With IBM ...

Line_2015

Why You Should Invest in the Best Financial Planning and Analytics

Comment_Icon_black0
Alarm_Icon_12 min

The role of financial planners and analysts has expanded from assessing and reporting to data science. That’s why there’s a very real need to adopt the best financial planning software. Financial planners and analysts are now expected to have comprehensive knowledge of to access and collect information from business intelligence (BI), enterprise resource planning (ERP) and other data sources. But without the right software to support them, their struggles are compounded. The financial team’s daily struggles There are many issues that financial planners and analysts face on a daily basis, ...

Line_2015

Leveraging the Benefits of Business Intelligence Software

Comment_Icon_black0
Alarm_Icon_12 min

The right business intelligence software can help companies beat out the competition and become market leaders in their industry. We reveal how to leverage three key benefits of business intelligence software - and overcome some potential drawbacks! 1. Integration across disparate business systems In order to derive the best strategic insights, you typically need to analyse data from across a number of different systems. Your company’s operational results, for example, require a financial perspective. That means your business intelligence solution should be able to integrate data from various ...

Line_2015

Input Form clearing and retrieval of data

Comment_Icon_black0
Alarm_Icon_12 min

Whenever User enters data in Websheet (Form), last entered data will be present on Form. If User needs to enter new record, it becomes tedious to clear data from each of the text box, if Form comprises good number of text boxes. This will not be best way of utilizing User services. To avoid or improve efficiency of User, TM1 can be designed in better way using multiple Cubes. Create 2 named cubes, lookup cube (Test_Lookup) and cube which contains data (Test_Emp) Below are details of Dimensionality and structure of cubes Input Form where User can create new record, update record. Clear Button: ...

Line_2015

Multiple TM1 Active Forms in single websheet

Comment_Icon_black0
Alarm_Icon_12 min

Most of the times business would like to generate reports in different formats to show data in different periods. They might be interested to display each set of data in different fonts, colors with capability of Row expansion. The easiest way to develop those kind of reports is, using TM1 Active Forms. To achieve this functionality using Active Forms, developer should know how to make each data set independent of each other so that none of them have influence of other. Let’s see how to create multiple active forms in single websheet as shown below: Above both data sets are displayed using ...

Line_2015

Business Intelligence tools: How to find the right fit

Comment_Icon_black0
Alarm_Icon_12 min

Picking the right business intelligence tools for your organisation is essential in the current era of big data. With information coming from all angles, it’s imperative to leverage the best software to make sense of your data and parse it into actionable, meaningful decision-making. Why do you need business intelligence tools? In their most basic form, business intelligence tools allow you to ‘see’ your data. This means you can watch how your data creates patterns and correlations. That information – including statistics and current trends – can then be used to formulate plans for the ...

Line_2015

How Important is a Single Version of the Truth to BI?

Comment_Icon_black0
Alarm_Icon_12 min

In our hyper-connected business world, organisations are often siloed and sometimes spread across multiple locations. Combine that with the fact that the majority of employees are ‘hooked in’ to company-wide systems via their smart devices, and you have a raft of users able to access data and alter it. The problem? This often creates version-control issues that not only impact productivity and the effectiveness of your business intelligence (BI), but can harm your reputation and profitability. What is a ‘single version of the truth’? When discussing ‘truths’ in the form of BI, it’s important ...

Line_2015