Notebooks / Elasticubes - support full set of SQL

andrewtorrance · ‎06-19-2023

When connecting a notebook to an Elasticube, there is no indication what subset of SQL is expected to work Simple features like setting Cell 1 = select * from some_table Cell 2 = select * from Cell1 give errors suggesting the WITH syntax is not permitted, which is a bit of an issue given how heavily notebooks rely on it. There also seems to be limitations using ORDER/LIMIT in subqueries (which is fairly essential if CTEs arent allowed) Any real use of Notebooks on Elasticubes seems quite far away without finishing this feature

midkadavil · ‎06-14-2023

Use Case: As a user, I want to be able to share a dashboard with another user with the pre-selected filters so that they can see the same results as I do. Description: The current functionality of the dashboard filters is user-specific, meaning that each user has their own selected filters. However, there is a need to enable users to share a dashboard with another user, ensuring that the pre-selected filters are applied, allowing them to view the same results. This enhancement would allow a user to easily share a dashboard, including their filter selections, with another user. When the recipient accesses the shared dashboard, they would see the same filter settings as the original user, providing a consistent and synchronized view of the data. By enabling the ability to share dashboards with pre-selected filters, users can streamline collaboration, discussions, and decision-making processes. This feature enhances the dashboard-sharing experience and ensures that all parties involved are viewing the same data and insights.

wmehraj · ‎06-09-2023

We would like to configure multiple data security rules on a live data source table. With the available APIs there is a constraint to set one rule at a time. Having an API that accepts a collection of multiple rules is desired for our use case since we have more that 18,000 rules to be set.

joeshepper · ‎06-08-2023

I use pulse alerts to alert my clients when there is data on Sisense that needs their attention. The Pulse alert emails are accompanied by a big yellow 'Open Pulse' button. This button is the obvious thing to click on, but unhelpfully, it leads to the 'Pulses' tab of Sisense, not the actual dashboard. As a viewer, I want to jump straight to the dashboard, not be confused but this 'Pulses' tab which I most likely will not have seen before nor used. An option to have the button instead open the dashboard directly would be much better and make it much easier to engage customers with the Sisense platform. I know there is a link to the dashboard on the pulse itself, but going via this screen this is inconvenient at best and confusing at worst.

bobhenry · ‎05-17-2023

With the "Jump to Dashboard" add-on installed & the "suppress _drill_" dashboard parameter configured, SiSense hides the _drill_ dashboards from everyone except the owner (which includes the sisenseadmin account). As a result, it is hard for the administrator to view and/or manage _drill_ dashboards that are owned by a designer. There is a workaround via F12 that SiSense showed me, but it's not intuitive. It would be nice if there was a parameter to allow the sisenseadmin to always have the ability to see/edit the _drill_ dashboards (or perhaps that should be the default behavior).

joeshepper · ‎01-23-2024

Various features in Sisense can be whitelabelled. However, as well as the website, email notifications are another area of Sisense that customers will interact with. Email text configuration can be controlled via the 'email-templates.js' file, but there is not currently a way to whitelabel this text. I would like the option to change this text a deliver different messages for tenants. This would be useful for things like platform invitations in particular, to reassure users that an invitation from a 'Sisense' platform they may be unfamiliar with, is in fact associated with their company.

joeshepper · ‎01-23-2024

