Summary: Live Model slow, can be fixed by prioritising a filter I use a Live Model to return info about a few records from a big dataset. One filter should efficiently narrow the big dataset down. But the server sometimes applies other filters or joins first, making it unusably slow. I want an option to tell the Live Model to fetch the important filter's items first, and then write those items into the filtering clause when writing the main query. That will cause the server to correctly discover that applying the important filter first is the most efficient query plan.   Details (I'm querying SQL Server, but I suspect other sources would also benefit.) Sisense documentation says "Analytical Engine inserts filtering clauses into the innermost SQL statement. This means that filtering is the first operation performed". Sometimes that helps performance. But it depends on the source server. If you apply multiple filters or joins, the server may decide to perform a less efficient one first, or it may parallelise. In my case, my query went from a few seconds to over an hour depending on the server's choice.  The problem is that the server can't estimate the cardinality of the "filtering clauses" entered by Sisense. For example: The server doesn't know that my "dimCustomer.[Customer Name] = 'Joe Bloggs'" filter returns only 100 rows from my fact table, whereas "dimDateTime.FiscalYear = 2022" returns 100,000,000 rows from the fact table. There is a solution. Instead of "Where Fact.[Customer ID] In (Select [Customer ID] From dimCustomer Where [Customer Name] = 'Joe Bloggs')", Sisense should first run the query Select [Customer ID]... query to find that Joe's ID is 5. Then put the result into the filtering clause, i.e. "Where Fact.[Customer ID] IN (5)". For a hardcoded ID like that, the server can estimate the cardinality, so it sees that filtering on [Customer ID] first will be more efficient that other query plans. Sisense mustn't just do that for all filters. If it tries prefetching "dimDateTime.FiscalYear = 2022", that'll return all 31,536,000 seconds, and then pass that back in the query as "Where Fact.DateTimeID IN (...)".  Solution: The solution I request is: Allow the Live Model developer to set a "Prefetch Filter Items" flag on a field. If it is set, when a widget or dashboard filters that field, then Sisense first creates a query "Select dimSomething.[Relationship column] From dimSomething.FieldWithPrioritisedFilter". Then, when building the main query, change the "filtering clauses" to be "Where Fact.[Relationship column] IN (<put prefetched values here>)". Reference: For reference: https://docs.sisense.com/main/SisenseLinux/analytical-engine-overview.htm: Analytical Engine inserts filtering clauses into the innermost SQL statement. This means that filtering is the first operation performed, minimizing the number of rows that need to be scanned in order to process the query. Complex filters, such as top ranking and filter on measure are significantly improved as a result. Proof of concept: Build a Live Model. FactA joins to DimB on ID_B and to DimC on ID_C. The source is SQL Server. In SQL Server, all three tables have millions of rows, and the FactA has foreign keys to DimB and DimC. DimB.Name has a unique name for each row. DimC.Type is 1 for half the rows, and 0 for half the rows. Create a widget that filters for DimB.Name=<some name> and DimC.Type=1. Use SQL Profiler to find the query your Live Model runs. Run the query; it should take over a minute or time out. Then change the "Where FactA.ID_B IN (Select ID_B From DimB Where DimB.Name IN ('<some name>'))" to instead be "Where FactA.ID_B IN (<copy paste the ID of <some name> here>)". It should run much quicker. The original query might run quickly without change, depending on server settings; if so, mess about with more complicated joins or ask me. In my setting key queries were reliably slow. ... View more

When login as Admin, under ReportManager page, there is a setting button (the wheel at the top right side) that allow to customize the user UI experience. i.e. toggle in/off options : - archiving - priority - event based - csv export ... I would suggest a setting here to toggle on / off  "Apply customer filters" and button "Edit Report Filters" just like the other options. Thank you ... View more

