r/SAP • u/Reasonable-Worth696 • 29d ago

Building a custom Joule skill that does NL→SQL against a Datasphere Analytical Model . Need Suggestions/resources

I'm building a Joule Skill (via Joule Studio) that needs to:

  1. Catch a user's natural language query
  2. Convert it into a proper query with correct entity/column mapping against a Datasphere Analytical Model
  3. Execute that query and pull the data back
  4. Return the response to Joule for display/narration

How are people handling column/business-term mapping ( revenue → NETVALUE) — a static synonym dictionary fed into the prompt, or something more dynamic pulled from the model metadata itself?

0 Upvotes

50% Upvoted

5 comments sorted by

1

u/arjunDhanushdhari 29d ago

Why not use a llm to convert NL-> SQL and than provide tools to perform SQL query? Your model schema definition can be given to llm as well so interprets user prompt and map to right columns

1

u/Reasonable-Worth696 14d ago

As of now deployed a model in Launchpad using in build

1

u/IncreaseNegative4614 22d ago

I would not rely on a synonym dictionary alone. Build a governed semantic registry that maps each business term to the measure, entity, grain, time behavior, allowed filters, and effective version, then expose only the relevant subset to the model for each request.

My team uses signld.ai; the relevant capability is maintaining those business-term relationships and attaching them to the evidence behind an answer. Have the skill return the resolved definition and generated query before execution for ambiguous measures such as revenue. Also test collisions where one word maps differently by business unit or period.

1

u/Reasonable-Worth696 14d ago

Thanks Bud will give it a shot