Build monitor
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. Best8KViews2likes3CommentsTransfer ownership of objects (data models, dashboards)
Would like an easy way to transfer ownership of objects to someone else. Or for a super-user admin to be able to "take ownership" of a data model or dashboard. Will make it easier to deal with when someone leaves the company and they owned things in Sisense.2.8KViews9likes7CommentsMigrate users from one tenant to another
I want to migrate users from one tenant to another; I exported the first tenant users as well as their related data, then I deleted the users so I can recreate those users in the second tenant, I tried to use the REST API tool to add a new user, however, I'm getting an "Error: response status is 422" message as seen in the images below: This is the payload I'm using to recreate the user: [ { "_id": "665643c6367dfe002dfa9e7f", "roleId": "5fbc47b1ded309103e86c139", "userName": "alejandro_gran", "firstName": "ALEJANDRO", "lastName": "GRAN", "email": "[email protected]", "groups": [ "5fc300cf435a06002d5c8c25", "5fc30117be402c002c2c9955", "628bfc96c760f7002cd49da8", "6137da88e5a7ed001a54935f" ], "active": true, "pendingExpiration": "2024-06-04T20:51:18.614Z", "created": "2024-05-28T20:51:18.614Z", "lastUpdated": "2024-05-28T21:06:24.121Z", "lastLogin": "2024-05-28T21:06:24.121Z", "activationExpires": 1717534278614, "tenantId": "null", "manifest": { "tenants": { "crossTenant": { "allowed": false } } }, "internalGroups": [ "62bb52c0a3df55001b5cbeff" ], "preferences": {}, "lastActivity": "2024-05-28T21:06:24.055Z", "uiSettings": { "ecmNext": { "dataPage": { "hideListViewGuider": true }, "guidersShown": { "addData": true, "ecActions": true, "dashboards": true } } } } ]Solved2.8KViews0likes5CommentsAdd robust folder management
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.2.4KViews34likes6CommentsGeneric JDBC ClickHouse live model with custom dialect
Hello, I am using a Generic JDBC driver to query our ClickHouse cluster. It works quite well on ElasticCube, except for handling date types and date functions. Therefore, I would like to use a live model with a custom dialect. However, I haven't found any documentation about that. I noticed that the analytical engine is enabled for my connector and that it's based on Apache Calcite. Additionally, I saw that there is a custom dialect for ClickHouse in the Apache Calcite project. https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/dialect/ClickHouseSqlDialect.java I tried to download the Java file for ClickHouse dialect and upload it, but it doesn't seem to work as expected. Although no errors appeared in the UI, I noticed a 400 error in the network with the following message: "Failed to update dialect with response = ServiceResponse(status=INSTALL_DIALECT_FAILED, value=null, error=Failed to validate Dialect for connector GenericJDBC_clickhouse, statusCode=0), for connector GenericJDBC_clickhouse." Could you help me figure it out? ThanksSolved2.3KViews0likes9CommentsEasy way to change Sisense server IP address
When a Sisense server's IP address changes, you have to reinstall Sisense. I want a script or button that changes all the relevant settings. We need it because we're planning changes to our network. There are other reasons that an IP address might need to change, e.g. I might restore from a system image backup to a different location, or I might start a new server and, after testing, want to redirect my old server's IP address to it. We'll do it by reinstalling, but that feels like more work than it should be.2.2KViews5likes7CommentsGlobal ElastiCube Builds Schedule Report
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).2.2KViews15likes7CommentsMake user parameters more dynamic
**Please note this idea was migrated to the Product Feedback Forum from older submission areas** User parameters must be set and cannot be used for dynamic customizations. When setting up data models, these parameters cannot be included as part of a filter in the underlying query. We would like a way to reference a global or system variable that includes the username of the currently logged in user.2.2KViews8likes3CommentsAPI to retrieve Sessions Table details
**Please note this idea was migrated to the Product Feedback Forum from older submission areas** Sisense doesn’t have an API to get data from the Sessions Table. This data is available in the UI only. We would like to be able to use this data in a custom application that we have built. We’d like to see an API that will allow us to get the Session Table details.1.9KViews6likes3CommentsEmail Digest for end users
It would be cool if our end users could receive a Digest Email that is sent out on a frequent basis from Sisense. This email would be most relevant if it was based on the groups a user is assigned to already. This would ensure relevant communication, as well as ensure there is control over the reports included in the digest that the user would already have access to them. We would not want the digest email to included recommended reports the user doesn't already have access to. If it was a feature the Admin could turn on/off at the group level that would be our preference. The feature would allow the Admin to select how often the digest went out (weekly, monthly, etc). The feature would allow the Admin to select what content was included: For example: Changes, Top Used/Popular in the Users Groups (i.e. Org), and then for us I think Newly Published Reports would be ideal. This would allow an organization to choose whether every time a new dashboard is released the user is notified, for us we would prefer a section in the digest that has these 3 dashboards were released to your group(s). Other BI tools do already offer this-- Attached is an example of the Power BI digest, as reference. Thanks!1.9KViews2likes6Comments