Hi everyone,
I’ve recently been experimenting with using AI to generate OAS Analysis XML directly (specifically for OAS 6.4 on-premise)—essentially trying to short‑circuit the traditional UI flow by going from:
RPD metadata → Natural language → Analysis XML
In theory, this feels like a great candidate for automation, but in practice… it’s been pretty challenging.
What I Attempted
I exported our full RPD XML, then worked through an exercise trying to:
- Identify presentation layer objects (e.g., Skill Performance → Service Level %, Forecast Group Name)
- Construct valid Analysis XML
- Apply correct filter structures (logical/comparison nodes)
- Generate a working pivot-table-only report
Some of the issues I ran into:
- Strict and inconsistent XML schema validation rules
- Differences between:
sqlExpressioncomparison / logical filter blocks
- Filters being incorrectly interpreted as SELECT expressions instead of WHERE
- View handling quirks (e.g.
currentView, compound vs pivot precedence) - Needing very specific XML structures that aren’t documented well
- Inability to reliably generate fully valid XML without reverse-engineering a UI-generated report
What I’m Curious About
Has anyone in the community successfully implemented something along these lines?
1. AI-assisted XML / Analysis generation
- Are you using any tools (Copilot, GPT-based tools, internal LLMs, etc.) to:
- Generate OAS Analysis XML?
- Convert natural language → working analysis?
- If so:
- How are you handling schema correctness?
- Are you templating off existing XML?
2. RPD-aware tooling (this is the big one)
Has anyone seen or built anything like:
An MCP-style server / semantic layer API that:
- Reads the RPD
- Understands logical columns + joins
- Allows natural language queries
- Outputs:
- Analysis XML OR
- Logical SQL OR
- API-driven query results
Basically:
“Semantic layer as a service” for OAS/OBIEE
3. Platform/version differences
If you are doing AI-assisted reporting:
- What version are you on?
- OAS Cloud?
- OAC / Fusion Analytics?
- Still on-prem like 6.x?
- Are there newer features or APIs that make this easier?
My Current Conclusion (so far)
For OAS 6.4 on-prem, it seems like:
- XML is:
- ✅ usable for modifying existing analyses
- ❌ not easily usable for generating analyses from scratch
- There’s no exposed way to:
- Query the RPD programmatically in a semantic way
- Generate clean XML without leveraging UI-generated scaffolding
What I’d Love to Learn
- Are others going down this path?
- Any success stories or tooling recommendations?
- Even partial solutions (e.g., XML templating frameworks, scripting approaches, etc.)
Thanks in advance — really interested to hear how others are approaching AI in the OAS / OBIEE space.
Tim O
