We are trying to investigate how we can trigger a Sisense data model (schema) refresh from the API. This call would be made after a data pipeline schema change. We’ll need the calls to make to "Refresh Schema" how it is done in the UI. Original Community Post by @haarishussain : https://community.sisense.com/t5/help-and-how-to/sisense-api-model-refresh/td-p/21719 ... View more

Currently, dynamic/parameterized datasets are not supported in BigQuery connections. You can parameterize the service account information, which is great, but it would be helpful to be able to use a parameter to swap the dataset in the BigQuery connection based on who's currently viewing the dashboard.   For reference, parameterized datasets and schemas are supported by other database engines: Azure Synapse MS SQL MySQL PostgreSQL Redshift Snowflake ... View more

Upon receiving the warning "Maximum number of series (50) exceeded", the warning does not reappear with a widget, dashboard, or page refresh. Instead, a filter change is required in order to trigger it again. IMO the warning should persist with refreshes and be visible every time due to the impact of the limitation being exceed - data is literally missing from the widget and the widget does not reflect the data set expected by the user.  To that end of being clear about the impact of having more series than the limitation allows, the warning would be best reworded to indicate that impact and avoid users making decisions on an uncontrolled subset of data. For example, "Results limited to maximum number of series (50)..." or "Data limited..." This limitation should also be documented in Sisense documentation, but is not currently. ... View more

Add the ability to programmatically export a Widget with specific filters and/or to export it as a certain user using the /dashboard/{id}/widgets{id}/ endpoint. User Story#1 As an admin I want to make api calls to the widget pdf export endpoint and include userid and custom filters so that I can download an export on behalf of another user in the system and specify the filters  Acceptance Criteria I can pass 2 properties to the export endpoint: User Id and filters Both parameters are optional and can be used separately from each other If a user Id parameter is provided, the Widget is exported on behalf of the provided user including the current filters applied and data security rules. If a custom filters parameter is provided, the Widget is exported with the custom filters. There is no merge between the existing Widget filters and the custom filters parameter.  The is an option to provide an empty custom filters parameter, in this case, no filters are applied to the dashboard.  User story #2 As a user (not admin) I want to make api calls to the Widget pdf export endpoint and include custom filters so that I can download an export with custom filters  Acceptance Criteria I can pass a custom filters parameter to the export to the Export endpoint The custom filters parameter is a jaql query that will replace the current dashboard filters The custom filters will respect my data security  I can provide an empty custom filters parameter that will remove all filters from the report. ... View more

Hi, There are many widget types that are part of the core of an analytical solution. Examples like Tabber, Jump to Dashboard, Accordion... are tools that the business users find very powerful and gives Sisense the fleixbility in the visualization that put the platform in the road to copete with powerful visualization tools like Tableau. But, the profile of most of designers are business analyst or business users. To use and to configure properly this kind of visualizations, makes them to enter in a Javascript world, that it's very confusing and dirty. It makes that the promise of "self service" is not to close. I should be great if the configuration of this kind of visualization will be made from an user interface, without the need to write JS code.  Best ... View more

