Knowledge Base

JavaScript must be installed and enabled to use these boards.<p> Your browser appears to have JavaScript disabled or does not support JavaScript. Please refer to your browser's help file to determine how to enable JavaScript.

Knowledge Base

Featured article

Enable/disable field suggestions in the NLQ (Simple Ask) For the latest version of Sisense like L2024.x to have a field suggestion, you need to enable it. First of all, what is the field suggestion, as illustrated by the picture below, if you want to get the revenue not for all Brands, but just for the brand APPLES. You type "revenue for APPL" and get the field suggestion. ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. To enable this feature, you can do it in 2 ways. 1. Via REST API Go to Admin - REST API - 1.0 - nlq Find - POST /nlq/nlqAdvancedMode ALT text: A screenshot of a user interface showing a dropdown menu labeled "Widget" with options such as "Duplicate," "Delete," "Export," and "Simply Ask (NLQ)." Arrows highlight "Simply Ask (NLQ)" and "Modify NLQ Model" options within the menu. On the right, a panel labeled "Filters" displays an option to "Include all" under the "Brand" section. Press the button Try it out and after this Execute button After this, go to the dashboard, you should republish it After this, you should see the suggestions. 2. Changing the NLQ Model Go to simply ask and click on ‘Modify NLQ Model’. Look for the column we want to set the index to true and save it. Go to the dashboard, you should republish it. After this, our field suggestion should work perfectly. Why do we republish the dashboard after the changes, please check the article - Simply Ask (NLQ) Not Showing New Fields After Enabling Update For the versions L2024.2.x go to Admin - System Management - Configuration - 5 clicks on the logo - Ai-Integration - SimplyAsk and disable option - Hide Table Names May the force be with you

Knowledge Base Articles

Sorted by:

Postgres vs. MongoDB for Storing JSON Data — Which Should You Choose?

In the past, the Postgres vs. MongoDB debate looked like this: you had Postgres on one side, able to handle SQL (and later NoSQL) data, but not JSON. On the other, you had purpose-built database management systems (DBMS) — like MongoDB, which was de...

Benefits of JSON support in Postgres

The promise of Postgres JSON JSON support is the most interesting new Postgres feature of the last few years. It relaxes the primary constraint of SQL databases — the rigid schema structure — by letting you store semi-structured data in your tables ...