Dipping your toes into AI in Finance with Watson Orchestrate: A Step-by-Step Journey

The holiday season is a time for joy, relaxation, and quality time with loved ones. However, for many finance teams, it’s also a period of intense activity. Year-end closings, budgeting, and reporting deadlines can pile up, creating a stressful and demanding environment.

Imagine spending your holiday season worrying about potential system outages, data load failures, or urgent user queries. It’s a scenario that can disrupt your well-deserved break and compromise your team’s productivity.

Leverage Dedicated TM1 Support During the Holidays

• Engage a reliable TM1 support partner to handle system maintenance, troubleshooting, and year-end processes so your team can enjoy a well-deserved break without stress.

Automate Routine Tasks and Processes in TM1

• Use TM1’s automation capabilities to schedule recurring tasks like data loads, reconciliations, and report generation, ensuring everything runs smoothly while minimizing manual effort.

Ensure Proactive Monitoring and Downtime Prevention

• A TM1 support team can proactively monitor your environment, identify potential issues before they escalate, and ensure critical systems remain up and running during the festive season.

Outsource Last-Minute Reporting and Forecasting Support

• Avoid scrambling to meet year-end deadlines by outsourcing TM1 reporting tasks to a team that can handle changes, corrections, and urgent requests with expertise and speed.

Plan Ahead with a Holiday Support Coverage Model

• Partner with a TM1 managed services provider who offers holiday-specific coverage, ensuring your team has access to skilled resources when needed, without disrupting workflows or personal time.

Why TM1 support (Octane Blue) is the Perfect Solution 

That’s where Octane Blue comes in. Our comprehensive support service is designed to alleviate your holiday stress and ensure business continuity. With 40 hours of dedicated support, you can rest easy knowing that your TM1 environment is in expert hands.

What Does Octane Blue Offer? 

1. Proactive System Monitoring: Our team will keep a watchful eye on your TM1 environment, identifying and resolving potential issues before they escalate. 

2. Rapid Incident Response: Should any issues arise, our experienced support engineers will be on hand to diagnose and fix them promptly. 

3. Data Load and Reconciliation Support: We’ll assist with data load processes, ensuring accurate and timely data integration.

4. Security and Access Management: Our team will help maintain the security of your TM1 environment and manage user access rights. 

5. Security and Access Management: Our team will help maintain the security of your TM1 environment and manage user access rights.

6. Technical and Functional Support: We’ll provide expert guidance on a wide range of TM1 topics, from technical troubleshooting to functional best practices.

7. User Support: Our team will be available to assist your users with any questions or issues they may encounter. 

Frequently Asked Questions

• 40 hours. 

• Unused hours will be rolled over for one additional month. 

• No, Octane Blue is available on any TM1 site. 

• No, you can purchase Octane Blue on a one-time basis or as needed. 

• https://www.octanesolutions.com.au/tm1-support#switch

• Purchase now

• Book a meeting with us

Don’t let the holiday season stress you out. Let Octane Blue take care of your TM1 environment so that you can enjoy a peaceful and productive holiday. 

print    

Attending IBM TechXchange in Mandalay Bay, Las Vegas was an exhilarating experience that showcased the cutting-edge IBM technologies shaping various industries today. The conference brought together technologists, IBM Champions, thought leaders, industry experts, and innovators eager to share insights and explore the latest advancements in IBM's technology portfolio. From AI to cloud computing, the event highlighted how these tools are transforming businesses, making operations more efficient, and ultimately driving better decision-making.

As an IBM champion we were treated as VIPs with row seats in all keynote sessions, special champions lounge and special dinners and networking sessions. It was great to see IBM champions sporting the blue jackets throughout the conference.

One of the standout moments for me was the opportunity to present alongside Ashika Singh from Fiji Airways. Our session focused on their usage of IBM Planning Analytics, which allowed Fiji Airways to navigate the challenges posed during the COVID-19 shutdown. The pandemic created unprecedented obstacles for the airline industry, with travel restrictions and safety concerns leading to a dramatic decline in passenger numbers. However, Fiji Airways leveraged IBM Planning Analytics to make data-driven decisions that prepared them for the eventual reopening of global travel.

