Current Functionality: The fiscal start year for an Elasticube can be set independently. Ex. in the elasticube fiscal year start is set as October. When a dashboard is connected to the Elasticube, the dates correspond to the Fiscal Year (FY) starting October. However, perspectives linked to this Elasticube default to a January fiscal year start. And there is no way to change the fiscal start year at the perspective level. Desired Functionality: When a dashboard is connected to the perspective, the dates should ideally correspond to the Fiscal Year (FY) in alignment with the parent Elasticube's settings or there should be an option to configure the fiscal start year exclusively for the perspective. Importance: This enhancement is significant as perspectives are being explored to enhance data and analytics implementations using Sisense.    ... View more

It would very helpful to be able to see the columns of a table in the Table Query section of the MySQL query build. Currently it just list the tables and you have to open another table then preview the table and scroll sideways to see the available column. You could create this in a tree view like SQL Sever does. This would help query writers by being able to see what columns belong to the tables, I included what SQL Server does for reference.   ... View more

We have reports/dashboards based on a large underlying table. Thus, when a user tries to run a dashboard for a long date range which would result in many rows being processed, the dashboard may take time to load. It will be helpful, if there is a way to get the size of result set that will be executed using the query plan. Using that estimated size, we can compare the size to a threshold size defined for the dashboard and if the estimated size is greater than the threshold, the user can get a popup message which will indicate the result size being too large will impact the dashboard load time. Thus, in this case, the user can alter the filters to reduce the result size if it wants the results sooner or else will be expecting the results to take time due to its size. ... View more

Request: Provide a standard way for supporting multi-currency support. Use Case: Enable end users to create widget and dashboards where they can switch between multiple currencies. Background: There are various posts on how to implement multi-currency by adding an exchange rate dimension and using a formula similar to Local Amount = (Amount Field) * (Exchange Rate) and using a filter to select the desired currency (E.g. USD, EUR, GBP). This process works well when you have dashboard designers, but it doesn't work well if you want end users to create their own reports.  If they do things wrong the Amount may be multiplied by the number of currencies supported. They are required to enter a formula instead of simply selecting a field to report. Recommended Solution: Add ability to add Formula fields to the data Model.  The data designer would create a standard field with the formula.  The formula would be evaluated within the dashboard not during cube build.  Note: there are probably other uses cases for data model defined Formulas that are evaluated within the dashboard. Add ability for automatically adding the Currency filter when the data source is used. ... View more

In Sisense, under the Data tab, there’s a queries tool that displays information such as a cube’s title, size, and status. However, creating a query does not update the page URL, so you cannot use your browser’s back and forward buttons to navigate to it.   Omer London BigPanda ... 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

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 creating a new table in an Elasticube, the area to write code into takes up a fraction of the screen space. Please make the pop-up to write code for tables stretch across the whole screen so users can see more lines of code at once. Or make the pop-up window adjustable so we can move it to be as big as we like.  ... View more