Today, we’re excited to explore a game-changing function that enhances the versatility of your Planning Analytics platform. Imagine a tool that not only streamlines your data processes but also connects your Planning Analytics seamlessly with external systems. This innovation allows you to execute HTTP requests directly within your TurboIntegrator (TI) processes, transforming your Planning Analytics into an integral part of your interconnected ecosystem. Join us as we delve into the possibilities this function brings and how it can elevate your data management strategies to new heights.

Why Execute HTTP Request is a Game-Changer

What makes this function truly versatile is its ability to connect with any external system that supports APIs. The only limit is your imagination and the capabilities of the APIs you wish to connect to. Integrating Planning Analytics with external systems allows developers to break free from traditional limitations and extend the functionality of their applications.

This session will include practical demonstrations of several use cases that highlight the power of the Execute HTTP Request. By the end, I hope to inspire you to explore how you can leverage this function to enhance your TM1 applications and workflows.

Demo 1: Hot Promotion of Objects Between Instances

Let's dive into our first demonstration on how to perform hot promotion of objects from one instance to another. Traditionally, migrating objects between instances involved shutting down the target server. However, using the Execute HTTP Request, we can do this in real-time.

1. Setting Up the TI Process:
    
   • Open the workbench in your workspace and create a new TI process.
   • Declare necessary constants and set your source and target instances (e.g., SmartCo to Demo Server).
2. Use of HTTP Execute Request:
    
   • Fetch dimensions from the source instance and check for their existence in the target instance.
   • For non-existing dimensions, save them as JSON files and use the HTTP Execute Request to migrate them to the target instance.

Let’s execute this process! Once completed, you’ll see that the dimensions have been successfully migrated.

Demo 2: Executing a Process Across Instances

Next, we'll demonstrate the ability to execute a process from one instance in another:

1. Migrate TI Processes:
    
   • Similar to dimension migration, retrieve the TI process (like Sample TI) from the source instance and save it as a JSON file.
2. Execute the TI Process:
    
   • Use the Execute HTTP Request to trigger execution from the target instance, while utilising its response to capture status codes and log outputs.

After running this process, you should see that both the process has been migrated and executed successfully.

Demo 3: Loading Currency Conversion Rates

In this demo, we will load real-time currency conversion rates from a website using its API:

1. Call the API:
    
   • Set up an HTTP GET request to retrieve USD conversion rates.
2. Extract and Utilise Data:
    
   • Capture the JSON response and extract required currency rates using JSON functions.

Run the process, and you will observe the real-time conversion rates being fetched and displayed.

Demo 4: Sending Teams Notifications

Next, I’ll show you how to send automated notifications to Microsoft Teams:

1. Integrate with Microsoft Power Automate:
    
   • Set up a Power Automate flow to send notifications.
2. Trigger Notification from System:
    
   • Use Execute HTTP Request to trigger alerts in Teams based on process execution results.

After execution, you should see notifications appear in your Teams channel.

Demo 5: Sending Emails via HTTP Requests

Finally, we'll explore how to send emails:

1. Power Automate for Email Notifications:
    
   • Again, set up Power Automate to manage email sending through appropriate HTTP requests.
2. Dynamic Email Content:
    
   • Utilise dynamic fields for subject and body based on execution results.

After executing this process, you will receive the email in your mailbox.

Conclusion

Today, we have unlocked the extensive capabilities of the Execute HTTP Request function in IBM Planning Analytics. We showcased hot promotion between instances, cross-instance process execution, real-time data fetching, as well as integration with Microsoft Teams and email notifications. 

Thank you all for attending this session. I hope you found it beneficial and feel inspired to explore the functionality of Planning Analytics further. Let’s move toward a more integrated and dynamic future in our analytics processes!