Sisense has some powerful whitelabelling features, but a key 'weak point' here is the URL itself. Currently, any Tenant has to be after the URL, e.g. for a company 'newcompany' at our company (Shepper), the URL would be shepper.sisense.com/newcompany. If we are delivering a whitelabelled solution for 'newcompany', where they want to whitelabel with newcompany assets only, there is no way to whitelabel the URL itself. I would like to keep the 'Shepper' text for most of our customers, but having an option to have an alternative URL for a tenant, such as newcompany.sisense.com (or even something that obscures our company's name a little, like shp.sisense.com/newcompany), would be the last piece of this whitelabelling puzzle.

OleksandrB · ‎01-16-2024

Hi, for this moment we have such a behaviour: sum(NULL * 10) = NULL but SUM(NULL * [id]) = [id] in the same time if [id] have values (1,NULL) and we will do SUM([id]) = NULL Is it possible to add some toggle in the system how to work with NULL values. For example, if it is disabled it works as NULL is empty and SUM(NULL * [id]) = [id] But if it is enabled, so all NULL should be works as in mathematic SUM(NULL * [id]) = NULL etc

tjswing · ‎04-26-2023

Currently, when you share a dashboard you can have it email the dashboard out to people following a couple different schedules: Every Elasticube update (with a limit on times per day) Daily (can specify which days and a time) Monthly (can specify which months and what day of the month) The trick is that elasticube updates includes failed updates. I would like to add an option to exclude failed builds from triggering these dashboard update deliveries. Now that we have alerting for build failures, there doesn't seem to be a reason for dashboards to deliver without new information.

dirons · ‎12-14-2023

We embed and white label Sisense and our premium customers have the ability to author new dashboards with the formulas and attributes we provide. Our users want the ability to create new attributes, comparable to creating a new formulas. Examples: new "Northeast Location" attribute = existing location attribute that we provide where sites = A, B, C new "Shutdown 2023" = existing date field that we provide where date range between X and Y Concatenation of multiple fields to form a new attributes, comparable to Excel new "Is True" type attributes = existing attributes we expose if value(s) = ... Customers want the ability to create their own custom attribute, have then be added to the default values list, in their own "custom" section, where they can search and reuse their own creations. We are a multi-tenant solution provider so tenancy of these custom creation must stay "in tenant" and must do so with us implementing the multi-tenancy feature of Sisense (as we are already deployed and this is not yet robust enough for us to utilize)

zach_myt · ‎12-07-2023

A nice feature in Microsoft SQL Server is the ability to see multiple data sets from queries in stacked windows. Currently only one query can be executed at a time and only display that one query's data set. It would be nice to be able to compare data by having multiple data sets appear at the bottom. Currently I have to open multiple browser windows to compare values and it can get a bit busy. It would be nice to compare 2 or more queries in the same window. Select * from table 1 where id = 123 Select * from table 1 where id = 456 data set for id = 123 data set for id = 456

dirons · ‎11-15-2023

A user would like to remove the title from the secondary indicator. Unchecking the Title box works for only the primary value. They would like the same functionality for the secondary.

gdartigueeis · ‎11-13-2023

As of L2023.3, in Sisense’s Helm Charts , “Tolerations” are supported by the micro-services. It prevents end-users from configuring “Taints” on the node that they want to dedicate to Sisense. Since no “Taints” are configured, so all nodes can become eligible to host Sisenses’s pods. They experienced that scenario when pods from some other application services were scheduled on a Sisense node. Would you please consider allowing the pods to be protected not only with “Toleration” but also with “Taints”. The justification for this is that, even though it is mentioned in prerequisites documents that Sisense should be installed on dedicated servers, there is a non-negligible factor from the customers perspective that is the overhead administrative costs, especially for customers who must already manage numerous clusters for several applications, multiple environments, and redundancy.

gdartigueeis · ‎11-13-2023

There are cases where the Sisense queries have to read from views. Would you consider allowing to issue queries like “ALTER database.materializedView REBUILD” instead of only allowing select commands, in this case this would allow to refresh data that would be selected by the jdbc connector.

gdartigueeis · ‎11-13-2023

Some end-users have strict environmental and security constraints for their operations. Please consider including M.I.T. Kerberos binaries and environment variable so that JDBC connectors could leverage Kerberos without having to access Kubernetes hosts machines.

fschleich · ‎11-07-2023

Hello, Currently, we can only sort reports based on column "Report name". It would be good to sort reports based on "last run" column too. It would also be good to have sizeable column headers for better readability. Thank you ! Franck

sumana · ‎10-12-2023

We propose adding a valuable feature to our dashboard UI: the ability to export a comprehensive list of all data models, including both Elasticubes and live models. This enhancement is essential for efficiently monitoring model changes before and after Sisense upgrades. Presently, this process involves manual actions like taking screenshots or exporting a text file using 'si' commands, but it lacks the capability to export live models and essential metadata such as data model type, owner, last modification date, last publication date, activity, and size. By introducing export functionality in formats like CSV, users will be equipped to easily track and compare models, quickly identifying any discrepancies or replacements. This improvement will significantly streamline model management and ensure seamless transitions during upgrades.

williedklein · ‎10-02-2023

Currently the box and whisker plot is not supported when using a live model. When the widget is created, it has an error and won't show any data. We would really like that to be supported on the live model. Article showing that its not supported: https://docs.sisense.com/win/SisenseWin/live-connect.htm

priyankadhuri · ‎09-27-2023

This is a request coming from customer Akita Box. They would want to be able to schedule a build at every 10 minute past an hour (Eg: 1.10 AM, 2.10 AM, 3.10 AM Etc) and 40 minutes past an hour (Eg: 1.40 AM, 2.40 AM, 3.40 AM Etc) for a few cubes. This is to ensure that a few cubes build after their main cube abx-0 finishes building which is currently set to build at every half hour interval.

pausan-gh · ‎09-22-2023

I use Chrome browser. I keep multiple tabs of sisense opened. When the session expires, it expires on ALL the tabs (which makes total sense). The problem is that all those tabs get redirected to the login page and I need to login on each and every one of them. It does not detect I've logged in in another tab, neither if I hit the browser Refresh button it will detect the login and redirect me to the page I was in before I got logged out. This is annoying because I have to either login again, or open a new window and search for the dashboard I had open. Ideal expected behaviour (preferred, but probably harder): Once I'm logged out on several tabs, logging in one of them should make the others notice and log me in automatically. Good-enough behaviour ("easier"): Once I'm logged out on several tabs, logging in one of them should allow me to go to other opened tabs, which are showing the login windows, and refresh them (e.g using Ctrl+R) so that itwill automatically detect my session and redirect to the page I was before I was logged out. This will save me a lot of time and make sisense less annoying.

Sisense Community

Notebooks / Elasticubes - support full set of SQL

Sharable link with Filters enabled

Data Security Bulk provisioning API

Let Pulse alert email's button link to dashboard instead of 'Pulses' tab

Find _drill_ Jump To Dashboard

Change Email Text for Tenant

Change Website URL Whitelabelling For Tenants

Working with NULL values

Send out Dashboards Only On Elasticube Build Successes

Allow Designers to create custom attributes comparable to shared formulas

Multiple data sets in one query window

Ability to remove Title (via Design panel) for the secondary value in an indicator

Adding Taints to Pod level

Recompiling views

JDBC connector - Kerberos

ReportManager - Add sort options / sizeable columns

Feature to export all datamodels from UI

Box and Whisker on Live Model

Request to enable customers schedule builds at specific times in a day

Detect I'm already logged in on "login" windows