Sisense charts show tooltips when you move the mouse above them. When showing those tooltips the website automatically formats numbers in the tooltip in order to simplify the reading and shrinks those numbers if they go above 10k. Most of the times this is what I want as a user, but not always. According to my observations, tooltips stop showing the real number and show a simplification when it goes above 10,000  (e.g instead of showing 16742 it will show 16.7k). This idea would be to allow this number to be displayed in full instead of the shrinked version. Sometimes it is just useful to see the real value and not the simplified one. As a user, I'd like to see the real one sometimes. There are two possible ways of implementing this that come to mind, in the Tooltip section when editing a graph: Add a checkbox, clickable, with the current behaviour by default "[ ] Show raw numbers". This would be below "[ ] Show Total in tooltip" Add a threshold numeric input so that users could manually specify from which number onwards the formatting would shrink (e.g 10,000 by default).  "Shrink numbers above: [            10000]" First option is simpler to understand, second one is more flexible.  Right now, the workaround I'm using is to Edit a chart, then click on "Output" in order to see the real numbers as a table, but this is inconvenient. Here is an example of the number I'm referring to, in a chart. You see 15.9k and I'd like to see 15935.   ... View more

Jump to Dashboard allows us to select values within Pivot tables and show the details of the items. This is user friendly and more efficient for users.  However, the feature does not work when we call the widget via Sisense.JS.  ... View more

We have configured Pulses that send through Webhooks to a Slack channel when certain elasticubes fail. This is a really helpful feature, BUT it would be even more helpful if there were the option to also send the error message along with the failure message so that the reason for failure displays in Slack. ... View more

It would be very helpful to be able to pass User or Group parameters as Claims in a Web Access Token. This will allow customers to leverage the dynamic features related to User/Group Parameters (e.g. dynamic live query) when using Web Access Tokens. ... View more

We want to be able to see certain metrics by day of the week on bar chart to detect certain patterns without adding a separate day of the week field for every date stamp into our data cube.  ... View more

Major process changes were made on a specific date in May. We would like to be able to add a phase change line in graph to represent an event change, so we can clearly see before and after comparison. ... View more

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 ... View more

Being able to use only 1 field to aggregate on when breaking by a dimension is quite limiting when we are wanting to look at YoY trends on a stacked column chart. I am surprised this has not been brought up yet as one would think this is a fairly common analytical need.  As a broad example, how would one look at YoY sales by day and stacked by product types? ... View more

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. ... View more

It would be nice to have an officially supported Events endpoint, that lists all the alerts / pulses / notifications that were sent out when an event was triggered. This allows users to create dashboards giving a quick overview of where problems occur. There already is an /events endpoint, but it is not officially supported and not listed in the APIs, so we were only able to find out about it by creating a support ticket. ... View more

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. ... View more

System emails like shared dashboards or report manager include links where the URL resolves to the Sisense instance. For white labeling / embedded products this doesn't work. If we had access to more variables when customizing templates we would have greater flexibility in designing workflows. Specifically if we had access to the <id> of the dashboard and instance & group level parameters this would make the messages far more customizable and useful in a variety of scenarios. Some of the other metadata as variables would also be very helpful and make emails more valuable. ... View more

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. ... View more

With the Sisense Report Manager add-on, we need the ability for a Viewer to create AND modify a report schedule that has been shared with them. Example: Jack (Designer) shared a report with Jill (Viewer) to monitor the health of her building assets. Jill would like to get a snapshot of this report emailed to her every month; however, she must manually communicate with Jack for him to create this report schedule on her behalf. Jill would like to create the report schedule herself.  Jack created the report schedule to be sent to Jill every month. After three months of this, Jill prefers the report schedule to be sent out on a weekly basis. She must manually communicate with Jack for him to modify this report schedule on her behalf. Jill would like to modify the report schedule herself.  Now multiply Jill by thousands of customers for our specific business use case... This will quickly become unsustainable for us. Please prioritize these features for Report Manager as it is a premium Sisense add-on.   We understand that today with the Sisense native scheduler, a Viewer would be able to modify their report schedule if the creator allows the Viewer to edit subscription settings. Why is this not a capability of the Sisense Report Manager, at the very least? ... View more

Users would like to have new options when choosing periodicity  of a programmation inside Report Manager : First Monday of the month (first Tuesday, Wed ...) Last Monday of the month (lastTuesday, Wed ...) Last day of the month ... View more

Add the name of the dashboard onwer in the email notification sent by Report Manager. Some users are receiving reports they don't expect from Report Manager . They don't know who has schedule d the report. They want this information so that they ask the owner to be removed from the distribution list. ... View more