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

Hi, I want to show in my dashboard the values of the last 12 months period. As I do not want to select the month every month manually, it should be dynamically taking always the last 12 months. So far I am using the advanced settings in the filter: { "last": { "count": 12, "offset": 0 }, "custom": true } The issue is, that my available data is not always up to date. Therefore, I want to select the last 12 months counting the offset back 2 months from the selected month in the filter. As far as I understood is that the offset counts back from the current date disregarding the filters settings. I would need something like thi: { "last": { "count": 12, "offset": 2 (counting from date selected in "sale date" filter) }, "custom": true } ... View more

For now, dimensions are displayed to the dashboard designer in the alphabetic orders of the tables / columns names. I would like the datamodel designer to have the control over sorting / grouping the dimensions. Ex : 3 tables Address Number Street City City Zip code Country Country Currently : the list of dimension will contain 3 groups: Address / City / Country The columns in each will also be sorted by alphabetic order.  Expected : the datamodel designer will choose how he want these columns to be displayed, for instance, under one single group : Address Number Street Zip code City Country     ... View more

Currently, when using the Usage Analytics EC you do not have the ability to audit for everything you need when it comes to what your users are downloading.  Right now all we can audit for is PDF, Image, and CSV.  I would like the ability to be able to audit for Excel, PPT and any download options that are made available. Management wants to know who is downloading what, but right now we can only give data for some items and only for 30 days.   I would like to be able to have a larger selection of items to audit that utilize a customizable timeframe for how long to retain history for a select data point. If we are to audit for a pattern of downloads 30 days does not meet our needs.  Currently, if we want to audit for more than 30 days, we would need to get the data in a format that can then be loaded into an external DB that can then be reincorporated back into an EC for reporting.  This seems to be a waste of time and resources when this should be able to happen in the source system. ... View more

