Strategy One

Use a Python Query to Retrieve Data From Web Services

Starting in Strategy One (June 2025), you can establish live connections to web services using Python queries, replacing the need for XQuery.

Prerequisites

  • The Python Query Report is dependent on the Python Service functionality.

    • Python Service is available for use in containerized environments as well as uncontainerized Managed Cloud Enterprise (MCE) deployments.
    • To enable this feature, contact Strategy Support for assistance.

  • Required Privileges:

    • Use Scripts Python
    • Certify Python Scripts
    • Use Freeform SQL

Create Python Query Data Source

  1. Open the Workstation window.
  2. In the Navigation pane, next to Data Sources, click to create a new data source.

  3. In the Data Source Types window, select Python Query.

  4. Next to Name, enter a title for the data source.
  5. Optionally, provide a Description for the data source.

  6. From the Python Runtime drop-down list, select a Python Runtime.

  7. Configure the database connection, and then click Save.

Create a Python Query Report

  1. Open the Workstation window.

  2. Click File and select New Python Query Report.

    • If you are connected to multiple projects, select the desired project, and then click Select.
  3. From the Data Source drop-down list, select the Python Query data source.

  4. In the Python Editor, enter your Python code, and then click Run to display the data in the Table Preview tab.

    The Python code must contain a function called get_data() with a data frame object returned, as shown in the example below.

  5. If needed, add a prompt by clicking Insert Prompt on the toolbar.

  6. In the Mapping pane, map the columns to objects in the data source.

  7. On the toolbar, click the Save and Open Report icon .

  8. Add attribute and metrics to the Editor panel and run the report.

  9. Save and close the report.

Create a Python Query Cube

  1. Open the Workstation window.

  2. Click File and select New Python Query Report.

    • If you are connected to multiple projects, select the desired project, and then click Select.
  3. From the Data Source drop-down list, select the Python Query data source.

  4. In the Python Editor, enter your Python code, and then click Run to display the data in the Table Preview tab.

    The Python code must contain a function called get_data() with a data frame object returned, as shown in the example below.

  5. In the Mapping pane, map the columns to objects in the data source.

  6. On the toolbar, click the Save and Open Cube icon .
  7. Save and publish the cube.

Related Topics

Create and Edit Python Runtimes

Using XQuery to retrieve data from a web service

Prompts in Freeform SQL reports