Currently Notebooks provide a powerful opportunity to access and visualize data utilizing SQL and to add these to fusion dashboards.  Fusion's primary analytics environment allows for powerful dashboard-wide filters.   Currently dashboard filters do not apply to charts or tables which are created through notebooks even if the notebook is pointed to the exact same data table and column as other dashboard widgets.   Please develop the ability for dashboard filters to filter both fusion dashboard widgets and also notebook-based widgets.   ... View more

Hello, It is not possible to rename a cube, but it is possible de copy it. If we then move the existing dashoards to the copied cube, we have workaround to rename the cube. But with Perspective it is not possible to rename nor to copy. => It would be useful to be able to copy (duplicate) a perspective. Thank you ! Franck ... View more

Hi - Is it possible or planned to allow Sisense Narratives to connect to a different LLM provider? We are hosted in AWS and have restrictions around data transmission, so would need to use an internally available provider such as Bedrock instead of Arria for NLG. ... View more

Hi, We are having several issues when dealing with Elasticube Builds. We can now schedule the build (both UI and REST API), but we have no tool to monitor and control this key functionality. What's the history of the builds for a cube? When can we see the whole picture of the time each build for each cube happens to optimize resources and find concurrent builds in time? Now we can just see the last build log, as an isolated entity. We cannot monitor all the builds as a whole, to see the whole picture of all the builds (when it happened, how many time it got, etc.). As administrators, we have no way to control now this. Even we cannot check the history of builds for a cube. It's a critical feature for administrators.  Best ... View more

Hi Team,  In Support Portal we can have a lot of tickets raised and some of them are in Sisense side and some on our side.  Will it be possible to retrieve the info if a ticket is waiting from us or from Sisense directly in a list view ?  Thanks  Bastien   ... View more

working with the plugin ExtenedPivotOnPDF shows the header of the Pivot only on the first page, doesn’t show starting form the second page. Please add header of table on all the pages. ... View more

we have data with timestamp from our IOT Device up to ms.   we created the data model with our data and when we create a dashboard we can put a date range filter. but this filter work for year month and day. because we receive many data, we would like to be able to filter per hours and minutes like 10 Minutes or 2 hours.   thanks, Alexandre ... View more

Hello, In a multitenancy environment, it would be useful to be able to define an email notifications sender per tenant. ie : Tenant "Tenant A" : mail sender is "Sisense - A" Tenant "Tenant B" : mail sender is "Sisense - B" For now, email setup is only available from the default tenant, therefore unique accros all tenants. Thank you. Franck ... View more

Sisense currently supports Shared formulas to be moved as a part of data Models only. However not all Designers have access to edit/view data models So, they can't move shared formulas from one environment to another via data models Shared Formulas should be exported along-with Dashboards also   ... View more

We would like explanations to work with Formulas.  This have a few use cases that this benefit. Ideally a user can select a formula and generate a list of explanations with the data fields for the anomalies of the formula. ... View more

We have a few dashboards where the displayed data is only valid when a SINGLE ITEM is selected for a filter. We want to have the standard dashboard filters that our users are used to, but we want to prevent them from selecting more than one item at a time.  In the attached image, we want the red highlighted areas to be disabled (not selectable) for non-owners/non-editors of the dashboard.  We should be able to publish the dashboard with a default value for the filter and allow them to select a different value, but not multiple values.  ... View more

We've been asked by customers for the ability to view more results than the current max of 10 ("showing first 10 results") when hovering over a data point in a scatter map. ... View more

When we access the widget data directly(Here we are fetching data from JAQL call itself and are not fetching data using CSV request to Sisense) then it shows N/A instead of a blank string(where the value is NULL). Is there any way where we can get a blank string in place of the N/A which is being shown to represent a Null value? ... View more

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

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

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

Enhance the Header options when you download a widget as PDF (via ellipsis > Download > Download as PDF) to include the same options as when exporting a full dashboard as PDF. Dashboard PDF export offers "Date As Of", "Dataset Name" and "Dashboard Filters" in the Header options (attached). This is also needed when exporting specific widget, which only offers Title. ... 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

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