While there are some workarounds... * create a user on behalf of the recipient  * create a user that has the email address of an email distribution list * create a forwarding rule in your email  ...many of our users would like to schedule some dashboards to be sent via email with support for a pdf attachment to people who are not and will never be Sisense users in their system. Our application (we're OEM) supports this for reports in the application, and there's an expectation that dashboard emailing would exhibit the same support. As it is clients have to create an application user per external recipient, log in as the user and SSO to Sisense to the recipient available as a dashboard subscriber. In some cases, work can be reduced with an application user that represents an email distribution group instead of an account per user, but even that requires a lot of maintenance from dashboard to dashboard as their recipient lists vary so much. The best work around is using forwarding rules in users' email clients so that when they receive the dashboard subscription, it's automatically forwarded to those external recipients. However, the forwarding process is then tied to a specific user's email account which introduces risk should change need making when they're not available, or the organization.   If the variability of filters and data security is the concern, then perhaps sending in the context of the owner copy is a step toward an answer without meeting the more robust needs of defining different data security for different non-user recipients of the same dashboard.  ... View more

Sisense ElastiCubes are the biggest consumer of our snowflake credits because we have to build our cubes every 30 mins to keep data fresh in Sisense. It would be useful to have time of the day level control on scheduling the build. Like Build daily at an interval only between the hours of x and y or other cron based scheduling. cron scheduling would be great since it allows us to set build windows, not build as frequently on weekends, etc. This would immensely help with cost saving. How quickly is it possible to have such a feature? ... View more

At Splash we have been using report manager for email delivery of reports to external partners. These are outside partners with minimum technical skills and want CSV reports delivered with data. We ended up solving his need using report manager plugin. There are several issues with report manager plugin that we have experienced in last few months and I wanted to understand if there is a different more stable and feature rich option for us. List of issues I am tracking No way for Sisense users to see who is on the email list, other than admins. Only Admins see the report manager tab. I would like users to manage or be able to review who is getting the reports. Email delivery is limited, who gets a report to answer I need to review each job manually. Error notification is never sent to the default email or the email provided in the job setup often due to server failure Intermittent failures with report delivery due to limitation on delivery efficiency or create some retry logic, to queue emails for retry Self serve ability, without buying more licenses how do we enable external partners to have a robust reporting platform where they can self serve. Example when they login they have access to a suite of reports that are canned reports ready to download each day. No SFTP delivery mechanism All report manager jobs appear in a list view, it is very cumbersome to manage I would like to understand how else can I leverage Sisense to build feature rich reporting capability. Let me know if you have a moment to connect. We have our sync coming up June 1st, but we can also connect prior to that. (edited)  ... View more

Hi Team,  When we import a lot of files (CSV for example), we have to select each file one by one. Could it be possible to select a lot of files with one click ?  Best    ... 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

Jump To Dashboard add-in It lists dashboards with the _drill_ prefix. It lists only dashboards using the same datasource. I have a drill-down dashboard that uses two datasources: one that matches my parent dashboard, and one that shows more granular information. I'd like this drill-down dashboard to appear on the JTD list. I think the JTD list should show any dashboards that share at least one datasource with the parent. ... View more

There is no option to modify table columns width in notebook results. This means that if I query a dataset of accessed URLs, where the end of the line matters most I cannot see anything beyond the domain name.  Optional workarounds are hovering row by row or exporting all results to CSV. Both are cumbersome. Modifying columns width seems to be a common notebook functionality in similar solutions, so it would be nice if Sisense could support this as well.  ... View more

In my datamodel, I want to delete 10 tables with names ending with "MySpecialSuffix". So, I go to datamodel list view and search for "MySpecialSuffix". I click delete on the first table. But then it loses my filter. So I have to re-type my filter for each table I want to delete. ... View more

The Data Security tab's group/user assignment window currently has a max search limit of 20 results.   The "results" search limit should be configurable because we have approx. 50 groups that need to be assigned, & it is very difficult to find/assign/manage all of the groups when the search window does not return all of the appropriate results. ... View more

See here: https://community.sisense.com/t5/technical-troubleshooting/refresh-schema-error/m-p/23594#M195 Refresh Schema fails when you have tables from two different schemas. ... View more

When we send more than one Combined Excel Report while using a dashboard having different filters on it. Names of those combined Excel sheet we get from them is same as they were using same dashboard for creating a report, which is difficult to identify when downloaded simultaneously. Can we base the name of excel sheet on Report Name itself rather than dashboard name as it will be more convenient. Thanks, Animesh Gupta ... View more

When generating the WAT token, we need to pass the Sisense user ID in the 'sub' parameter. To obtain the user ID, we must repeatedly call the Sisense APIs, which can be inefficient. It would be beneficial if we could directly include the Sisense username or email in the 'sub' parameter, thereby avoiding unnecessary API calls to retrieve the Sisense user ID. Reference Document - https://docs.sisense.com/main/SisenseLinux/using-web-access-token.htm#StructuredTokensByValue ... View more

Create a pivot widget of RSUM( [Total Quantity] ) over time (rows) and break by (columns) age range. Scanning down each column, over rows, the numbers only increase. Now change it to a line widget. The break by defaults from an RSUM within columns in the pivot to an RSUM within rows in the line chart. This is the same as not having an RSUM and doing a stacked area. Our clients expect the line chart the results from changing the pivot to a line chart, to reflect the same output as the source pivot. As it stands now, they are surprised to see negative curvature in their RSUM, think something is broken, and open a support ticket. The default behavior should be to render Break by Columns instead of Rows. As an aside, I'm having trouble coming up with, and would be interested in hearing, use cases for charts with break by set to rows.  ... View more

The content/formatting/text contained in the various Sisense-generated/automated emails is currently static. I went through a long dialog with support and determined that  it's not customizable by customers. I would like it if we could modify these emails, and I'd especially like to have access to dynamic variables that we can insert in the email body (or subject). User's first name or last name were specific for my use case, but having access to a variety of variable could be helpful. ... View more

"Analyse SQL" helped me understand some widget measure formulas and filters. I wanted to then experiment with it in Sisense's "SQL Runner", but that didn't work: the query is too large, and it uses strange names for tables and columns (aFactXwAaSaleXwAaorders for the table Fact_Sale_orders, and aCountryCode for the CountryCode column). It'd be helpful if you modified SQL Runner and/or Analyse SQL so that I can paste results, edit, and run them. The purpose to help me investigate questions such as "How does this filter affect my measure?" or "What does my colleague's horribly convoluted measure formula mean, why is it wrong, and how might I fix it?" or "Is my widget doing unexpected joins?". I'd like this as a tool for myself and to recommend to colleagues. ... View more