During our presentation, we shared how the airline utilised forecasting and scenario planning capabilities in the tool to assess various outcomes and devise strategies for recovery. By analysing all drivers and generating up to 60- what-if scenarios at a time, Fiji Airways was able to predict future demand and align their resources accordingly. This proactive approach not only ensured they were ready when the skies reopened but also positioned them to adapt quickly to changing circumstances, ultimately enhancing their resilience. This led to numerous awards and Fiji Airways is now ranked 14^th in the world in Skytrax ranking 2024. They have overtaken Qantas and Air New Zealand which traditionally dominated the rankings in the region.

The discussions throughout the conference were incredibly enlightening. Industry leaders spoke about the importance of digital transformation and how organizations must prioritise agility and innovation to thrive in today's fast-paced environment. There was a strong emphasis on how leveraging AI and analytics can unlock new opportunities, streamline operations, and create a more personalized customer experience. These insights resonate deeply, especially in sectors like travel and hospitality that have been profoundly affected by global events.

Networking opportunities were plentiful at TechXchange, allowing me to connect with other professionals who share a common goal of harnessing technology for business growth. Conversations flowed about the challenges and triumphs faced during the pandemic, highlighting how collaboration and knowledge-sharing have played vital roles in overcoming adversity. Each conversation reinforced the idea that we are all part of a larger community that supports each other's journeys toward transformation. There were lots of opportunities to network with other TM1 specialists from around the world.

The event was also filled with hands-on labs and demonstrations, showcasing IBM's latest products and solutions. Exploring new functionalities and engaging with the technology firsthand enhanced my understanding of how these tools can be applied in various contexts. It was exciting to envision how businesses can harness these innovations to optimize their operations and improve overall performance. IBM also used the conference to announce the launch of the Granite 3.0 AI model. (Read more here Granite 3.0)

Looking back on my experience at IBM TechXchange, I am inspired and optimistic about the future. Planning Analytics has a range of new functionality to improve performance, deployment options and integration of IBM AI onto the platform will cement its position as a leader in the XP&A space. Presenting with Ashika was a highlight that illustrated not only the adaptability of Fiji Airways but also the potential of data-driven decision-making for all of our clients. There was a lot of interest in how we integrate Watson Orchestrate with Planning Analytics to boost the AI functionality in finance teams.

In conclusion, attending IBM TechXchange has provided a great platform to see where IBM is going in the future – and it's looking exciting. As AI becomes more mainstream and use cases continue to evolve it was interesting to see how our peers and IBM are harnessing this technology to deliver business value for clients. The dates for 2025 Techxchange in Orlando are already announced and Octane will once again attend along with our clients. (More details IBM Techxchange conference)

print    

Planning Analytics Workspace (PAW) offers a robust suite of visualizations, enabling users to create rich and compelling reports and dashboards with remarkable flexibility. However, even with these capabilities, you may occasionally encounter requirements that push the limits of what PAW provides out of the box. 

One such scenario I encountered was the need to create a column chart comparing Actual vs Budget variance. The twist? Any negative variance should be highlighted with a red bar, while positive variance should be displayed in green, as shown below: 

PAW’s default settings don't currently offer this kind of custom conditional formatting for visualizations. However, with a little MDX magic and a few formatting tweaks, you can achieve this effect in just five simple steps. 

Step-by-Step Guide to Creating Custom Visualizations in PAW 

Step 1: Position the Version Dimension in the Column 

Start by positioning the Version dimension in the column of the Exploration view. This is where we will apply the MDX logic to derive the desired results. 

Step 2: Use MDX to Create Calculated Members 

Next, you'll need to update the MDX query by creating three calculated members to represent Actual vs Budget (AvB), Positive Variance, and Negative Variance. 

Here’s the MDX code: 

MDX code: 

WITH  

MEMBER [Version].[Version].[AvB] AS [Version].[Version].[Actual] - [Version].[Version].[Budget]  

MEMBER [Version].[Version].[Positive] AS IIF([Version].[Version].[AvB] > 0, [Version].[Version].[AvB], "") 

MEMBER [Version].[Version].[Negative] AS IIF([Version].[Version].[AvB] < 0, [Version].[Version].[AvB], "") 

Note: The AvB calculation could also be done using a consolidated member in the Version dimension, where the Budget has a negative weight. 

Step 3: Replace the MDX in the Row Axes 

Now, replace the MDX in the Row Axes relating to the Version dimension to show only the Positive and Negative calculated members, while excluding the AvB calculation (and any other member): 

