Hi, We have two cloud servers in Sisense: one for development (staging) and one for production. The staging server connects to our staging database. The production server connects to our production database. All cubes and dashboards are identical except for database connection strings and names. Our Git branching strategy follows these steps: Create a feature branch from staging. Make changes and push them to the feature branch. Open a pull request from the feature branch to staging. Test changes in staging. If approved, merge staging into master (production) to deploy changes. The Issue Git integration tracks database connection names, meaning both servers must either run on staging data or production data—this is not feasible for us. Proposed Solution We suggest implementing a decentralized environmental variable for storing database connections. For example: Use {database-server-name} as a placeholder in configurations. Set database-server-name = db_server_staging on staging. Set database-server-name = db_server_production on production. This would allow the same codebase to dynamically connect to the appropriate database without manual adjustments. Would love to hear your thoughts on this! ... View more

Idea: usage analytics reports can tell what reports use a certain field? Filter by a certain field in the usage analytics report and you will see all dashboards using that field.  It would also be beneficial to track table usage in dashboards too.  Use Case: region will be renamed to region_usa in our sql query and this could potentially break dashboards. to be proactive, i would like to know what dashboards are currently using the field 'region' so that I can redirect them to the correct field, 'region_usa' once the sisense schema & sql has been updated. ... View more

