You are an assistant for a BI software.\nfollow the analyst instructions and execute the most relevant instructions from the list of available functions.\nwhen choosing to execute an instruction, call the function.\nprovide a succinct explanation only after calling the function or in case you don't find any relevant instruction to execute.\nthe explanation should not mention the underlying function that was executed.\nthe explanation should preferably consist of a single sentence.
You are currently in the Discovery app. The user uses this app to build reports.
The language chosen by the user is 'en-US'. always respond in this explicitly specified language where free text response is expected, including textual function schema fields. use the specified language even when the user wrote the prompt in a different language than the one specified.
Before calling any function, follow these steps:
Understand the User's Request: Break it down into its core components.
Identify Required Functions: Determine which functions are needed to fulfill the request.
Analyze Dependencies: Check if any function requires data that is not immediately available.
Determine Execution Order: Sequence the function calls correctly to ensure all dependencies are resolved before proceeding.
Execute in Sequence: Call the first tool in the determined sequence.
[
{
"role": "user",
"content": "
the semantic model is comprised of 3 separate lists of columns: 1) Model Attributes 2) Model Measures 3) Hierarchies and levels.\nwhen calling an instruction according to its schema, every field that ends with '_pyramid_measure' should only receive a value from the list of available Model Measures (if the same field is of type array it should receive a list that is a subset of the list of available Model Measures). Every field that ends with '_pyramid_attribute' should only receive a value from the list of available Model Attributes or Hierarchies and Levels (if the same field is of type array it should receive a list that is a subset of the list of available Model Attributes). Never make up measures , attributes, hierarchies and levels that do not appear in this list!\n\nthe following is the list of available Model Attributes and their metadata where each line on the list is formatted as \n'(attribute_name, the one needed as result to functions)': [caption->(member caption, as a user will call it),category->(type of attribute)]\nif a synonym is used, treat it as the user talked about its matching attribute_name\nStart of Model Attributes List\n'[customerProfile].[Marital Status]': caption->'Marital Status'\n'[customerProfile].[Gender]': caption->'Gender'\n'[customerProfile].[Education]': caption->'Education'\n'[customerProfile].[Occupation]': caption->'Occupation'\n'[customerProfile].[Home Owner]': caption->'Home Owner'\n'[customerProfile].[Commute Distance]': caption->'Commute Distance'\n'[customerProfile].[Purchased Bike]': caption->'Purchased Bike'\n'[customers].[FirstName]': caption->'FirstName'\n'[customers].[LastName]': caption->'LastName'\n'[customers].[Address]': caption->'Address', category->'GeoAddress'\n'[customers].[City]': caption->'City', category->'GeoCity'\n'[customers].[County]': caption->'County', category->'GeoCounty'\n'[customers].[State Code]': caption->'State Code', category->'GeoState'\n'[customers].[State]': caption->'State', category->'GeoState'\n'[customers].⟨ZIP⟩': caption->'ZIP', category->'GeoZip'\n'[customers].[Phone]': caption->'Phone'\n'[customers].[Email]': caption->'Email'\n'[customers].[Country]': caption->'Country', category->'GeoCountry'\n'[data].[transactionID]': caption->'transactionID'\n'[data].[dateKey]': caption->'dateKey', category->'DateTime', data type->'DateTime'\n'[data].[dateKey year]': caption->'dateKey year'\n'[data].[dateKey full quarter]': caption->'dateKey full quarter'\n'[data].[dateKey full quarter start date]': caption->'dateKey full quarter start date', category->'DateTime', data type->'DateTime'\n'[data].[dateKey full month name]': caption->'dateKey full month name'\n'[data].[dateKey full month start date]': caption->'dateKey full month start date', category->'DateTime', data type->'DateTime'\n'[data].[dateKey full week]': caption->'dateKey full week'\n'[data].[dateKey full week start date]': caption->'dateKey full week start date', category->'DateTime', data type->'DateTime'\n'[data].[dateKey month name]': caption->'dateKey month name'\n'[data].[dateKey weekday name]': caption->'dateKey weekday name'\n'[data].[dateKey time]': caption->'dateKey time', category->'DateTime', data type->'DateTime'\n'[data].[dateKey date]': caption->'dateKey date', category->'DateTime', data type->'DateTime'\n'[manufacturer details].[Manufacturer Grouping]': caption->'Manufacturer Grouping'\n'[manufacturer details].[Market]': caption->'Market'\n'[manufacturers].[Manufacturer]': caption->'Manufacturer'\n'[products].[Product]': caption->'Product'\n'[products].[Product Sub Category]': caption->'Product Sub Category'\n'[products].[Product Category]': caption->'Product Category'\n'[products].[Color]': caption->'Color'\n'[products].[Size]': caption->'Size'\n'[products].[Weight]': caption->'Weight'\n'[products].[Class]': caption->'Class'\n'[products].[Style]': caption->'Style'\n'[products].[ModelName]': caption->'ModelName'\n'[products].[StandardCost]': caption->'StandardCost'\n'[promotions].[Promotion]': caption->'Promotion'\n'[promotions].[Promotion Category]': caption->'Promotion Category'\n'[promotions].[Promotion Type]': caption->'Promotion Type'\nEnd of Model Attributes List\n\nthe following is the list of available Model Measures and their metadata where each row on the list is formatted as '': [''->'', ...]:\nStart of Model Measures List\n'[measures].[data Expenses]': caption->'Expenses'\n'[measures].[data Sales]': caption->'Sales'\n'[measures].[data Quantity]': caption->'Quantity'\n'[measures].[data Price]': caption->'Price'\nEnd of Model Measures List
"
},
{
"role": "user",
"content": "The current date is Sun Feb 02 18:14:06 IST 2025"
},
{
"role": "system",
"content": "Function-Specific Instructions:\nFor createCalculationPrompt: \nExtract all calculations, including those explicitly mentioned and those implied by missing attributes. \nIf multiple calculations are required, each must be encoded separately in calculationDetails. \nBefore finalizing the function call, verify that every calculation needed for query generation exists. \nBefore calling createCalculation, list all extracted calculations. Compare them to the user request and verify that no calculation is missing before proceeding. \n\nExample Thought Process Prompt: \nUser Request: ‘Profit by Product and Full Name’ \nStep 1: Identify Required Calculations The user wants Profit → This requires a CustomMember. \nThe user wants Full Name → This is a CustomColumn. \nStep 2: Ensure All Calculations Are Included Are both calculations accounted for? \n✅ If any are missing, extract and add them.\nStep 3: Ensure All unnecessary Calculations are excluded. \n✅ If any calculation has the "hasCorrespondingMeasureOrAttribute" property as 'true', then remove it from the list.",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"shouldNotGenerateAudio": false
},
{
"role": "user",
"content": "the following is the json representation of the Query Object Model that the user currently sees: (this is the only source of truth to determine the most up-to-date state of the query and it overrides any state derived by previous communications)\n***{"measures_pyramid_measure":[],"selections":[],"slicers":[],"orderMacros":[],"filterByValue":[]}***. remember that when we mention Query Object Model in the next requests we mean this object."
},
{
"role": "user,
"content": "show manufacturer by expenses",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"shouldNotGenerateAudio": false
},
{
"role": "assistant",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"functionCall": {
"functionName": "choosePath",
"arguments": "{"includeMembers":false}"
},
"shouldNotGenerateAudio": false
},
{
"role": "assistant",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"functionCall": {
"functionName": "createQuery",
"arguments": "{"measures_pyramid_measure":["[measures].[data Expenses]"],"selections":[{"attribute_pyramid_attribute":"[manufacturers].[Manufacturer]"}],"nextRequestExample":"Add a filter to show only the top 5 manufacturers by expenses."}"
},
"shouldNotGenerateAudio": false
},
{
"role": "assistant"
"content": "The query now displays the "Manufacturer" along with the "Expenses".",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"shouldNotGenerateAudio": false
},
{
"role": "user",
"content": "the following is the json representation of the Query Object Model that the user currently sees: (this is the only source of truth to determine the most up-to-date state of the query and it overrides any state derived by previous communications)\n***{"measures_pyramid_measure":["[measures].[data Expenses]"],"selections":[{"attribute_pyramid_attribute":"[manufacturers].[Manufacturer]","members":[]}],"slicers":[],"orderMacros":[],"filterByValue":[]}. remember that when we mention Query Object Model in the next requests we mean this object.",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"shouldNotGenerateAudio": false
},
{
"role": "user",
"content": "create profit",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"shouldNotGenerateAudio": false
},
{
"role": "assistant",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"functionCall": {
"functionName": "choosePath",
"arguments": "{"includeMembers":false}"
},
"shouldNotGenerateAudio": false
},
{
"role": "assistant",
"isInternal": false,
"isRequestScope": false,
"isLlmSuggestion": false,
"functionCall": {
"functionName": "createCalculationPrompt",
"arguments": "{"calculationDetails":[{"calculationType":"CustomMember","calculationPrompt":"Profit","hasCorrespondingMeasureOrAttribute":false}]}"
},
"shouldNotGenerateAudio": false
},
{
"role": "function",
"content": " the following Calculation was created successfully. If unspecified, immediately update the user's existing query by adding this calculation to the appropriate place in createQuery. Use it in subsequent functions calls as if it is part of the Model List above. It should be used following the exact same rules as those outlined in the Model List \n:\nStart of Additional Model Measures List*** \n'aeb293af-6505-4c29-b623-005227092a84': caption->'Profit', caption synonyms->'Profit'\n End of Additional Model Measures List \n",
"isInternal": true,
"isRequestScope": false,
"isLlmSuggestion": false,
"functionName": "createCalculationPrompt",
"shouldNotGenerateAudio": false
}
]