MDX code: 

{ 

    EXCEPT( 

        { 

            [Version].[Version].[AvB], 

            [Version].[Version].[Positive], 

            [Version].[Version].[Negative] 

        },  

        { 

            [Version].[Version].[AvB] 

        },  

        ALL 

    ) 

} 

This MDX will generate a view that displays only Positive and Negative members in the Version dimension, leaving the non-relevant member (whether positive or negative) as blank, depending on the AvB value. 

Step 4: Convert the Exploration View into a Column Chart

Once the MDX has been applied, convert the Exploration view into a Column Chart. By default, PAW will show the columns for positive and negative values with its standard color scheme.  

Step 5: Apply a Custom Color Palette 

To finalize the visualization, we’ll apply a custom color palette. Navigate to the visualization properties and create a color palette that includes only two colors: green for positive values and red for negative values. 

Conclusion 

With just a few lines of MDX and a bit of customization, you can significantly enhance PAW visualizations. This technique allows you to move beyond the standard out-of-the-box options, giving you the flexibility to create more intuitive and visually effective reports. Whether you're comparing Actual vs Budget or any other metrics, these methods help you build visuals that not only convey the necessary information but do so in a way that is easy to interpret at a glance. 

By leveraging MDX and PAW’s formatting tools, you can push the boundaries of your reporting and create dynamic, insightful dashboards tailored to your business needs. 

print    

In the realm of digital transformation, the concept of digital labor has emerged as a game-changer for businesses seeking efficiency, agility, and innovation. IBM WatsonsX Orchestrate, a powerhouse in the AI and data orchestration space, takes center stage in this digital evolution. This blog explores the pivotal role played by WatsonsX Orchestrate in reshaping digital labor and how it empowers organizations to harness the full potential of artificial intelligence (AI) and data science.

Orchestrate allows you to add and train new automations from a variety of sources, enabling users to easily work across existing systems using a single UI.

Understanding Digital Labor:

Digital labor refers to the use of digital technologies, including AI, automation, and robotics, to augment or replace human tasks and processes. It's a paradigm shift in how work is done, leveraging technology to enhance productivity, reduce errors, and enable humans to focus on more strategic and creative aspects of their roles.

"Companies that effectively apply intelligent automation across the enterprise expect to outshine peers in profitability, revenue growth, and efficiency over the next 3 years."

IBM WatsonsX Orchestrate and Digital Labor:

1. Workflow Automation for Operational Efficiency: One of the key pillars of digital labor is workflow automation, and WatsonsX Orchestrate excels in this domain. By automating intricate AI and data science workflows, the platform significantly reduces manual effort, streamlining processes and enhancing operational efficiency. This allows organizations to accomplish more with less, freeing up human resources for high-value tasks.

2. Collaboration for Enhanced Productivity: Digital labor is not about replacing human workers but augmenting their capabilities. WatsonsX Orchestrate fosters collaboration among cross-functional teams, bringing together data scientists, developers, and domain experts. This collaborative environment accelerates problem-solving, decision-making, and innovation, creating a synergistic relationship between digital labor and human expertise.

3. Scalability to Meet Growing Demands: As organizations scale their digital labor initiatives, scalability becomes a critical factor. WatsonsX Orchestrate provides the flexibility to scale horizontally and vertically, ensuring that the platform can seamlessly adapt to the growing demands of AI and data science projects. This scalability is essential for organizations aiming to expand their digital labor capabilities without compromising performance.

4. Model Monitoring and Management for Continuous Improvement: In the era of digital labor, continuous improvement is paramount. WatsonsX Orchestrate includes robust tools for monitoring and managing AI models in production. This ensures that digital labor processes based on AI models deliver consistent and reliable results over time. The platform's capabilities contribute to the iterative refinement of digital labor processes, optimizing outcomes and enhancing overall performance.

5. AI Explainability and Ethical Digital Labor: Transparent digital labor practices are crucial for building trust and ensuring ethical use of AI. WatsonsX Orchestrate provides tools for explaining AI model decisions, addressing the interpretability challenge often associated with complex AI systems. Additionally, the platform includes features for detecting biases, aligning digital labor practices with ethical standards and promoting fairness in decision-making.

   
   

   

   There are more than 2,000 activities that make up 800 full-time occupations that are part of knowledge work. However, only 5% of these full-time occupations could be fully automated using existing technology. That means that the 95% of remaining occupations require cognitive abilities.