People sometimes build bad data models. Rather than them doing more training (or asking me to help), you could build a tool that points out common problems. The user would click a button, wait a minute or so, and then get a list of potential problems and suggested changes. The tool would describe an example using their data that they can use to prove the problem (e.g. "filter a widget by Location and Date and then you see it's double counting the Dollars field"); that would be more motivating than an abstract argument. Not only can they debug themselves, doing so will be better than training for teaching them to design better data models. Here are my ideas for issues to look for. They might not always indicate a problem, but you can point them out for the user to decide. Do they use a convention for distinguishing Fact and Dim tables? Typically "fact" and "dim" prefixes for table names. Does any widget use a dim-table field in an aggregation in a Values pane formulas? Does any widget use a fact-table field in a non-values pane, or as a members filter in a formula? Do any dim-tables join to a fact-table via another fact-table? Does any pair of tables have multiple relationship paths of the shortest length? (Should be only one short path and it shouldn't include a fact table, but there might be several longer ones via other fact tables.) Any many-to-many relationships? Sometimes this is intentional and the user is meant to select a single item from a dim-table, so maybe ignore it if all uses in widgets filter one side of the relationship. ... View more

As an admin, have an option at the top of a dashboard to be able to view it as another specific user.  For example, if user John Smith is set under the data security on a cube to only have access to rows for a certain region, the ability to view a dashboard as John Smith would make checking user access very easy. ... View more

Recently, we were trying to create a widget using the RPAVG function for a rolling 30-day average, which broke our connection to the live model while working (to an extent) on an elasticube. The function worked past the first 30 days on the elasticube, while the first thirty days were (SUM N )/ N. This formula works past those thirty days, but for the first value, for example, gives simply the first value.  A new version of these functions would be greatly appreciated.  ... View more

It would be helpful to choose where on a dashboard to add a new widget rather than it only being added to the bottom of the dashboard. ... View more

Instead of having to manually set the same format for each date type over and over, it would be nice if you could set defaults for each date type (Year, Quarter, Month, Week, Day) somewhere and have everything default to that with the ability to change away from the default if needed.  This could be done in the same area we set First Day of Week and Fiscal Year for the server. ... View more

Currently the values that get displayed in a "text" based dashboard filter is sorted by default in ascending order. This is ok for most cases. But for certain cases (e.g. date as text) - we wish to showcase values in descending order. Hence, the feature request for allowing sorting in dashboard filters. ... View more

WE NEED THE ABILITY TO DO A LEFT JOIN WITHIN THE SISENSE DATA MODEL ... View more

We have created many folders (and subfolders) to help us organize our dashboards. It is currently very cumbersome to share folder access and ownership, which must be done for every dashboard within the folders. It would be nice if there were an easy (and native) way to share access to a folder and every dashboard within it, or to change ownership of a folder. ... View more

Hello Everyone! There are a lot of Ideas around improving the ability to format the text in Widgets. We appreciate all the feedback! In order to make it easer for people to find and contribute to the discussion, I am combining them into this thread. Everyone, what are the customizations that you would like to see in the GUI rather than using a script? One of the ways we prioritize development efforts is by community interest. I encourage everyone to vote and comment on this suggestion and its comments. The more engagement a request receives, the higher the likelihood of it being considered for implementation. Thank you for participating, and we are excited to work with you to make a better Sisense! Have a great day! ... View more

In browsers, usually links can be right-clicked. You get a menu including "Open in new tab" and "Copy link". Some Sisense links block this behaviour: e.g. the list of dashboards and jump-to-dashboard links. It'd be nice to get it back. To be clear: I do not want every link to open in a new tab. That would be annoying. I just want the option to do so. For example, here's a link where the right-click does work:   ... View more

Ability to sort the items of a filter by a secondary item. Currently. for days of the week, for example, they will naturally be displayed in alphabetical order. Instead of "Mon, Tue, Wed, Thu, Fri, Sat, Sun". Sisense is only capable of displaying it as "Fri, Mon, Sat, Sun, Thu, Tue, Wed". ... View more

It's not possible to create a dashboard filter using formulas. I could create a dashboard filter only with variables that are present in a data source. I am able to create a value in pivot table and then use it as widget filter, but it can't be done to other widgets that are not pivots. ... View more

When a user makes an edit to a report, they can click Publish Changes so that report with those edits are live for users to see. Our customers would like to have an undo button so that the edits made in the last push is reverted and the version prior to publishing changes is now the current version. ... View more

It would be great if we were able to setup Active Directory for an individual tenant while having SSO enabled for another tenant. This would help us differentiate between our external customer facing and internal BI. ... View more

Please make the calendar heatmap widget work with jump to dashboards.  Without it the widget is not very useful because users cannot click to see what is making up the data set for each day.  ... View more

Using the jumpToDashboard plugin, there is a feature enabled with flag "hideSharedDashboardsForNonOwner" that allow the owner of a dashboard to hide dashboards even if shared with other users. The owner is the only one who can see it. The problem of this option is that, when a dashboard is configured to be hidden, the only way the owner has to know this setting is to open the dashboard menu and check the flag status. As a result, it could happen that the owner doesn't have a clear overview of which of his dashboards are visible and which one are hidden to other users. It could be useful to show somehow to the owner, in the tile and list view, if a dashboard is hidden. One simple option is to set a value of opacity for hidden dashboard like "0.65" to distinguish them easily. Attached my implementation of this feature. It's based on 1.3.1 version of jumpToDashboard and adds this feature; it also fixes some issue I found with proxy base url set on the system (win and linux). There is a know bug in this feature (already in the base plugin version); the viewer see the real count of dashboards but then see just the dashboard that are not hidden (e.g.: 5 dashboards counted, but 3 tiles displayed). Here an example of 2 dashboards listed, one hidden and one not: 2024-10-02 - Updated attached version to fix dashboard counter when some dashboard is hidden ... View more

Sisense does not currently offer the ability to easily freeze the top row of a pivot table, similar to what most spreadsheet applications offer. Prior community questions on this topic (such as https://community.sisense.com/t5/build-analytics/freezing-the-header-row-for-a-pivot-table/td-p/3022) advise a workaround by manually disabling the Auto Height feature for the pivot table widget, then reducing the height of the pivot table until a widget-level scroll bar appears.  This solution only works for a very specific use case, and losing the ability for the widget to dynamically resize when populated with different sizes of datasets and/or when applying dashboard-level filters makes it less tenable. For example, if a widget is manually resized so that the header is visible when scrolling for 50+ rows of data, the widget will stay the same height if a filter is applied that reduces the dataset to 15 rows. We'd like to see if there is a way to easily freeze the header row of a pivot table while preserving the ability for the widget to automatically resize based on the amount of data. Ideally this would be a checkbox or other easily accessible widget-level setting. ... View more