Awaqi BI Natural Language Query & Dashboard Copilot

1. Overview & Business Value#

Awaqi BI translates plain English or Amharic questions into optimized SQL/ORM queries, generating real-time pivot tables, charts, and summary KPI cards.

1. Example Natural Language Queries#

• "Show monthly revenue trend for retail branches in Addis Ababa for Q3."
• "Who are our top 5 most profitable enterprise clients this year?"
• "የዚህ ወር ከፍተኛ ሽያጭ ያላቸውን ምርቶች አሳየኝ።" (Show me top-selling products this month.)

{screenshot:ai-awaqi-bi-nl-query}

2. Execution Steps#

1. Open Business Intelligence → Awaqi AI Copilot.
2. Type or dictate your query into the prompt input.
3. The copilot displays the generated chart, underlying data table, and export options.

2. Prerequisites & Security Access Groups#

• Required Modules: muk_ai, muk_mcp, smarterp_ai_suite
• Security Group: Ashewa AI / User (Technical ID: muk_ai.group_ai_user)
• Master Data Dependencies: Configured AI provider credentials, active system prompts, and departmental cost centers.

3. Step-by-Step UI Execution & Verification#

Step 1: Navigating to the Operational Interface#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher and select Ashewa AI.
3. Select the operational workspace corresponding to this agent suite.

{screenshot:78-awaqi-bi-natural-language-query-copilot-step1-navigation}

Step 2: Executing Agent Actions#

1. Review agent prompts and execution parameters.
2. Trigger the scheduled or on-demand workflow action.
3. Validate output in the generated operational log.

{screenshot:78-awaqi-bi-natural-language-query-copilot-step2-execution}

4. Advanced Configuration Points#

• Scheduled Crons: muk_ai.ir_cron_agent_health_check runs every 30 minutes.
• Multi-Company Isolation: Multi-company record rules ensure agent context is isolated to Company 1 (Ashewa Technology Solutions S.C.).

5. Comprehensive Troubleshooting Matrix#