OpenAI and Azure AI Integration

Use the OpenAI or Azure OpenAI integration to generate scripts and images, dynamic text and infographics, calculations and lists, schedules, colors, and more. This enables you to generate a range of content, including complex code, by simply providing a text prompt.

Note: Admins can enable OpenAI or Azure OpenAI via the AI Settings in the Admin Console.

A core tenet of Decision Intelligence is AI and augmented analytics, which enabled users implement predictive and even prescriptive analytics. A variety of Pyramid's core functionalities are driven by AI, optimizing the user's experience from end-to-end. This includes tools for 'heuristics', automated 'data mining', 'predictive analysis', 'deep learning' and ultimately 'AI' in the context of data and its analysis.

In addition, OpenAI or Azure OpenAI is integrated throughout the Pyramid platform to enhance data modeling, data science, storyboard and publication design, and decision modeling. Pyramid facilitates the use of OpenAI's Chat GPT engine for a range of functions, including auto generating scripts, dynamic text, colors, and images.

Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent/ random results. Use at your own risk.

Where is OpenAI and Azure AI Integrated?

Pyramid Apps


Use the "Ask Chat GPT" function to generate SQL, DAX, and MDX code for complex data extraction queries in data modeling. You can also use this feature to R and Python ML scripts that can be used to produce ML models.

Use the Explain Code feature to generate an explanation of your script.


You can also use the ChatGpt PQL function to produce dynamic actions and alert schedules.


Use the ChatGpt PQL function to build custom Members (formulas) , Lists, KPIs, and Scripts. When working in script mode, the Generate PQL function lets you generate scripts based on a given prompt.


  • Generate scripts to build spreadsheet formulas directly into your business models in Tabulate.
  • Present and Publish

    Use the AI Image Generator to create images based on text prompts. This can help you to quickly and easily design your presentations, create master pages, and add custom graphics.

    You can also use the ChatGpt PQL function to produce dynamic text, place holders, and tooltips to dynamically display AI-generated text. In Presentations you can incorporate this function into alert schedules, tooltips , actions, and jump actions for presentations.

    In Publications you can also use the ChatGpt PQL function to define triggered scheduling, as well as report and page triggers,


  • Use the ChatGpt PQL function to produce dynamic text, place holder, tooltip, and infographic formulations, which can then be saved, shared, and used in presentations and publications.
  • Common Interfaces

    Color Picker

    Use the 'Find a Color' feature to generate a color using Pyramid's generative AI integration. The Color Picker is used in several locations across Discover, Present, Publish, Illustrate, and Tabulate. It's used to change the background color of reports and charts, and to change font colors for titles, labels, and more.


    Pyramid facilitates the scheduling and distribution of a number of tasks; these schedules can be configured based on PQL statements. The ChatGPT PQL function can be used to build scripts throughout the Pyramid platform for triggered scheduling, for alerts, publications and on-demand schedules

    ChatGpt AI-Driven PQL Function

    The Pyramid Query Language or PQL (pronounced 'Prequel') is a language built into Pyramid's PYRANA engine to allow users to construct queries that can run against the many SQL data stacks that Pyramid can query natively. PQL includes a vast array of operations and functions that allows users to query data and build analytical logic.

    Use the ChatGPT AI-driven PQL function (from the Common PQL functions) to write PQL expressions and generate various assets. This can be used to add additional information and background to your presentation; it cannot tell you about your data set.

    The ChatGPT PQL function is supporting in a number of locations, including:

    • Dynamic Functions Wizard: for defining dynamic functions to construct dynamic assets like text, infographics, actions, schedules, and more.
    • Formulate Script Editors: provides a script editor for constructing Custom Members, Lists, KPIs, and shared Custom Scripts in script mode.
    • PQL and MDX Editor: construct PQL or MDX expressions which can then be used to drive a range of behaviors.

    Explain Script

    Use the Explain Script function to produce an AI-generated description of the current script. This explanation can be generated regardless of the method used to write the script.

    The Explain Script function is accessible from the Ask ChatGPT dialog, and the scripting windows in Model.