Can we get a "refresh schema for all tables" button? Reason: Our tables are usually "Select * From AnalyticsSchema.ViewName". We control which fields to return by editing the view, not the Sisense table definition. When a field gets added/removed/changed, we need to refresh schema. That's fine to do manually as you're working on that datamodel+views, but we need to refresh all when: We copy a datamodel to a different server. We need to refresh schema at least to double-check that the views are as expected on the new server. (If any fields have changed, then I'll need to go fix any widgets using those fields, or, more likely, update the view to include them.) A view gets edited, perhaps for a different datamodel, and my datamodel hasn't been updated.  I edit several views and want to refresh schema for all those Sisense tables. If I've changed used fields then I'll need to go into each table manually anyway so it doesn't matter, but I've had a case where I've removed unused fields from several views and now I need to click refresh schema on every table individually. ... View more

Currently there’s no way on the Sisense UI to have an overview of when the next ElastiCube Builds are set for. Having such info available would make it possible to easily select relevant time slots to run load testing scripts for instance, but also more broadly to help understand and finetune the current Builds orchestration. In order to do so, we would like for admin roles to have access to a single table-like page that would list all the Builds scheduled in the next 24 hours with the following columns: ElastiCube name Build start date Build theoretical end date* Last successful Build duration * Build theoretical end date = Build start date + Last successful Build duration * (or NULL in the rare event where the Build has never succeeded before) Additional features: CSV Export Sort option on column headers Pagination Note: a single Elasticube can have more than one entry (in the example below, we assume the admin user opens the page at 3:00 PM and the ElastiCube_B's Build is launched every 2 hours). ... View more

Hello, On PDFs previews there is different mechanism of showing dashboard. Basically there is now possibility to register any events such 'widgetbeforequery'. Which can lead to incorrect views. The idea here is simple, to add possibility to register and run events on PDF previews. ... View more

It would have been great if there was a quicker way to update the SSL certificates on the Sisense server without having to run the update install. There are clients who do not wish to provide internet connection on the server once Sisense install is complete. As I understand it, if Sisense was installed with internet connection on, then we need to have internet connection in order to re-run the installer successfully. So we will have to make a request to the client to provide internet connection again to run the update install. It would have been good if there was an alternative way to update the SSL certificate.  ... View more

We use jump to dashboard to allow users to view a data table to give them context to the chart they are looking at. For large data sets, this can lead to millions of records. The issue comes up when users try to then export this table. It would be nice if there was a way to set a hard limit to the number of records returned in a table/table with aggregation. When users try to download too large of a table, it impacts server performance for everyone, and the only way to really limit the tables right now and still allow them to be filterable on all required fields is not efficient (rank filter on a semi-unique identifier using the max of a unique identifier). I am looking to place simple guard rails into how much data can be exported into one file, I am flexible as to where this option presents itself and how - either a count of max records or a file size works. Having an option to set the max number of records returned in this widget type also would work. I would be fine with this as an option buried in the configuration settings page or within the admin page itself. I just want the option present somewhere. ... View more

This is a request to enhance this feature in community thread of the same title. This is useful because it allows users to see all the available dimension for a particular list of filters even if there are no facts for it. I understand that we can also use this community thread; however, this is only limited to 1 dimension. However, right now, it does not work when [Columns] field are added into pivot table. We would like to add a date/day [Columns]. Ideally for us, the left outer join should only be by the [Row] and allow data to be broken into [Columns]. ... View more

The email schedules have a limitation when the file used in attachment is large in size. Most email servers have a 25mb max limit.  It would be really helpful, if there was an option to include a downloadable link in the email. When a user schedules an email, with the link option, the attachment is downloaded to a temporary path and the link to that path is provided in the email. Clicking on the link should download the file from the temporary path which can be an s3 bucket or from some server. We can keep a retention policy of few days for the files. ... View more

I would like to see some improvements regarding the pivot table in Sisense: Measures as rows Right now, when you add multiple measures to the pivot table they are automatically added as an extra column. Every major player in the BI business allows for measures to be added as rows, I would like Sisense to do so as well Expandable dimensions (could be used for almost every widget type) Let's say I have a pivot table showing revenues with categories as rows and years as columns. Ideally, I would like these to be expandable, i.e. if I click on the + icon for years, it should show me the quarters, months and so on. This could also be implemented for line, bar and column charts.  For categories e.g. I would like to expand to sub-categories. The drill-down we have right now doesn't work, it zooms in on just 1 category losing an overview of the data.    ... View more

Within dashboards, the only way to know currently if there is a filter on a widget is to open that widget. This is VERY time consuming if there are multiple widgets within a dashboard (we sometimes have up to 10). Please add an icon at the top of widgets (near the pencil would be great). If the icon is grey, no widget level filter is set. If the icon is colored in, a filter is set. If a filter is set, mousing over the icon should return a preview of what the filter is. ... View more

Our customers want to use the same data field twice within a filter. For example, within the field primary impression we want to include "seizure" and exclude the value "pyschiatric/behavioral problem". Is this kind of functionality on the roadmap, or can we have it added? ... View more

We produce pre-built dashboards for our customers.  They can build their own as well.  Often, they will start with one of our pre-built dashboards and modify to their needs. Users want a way to "filter out" our pre-built once they have created their own.  One mechanism mentioned was the ability to "Favorite" a dashboard and have a new "Favorites" toggle on the Analytics tab. ... View more

Currently, we are using below Rest API to generate a daily report to know the users, groups, roles etc.  /api/v1/users/get We need an additional field (last_password_change_date) for reporting that would tell us when the user changed the password. ... View more

When viewing a Dashboard, it is impossible to determine whether there are filters being applied at the widget level without opening each widget individually and reviewing whether (a) the inheriting of Dashboard-level filters has been disabled and/or (b) if additional and/or conflicting filters have been applied at the widget-level. This makes troubleshooting and/or viewing Dashboards very cumbersome. I'd like to see a simple visual flag from the Dashboard view indicating that "there is a filter applied within this widget". It doesn't need to display what that filter is -- only that there is (or is not) a filter within the widget. ... View more

This is an "add on" request to this product request. Our customers need to be able to filter on datetime columns using a combination of both the date and the time. I'd like to see this added as a capability of filtering. For example, I'd like to filter records from "0800 yesterday to 0800 today". Or "0800 on Monday to 1700 Wednesday". Or "0800 4/1/23 to 0800 4/5/23". ... View more