Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.xpertai.cn/llms.txt

Use this file to discover all available pages before exploring further.

For general AI Assistant functionality, please refer to ๐Ÿค– AI Assistant. Semantic Model Copilot Command List:
CommandDescription
/tableCreate physical table
/dimensionCreate shared dimension
/hierarchyCreate hierarchy
/cubeCreate multidimensional dataset
/queryCreate query statement
/calculatedCreate calculated member command
/modelerModeler command

โ€‹
Model Global Commands

In the semantic model interface, the AI Assistant has the following commands available:

โ€‹
/table

The /table or /t ๐Ÿฆœ๏ธ๐Ÿ”— command is used to create physical tables.

โ€‹
/dimension

The /dimension /d ๐Ÿฆœ๏ธ๐Ÿ”— command is used to create shared dimensions based on table information and questions.
Users need to provide necessary dimension table information. You can drag table names from the data table area into the copilot to insert metadata into the conversation.
Example: 
/d create dimension call 'product_category' includes product category and model levels.

โ€‹
/cube

The /cube /c ๐Ÿฆœ๏ธ๐Ÿ”— command is used to create cubes based on table information and questions.
Users need to provide necessary cube information. You can drag table names from the data table area into the copilot to insert metadata into the conversation.
Example: 
/cube create cube call 'sales_cube' that includes shared dimensions: product and customer, and measures: sales amount, product cost, sales profit

โ€‹
Query Lab Commands

In the Query Lab interface, the AI Assistant has the following commands available: Copilot conversation content in this interface can be saved in query records. When users reopen a query, the copilot conversation content will be restored. For more Query Lab functionality, please refer to Query Lab

โ€‹
/query

The /query /q ๐Ÿฆœ๏ธ๐Ÿ”— command is used to execute data queries based on user descriptions. Users need to provide necessary query logic information and table information.
Users can drag table names from the table area to the Table Structure area to provide necessary table information.
/query Customer sales by country and year

SELECT
    c.country_region,
    SUBSTRING(s.order_date_key, 1, 4) AS year,
    SUM(s.sales_amount) AS total_sales_amount
FROM
    adv_sales s
    JOIN adv_customer c ON s.customer_key = c.customer_key
GROUP BY
    c.country_region,
    year
ORDER BY
    c.country_region,
    year;
The query will be automatically executed and results returned when the command completes. Modify query statement: 
/query Change the country field to city field

โ€‹
Querying Multidimensional Data Sources

If the semantic modelโ€™s corresponding data source is a multidimensional data source (such as SAP BW, Microsoft Analysis Services, and other systems supporting Xmla interface services), the Query command automatically uses MDX syntax statements for queries. 
/query sum SignData for every entity where category is [/CPMB/OUDV1E2].[Actual]

SELECT
  {[Measures].[/CPMB/SDATA]} ON COLUMNS,
  {[/CPMB/OUDMS0O].[LEVEL01].Members} ON ROWS
FROM [$/CPMB/OUMFJWF]
WHERE {[/CPMB/OUDV1E2].[Actual]}

โ€‹
Dimension Interface Commands

The following commands are available:

โ€‹
/hierarchy

The /hierarchy /h ๐Ÿฆœ๏ธ๐Ÿ”— command is used to create new hierarchies
Users need to drag the tables to be used from the data table area into the AI dialog box to provide necessary dimension table information. If table information is not provided, the copilot will only create hierarchies based on table information used in the current dimension.
Example: 
/h Create hierarchy including product and category

โ€‹
Dataset Commands

The following commands are available: Query Interface Calculation Interface

โ€‹
/query

The /query /q ๐Ÿฆœ๏ธ๐Ÿ”— command is used to execute data queries based on user descriptions. 
/query Create a statement to query the data: the most sales reseller
The /query command can also modify query statements in the current editor: 
/query Edit current statement refer to the error message: MDX object '[Reseller].[Reseller].[Not Applicable].[Not Applicable]' not found in cube 'Sales'

โ€‹
/calculated

The calculated /calc ๐Ÿฆœ๏ธ๐Ÿ”— command is used to create new calculated members. Users need to provide necessary calculation logic information. 
/calc Create calculated member
Name: Profit Margin
Formula: (Sales Amount - Cost) / Sales Amount * 100
Description: Calculate product profit margin

โ€‹
/formula

The /formula /f ๐Ÿฆœ๏ธ๐Ÿ”— command is used to edit the current calculated measure formula. Users need to provide necessary calculation logic information.

โ€‹
Access Control Interface Commands

The following commands are available:
  • /role Create role based on user description

โ€‹
Virtual Cube Page Commands

โ€‹
/formula

The /formula command is used to create suggestions for virtual cube calculation formulas. Users can enter commands and requirements in the copilot dialog box, and the copilot will generate corresponding calculation formulas for you. 
/formula Create a calculation for sales profit margin

โ€‹
/modeler

/modeler or /m The data modeler can create shared dimensions and multidimensional datasets based on user prompts and table information, referencing business role examples. This command makes the data modeling process more automated and efficient, allowing users to focus on data analysis and decision-making. Modeler Command