Whether teradata MACRO is applied

[cynergy72]

I believe the MCP server and semantic layer offer a great opportunity to accelerate the use of domain-specific structured data in Vantage through LLM integration.

In particular, it seems well-suited for initial application in areas aligned with structured reports currently delivered through BI tools.

One question I have is whether it would be possible to apply this approach to environments where structured reports are being delivered via MACRO-based logic in modern BI systems, as is the case with certain clients.

[remi-td]

Hi,

This is a good point. I don't see any reason why this wouldn't work for the query objects (parametric or not): just spedicy a execute macro ... sql statement in the yaml.

This wouldn't work out of the box for the cubes construct as we dynamically generate sql around the base sql specified in the yaml.

Macros (like views) would provide us with a good way to embed the SQL logic in the platform so you can reuse it elsewhere and don't overload the yaml. So this is a good pattern.

If you would like to try it for your projects, and see any limitation, don't hesitate to raise a bug or a feature request, happy to look into it.

Cheers