Pyramid's Formulate toolset enables non-technical users to build advanced business logic calculations, lists, KPIs, parameters, and scripts using a point-and-click interface. The code editor extends this functionality with an integrated development environment ("IDE") for advanced users to write both PQL and MDX statements, complete with drag-and-drop function libraries and metadata models. For an example of creating custom lists in the IDE, click here.
- Click here to learn how the PQL Editor works.
Access the Script Editor
To access the Script Mode IDE, click Script Mode from the ribbon in the Custom List designer:
Script Editor Workspace
From the Script Editor, drag the required function from the Functions list onto the canvas (orange highlight).
From the Metadata panel (blue highlight), inject the required model metadata into the function.
As usual, the execute button (green arrow) is used to test the function; the results are displayed in the Result Preview panel (purple highlight).
When you add custom members or global parameters from the Metadata panel to the script editor, you can hover over the Item ID to see the item name, its folder location, who created it, the create date, modification date, item ID, and formula type.
You can also open the formula in its relevant editor by holding Ctrl and clicking on the Item ID.
Script Language
The script language is PQL, unless using OLAP, Tabular or BW models, in which case the script language is MDX. To review a reference library of MDX functions, see Microsoft's MDX Function Reference.
Using AI to Generate Your PQL
You can use the Generative AI integration to generate PQL or MDX code for custom scripts.
Warning: When using LLMs, your assets are generated using public domain algorithms. This can produce erroneous and inconsistent or random results. Use at your own risk.
Chatbot
You can open the Chatbot in Formulate and use natural language prompts to build scripts that drive formulas, lists, or columns. For more information, see Creating calculations using the Chatbot.
LLM Function
You can use the LLM PQL function (part of the Common PQL library) as part of your script. This function sends a prompt to the LLM to generate some output and then adds the results into your PQL formula. For more information, see LLM (PQL).