MDX Queries and MDX CalculationsJTdCJTIydGl0bGUlMjIlM0ElMjJNRFglMjBRdWVyaWVzJTIwYW5kJTIwTURYJTIwQ2FsY3VsYXRpb25zJTIyJTdE

Parameter/Field	Description
Connection Name	A unique name that identifies your GenAI connections.
Provider	The name of the GenAI provider the system will use to generate output.
LLM Service URL	The URL of the provider-specific endpoint for generating output.
Authentication Key	A unique key for authenticating and authorizing requests to the provider's endpoint.
Model	The name of the GenAI LLM model used to generate the output.
Is Model Fine Tuned	Select one of the following: Yes: Select this option to fine-tune the model. No: Select this option if you do not want to fine-tune the model.
Usage	Select one of the following: MDX Calculations MDX Queries You can specify whether you want to use the feature for MDX calculations or MDX queries. If you want to create expressions for calculated measures or members, select MDX calculations. If you want to query on the semantic model, choose the MDX queries option. However: If you select the MDX calculations option, the Ask Kyvos Copilot option will appear in the Calculated Measures dialog box for creating expressions for calculated measures and members. If you select the MDX queries option, the Ask Kyvos Copilot option will appear in the Query Playground page. You can also set a default connection to be used for MDX calculations, MDX queries. To configure this, select the appropriate checkboxes as needed: Default Connection for MDX Calculations: Select this checkbox to set the default connection for MDX calculations. Default Connection for MDX Queries: Select this checkbox to set the default connection for MDX queries.
Temperature	Configures temperature, controlling randomness. Lowering it results in less random completions. As the temperature approaches zero, the model becomes deterministic and repetitive. It is recommended to alter either this or top p, but not both. Default Value: 1 Minimum Value: 0 Maximum Value: 2
Maximum length	Specifies the maximum number of tokens shared between the prompt and output, which varies by model. One token is roughly four characters for English text. Default Value: 1 Minimum Value: 0 Maximum Value: 10000
Top P	Controls diversity via nucleus sampling. If set to 0.5, half of all likelihood-weighted options are considered. It is recommended to adjust either this or the temperature parameter, but not both. Default Value: 1 Minimum Value: 0 Maximum Value: 1
Frequency penalty	Specifies a number between -2.0 and 2.0. Positive values penalize new tokens based on their frequency in the existing text. This reduces the likelihood of the model repeating the same line verbatim. Default Value: 1 Minimum Value: -2 Maximum Value: 2
Presence penalty	Specifies a number between -2.0 and 2.0. Positive values penalize new tokens based on their appearance in the text so far, thereby increasing the model's likelihood of discussing new topics. Default Value: 1 Minimum Value: -2 Maximum Value: 2

Conversational AI JTdCJTIydGl0bGUlMjIlM0ElMjJDb252ZXJzYXRpb25hbCUyMEFJJTIwJTIyJTdE

Parameter/Field	Description
Connection Name	A unique name that identifies your GenAI connections.
Provider	The name of the GenAI provider the system will use to generate output.
URL	The URL of the provider-specific endpoint for generating output.
Authentication Key	A unique key for authenticating and authorizing requests to the provider's endpoint.
Usage	Select the Conversational AI option. You can also set a default connection to be used for Conversational AI. To configure this, select the Default Connection for Conversational AI to set the default connection for Conversational AI purposes.
Model	The name of the GenAI LLM model used to generate the output.
Is Model Fine Tuned	Select one of the following: Yes: Select this option to fine-tune the model. No: Select this option if you do not want to fine-tune the model.
Prompt Token Limit	Specify the maximum tokens allowed for a prompt in a single request for the current provider. NOTE: The default value is 8000. The minimum value is 0.
Embedding Endpoint	Specify a unique identifier for end-user, which can help OpenAI monitor and detect abuse.
Allow Sending Data for NLG	Select Yes or No to specify whether the generated questions should include values or not.
Template Folder Path	Specify a folder path for templates.
Open AI Invoke Endpoint	Specify which model to be used to generate embedding.
Embedding Model Name	Specify model name to be used to generate embedding.
Similarity Threshold (Auto Correction)	Specify similarity threshold for query autocorrection. NOTE: The default value is 0.2 The minimum value is 2.
Max Retry Count for SQL Execution	Specify maximum retry count attempted so that we get correct query. NOTE: The default value is 0.
Upper Threshold	Enter the value to control RAG record selection. NOTE: The default value is 0.7.
Lower Threshold	Enter the value to control RAG record selection. NOTE: The default value is 0.4.
Maximum Records Requested	Enter the value to configure maximum records (RAG) required in a user prompt. NOTE: The default value is 10.
Max Rows Summary	Enter the value to configure maximum values for row summary. NOTE: The default value is 100.
Generate Content	Select Title, Summary, or Key Insight to determine the content to be generated, such as the title, summary, and key insights. NOTE: For summary and key insights, the value for 'Allow Sending Data for NLG', should be set to 'Yes'.

Browser not supported