What's new in Analytica 7.2?
Analytica 7.2 is the latest official release. Analytica 7.2 makes it safe to connect your models to databases and web services, works directly with live Google Sheets, understands the date formats web services use, and makes Analytica easier to drive from the keyboard, the command line, and AI assistants. Here's what's new since Analytica 7.1.
Highlights of Analytica 7.2
Live Google Sheets: The spreadsheet functions now work directly with live Google Sheets, as well as Excel workbooks.
Outline and easier navigation: A friendlier Outline window with hover icons and full keyboard control, a new Object / New menu for adding any kind of object, and new popups on Module nodes that show which variables connect one module to another.
Web-friendly dates and time zones: Analytica now reads the ISO 8601 date-times that most web services return, such as 2025-08-25T00:07:05Z, converts them to your model's time zone, and can write them back out.
AI integration: Cloud-based AI assistants, such as Claude.ai and Claude Cowork, can now use Analytica's MCP server on your desktop.
Secrets: Your model can now use database passwords and API keys without ever exposing them. A new Secret object holds the credential, and Analytica hands it only to the database or web service it's meant for — never to a result, a saved file, or someone else's server.
Encryption, custom sorting, and more: New built-in functions for strong encryption, custom sort orders, testing whether a file exists, and more.
No more object limit: The old limit of 65,500 objects in a model is gone.
Google Sheets and other data sources
- The spreadsheet functions now work directly with live Google Sheets.
SpreadsheetInfo(wb, 'Backend')tells you whether a workbook uses'LibXl','Excel'or'GoogleSheets'. FileExists(filepath, files, folders)tests whether a file or folder exists. (Requires Analytica Developer or better.)- (Advanced) Custom file system providers let a path like
"repo://Sales/Q3.csv"work anywhere Analytica accepts a file name, even when the "file" really lives in a git repository, cloud storage, or a document management system. You can also write your own provider.
User interface

- A friendlier Outline window:
- Hover icons on each item.
- Navigate with the keyboard: arrow keys move and expand/collapse, Home/End jump to the top or bottom, and typing searches as you type.
- Alt+Click an item to insert its identifier into the expression you're editing.
- Each module now has its own button to show or hide its non-module contents (replacing the Modules only checkbox).
- Object / New menu: The Object menu has a new New submenu for adding an object of any class — handy for classes that aren't on the toolbar (such as Frame node, Struct, Callable, or Secret), and for adding nodes without a mouse. New / Picture prompts for an image file.
- See what connects your modules: Module nodes now have input and output popups, like variables. Click just left of a Module node to see what flows into it, or just right to see what flows out. Because modules can have many connections, the popups show them as an expandable outline.

Click just left of a module, here Cost to Buy, to see its inputs. Expand one, such as Discount rate, to see which variables inside the module use it. - New Publish To Cloud dialog for publishing to ACP3 (today's ACP) and the upcoming ACP4.
- List editor: A user input node with a [List] control now opens a simple list-editor dialog, like the one in ACP, instead of the Object window.
- Drag and drop text within and between text attributes, without disturbing the clipboard.
- New settings in the Preferences dialog: how identifiers are generated from titles (Assista uses this too), whether display-only arrows are dashed, and the model's time zone.
- Added the SysVar Sys_NonClientAreaStyle that enables you to customize the appearance of the client MDI windows, such as by giving them wider, easier to grab, borders than in the Windows 11-style default.
Dates and time zones
- Web-style dates: ISO 8601 / RFC 3339 date-times with a UTC offset, such as
2025-08-25T00:07:05.000+0000(the form most web APIs return), are now understood by ParseDate, ParseCSV, table cells and definitions. You can even write them directly in expressions, e.g.,Sequence(2025-08-25T00:00:00, 2025-08-27T00:00:00, dateUnit: 'D'). - A time zone for your model: A new Time zone setting in the Preferences dialog says which time zone your model's dates are in. Dates with an explicit offset are converted into it, and Today() reports the time in it. ParseDate, ParseCSV, Today and NumberToText also take a new «timeZone» parameter.
- Write dates for web services: A new
'ISO8601'date format, e.g.,NumberToText(x, dateFormat: 'ISO8601', timeZone: 'UTC').
See Date and Time Values and Date formats for details.
Behavior change: A trailing Z on a date-time, as in ParseDate('2025-08-25T00:07:05Z'), was ignored in 7.0 and 7.1. It now means UTC, so such values shift by your time zone's offset from UTC. A literal Z in a custom date template must now be quoted ('Z').
|
AI integration
- Cloud-based AI clients, such as Claude.ai and Claude Cowork, can now use the MCP server in desktop Analytica, with a tunnel such as
cloudflaredorngrok. - New tools behind the scenes help Assista and MCP clients work with your models: ArrowDependencies reports exactly which variables create the dependencies between modules, and Evaluate's new «sideEffects» parameter can prevent an evaluation from changing the model.
Secrets

A Secret is a new kind of object that safely holds a credential your model needs, such as a database password, API key, or bearer token.
In your model, a Secret's identifier evaluates to a placeholder text, such as {{secret:AcmeKey}}, which you use in a connection string or URL like any other text:
DbQuery(f"DSN=AcmeWarehouse;UID=svc_reports;PWD={AcmeKey}", sql)
Analytica substitutes the real value only at the last moment, inside trusted built-in functions such as DbQuery and ReadFromURL, and only when the destination matches the Secret's policy. Your definitions stay fully readable, yet the credential never appears in any result, attribute, error message, or saved file, and model code can't send it anywhere else.
Create one with Object menu / New / Secret (requires Analytica Developer edition; models containing secrets load and run in every edition). See Secret for details, including what each storage option does and doesn't protect against.
Built-in functions
- Encryption: New functions for encryption and decryption using strong, standard authenticated encryption. (Requires Analytica Developer or better.)
- Custom sort orders: SortIndex, Sort and Rank accept a «lessThan» function. See Using an ordering function when sorting.
- Flatten has new «map» and «includeNull» parameters, making it easy to combine lists held in references or Struct members.
- UncertainLMH now allows «xLow» = «lb» or «xHigh» = «ub», putting a spike of probability at the bound.
- Area and Integrate in a DefineOptimization are now recognized as linear or quadratic when classifying the problem as LP, QP or NLP.
- New options for GetProcessInfo detect a non-Windows host (such as Linux) and installed fonts.
- HandleFromIdentifier has an «asIndex» parameter, like Handle.
- (Experimental) A new Timer struct schedules an evaluation.
Command line and automation
Analytica 7.2 adds several command line options for scripted workflows, testing and AI tools, including:
/evalThenExit:«expression»— evaluate, then exit without prompting to save./lib:«YourLib.ana»— load a library into SysLib_Customizations that stays available across models, e.g., for custom Assista skills or MCP servers./Automation— run without modal dialogs that wait for a user (see Automation)./WindowXY,/WindowSize,/stores,/Autosave, and more.
See Analytica Command Line for the full list.
Evaluation engine and other changes
- No limit on objects: The previous maximum of 65,500 objects has been removed.
- Null for the implicit dimension: You can pass Null to a repeated index parameter of any built-in function to mean the implicit dimension, so
...IndexesOf(x)works even when «x» has one. User-defined functions can do the same with the newnullIndexOkparameter qualifier. - Dynamic partial results: During a Dynamic calculation, partial results are now kept in new
dynValueanddynProbValueattributes;ValueandprobValuehold only fully computed results. Dateis no longer a reserved word, so you can use it as an identifier in your models. (The "Created date" attribute of models, modules, and libraries is still available asSysLib_Internal::Date, and the model file format is unchanged.)