Benefits for Businesses:

1. Accelerated Time-to-Value: By automating and streamlining AI and data science workflows, organizations can significantly reduce the time it takes to move from ideation to deployment, ultimately accelerating their time-to-value for AI initiatives.

2. Improved Collaboration: The collaborative features of WatsonsX Orchestrate facilitate better communication and knowledge sharing among teams, leading to more effective and impactful AI solutions.

3. Enhanced Governance and Compliance: The platform provides robust governance and compliance features, ensuring that organizations can meet regulatory requirements and maintain a high standard of data ethics.

4. Cost-Efficiency: With the ability to scale and the flexibility of deployment options, WatsonsX Orchestrate helps organizations optimize costs by aligning infrastructure with project requirements.

In the era of AI and data-driven decision-making, IBM WatsonsX Orchestrate stands out as a powerful solution for organizations looking to harness the full potential of their AI and data science initiatives. With its automation capabilities, collaborative environment, and emphasis on ethical AI, WatsonsX Orchestrate is poised to become a key player in the journey towards building intelligent, transparent, and scalable AI solutions. As businesses continue to navigate the complexities of the digital age, platforms like WatsonsX Orchestrate provide the tools needed to turn data into a strategic asset and drive innovation in the ever-evolving landscape of AI.

print    

IBM Watson™ Studio is a platform for businesses to prepare and analyse data as well as build and train AI and machine learning models in a flexible hybrid cloud environment.

IBM Watson™ Studio enables your data scientists, application developers and subject matter experts work together easier and collaborate with the wider business, to deliver faster insights in a governed way.

Watch the below for another brief intro

Available in on the desktop which contains the most popular portions of Watson Studio Cloud to your Microsoft Windows or Apple Mac PC with IBM SPSS® Modeler, notebooks and IBM Data Refinery all within a single instal to bring you comprehensive and scalable data analysis and modelling abilities.

However, for the enterprise, there are also the versions of Watson Studio Local, which is a version of the software to be deployed on-premises inside the firewall, as well as Watson Studio Cloud is part of the IBM Cloud™, a public cloud platform. No matter which version your business may use you can start using Watson Studio Cloud and download a trial of the desktop version today!

Over the next 5 days, we'll ensure to send you use-cases and materials of worth for you to review at your earliest convenience. Be sure to check our social media pages for these.

print    

As business implements more and more technology to streamline their operations the benefits of saving time, minimising costs, increasing productivity and better accuracy are starting to be realised. This means this is hardly a trend that will fade anytime soon. If you or your business are not 'there yet' it’s better to catch up now rather than being left behind with the rest of the competition.

We've moved on from the times when cloud technology was an unknown territory for especially for Accounting and Finance but the industry players are now fully aware, prepared or in cloud. This leaves us to ponder where to next? I think people are now starting to set their attention to the adoption of artificial intelligence (AI) and we can see that this is happening at a much faster pace.

Both Data and work as we know it will be strongly affected by AI. With bots now able to determine and sort the information into different accounts by themselves, meaning AI is already delivering solo performances in the field. Further to this, Bots can tell and organise data coming from the same source into different categories, so if you have a monthly subscription and or one off purchases coming from the supplier, bots will automatically understand that they are of a different nature and will set them under different chart of accounts. Machine learning is also observable since these bots can learn from various human inputs to make better judgments and to adapt to accounting professionals’ behaviour patterns.

The effect or major changes due to AI on the typical Accounting and Finance role will have one of two observable outcomes:

• The menial / administrative tasks as they stand right now are slowly becoming scarcer, even some operational tasks traditionally performed by accountants, such as dedicated accounts payable and accounts receivable ones, are already being performed by AI or are outsourced.
• The other observable is the way accounting and finance will be structured within the organisation more than likely a small footprint but they have a greater impact.

The results of the above inevitably are better performance and enhanced cost reductions and although AI is already finding its way into the finance and accounting industry, it’s not been fully adopted quite yet. Without a doubt, the accounting industry has a bright future ahead with a focus more on value add than the menial.

Part 2 of this article might be a review of the tools avaialble. What do you think? Was my assessment fair? Leave comments, or feel free to reach out on social media.

print