Migrate 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.9KViews0likes5CommentsGeneric 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.4KViews0likes9CommentsSetting up SAML 2.0 for a specific tenant
I have two tenants (system tenant and a new one created). I believe that under: Admin > Security & Access > Single Sign On, the General configuration applies only for the system tenant (default one), however, I need to set up a different SAML 2.0 data (such as Remote Login URL, Remote Logout URL) only for the new tenant, unfortunately, I see no information in Sisense documentation, neither in any version (0.9, 1.0, 2.0) of the REST API endpoints.Solved1.7KViews0likes7CommentsRemoved Dashboards still show in user's list (or vice versa: newly shared dashboards not appearing)
Hello! We've noticed multiple incidents recently where, when the owner of a dashboard removes a user from the dashboard, or they delete the dashboard entirely, that user will still see the dashboard listed in their sidebar. If they hover-over the dashboard, it will display the normal pop-up showing info about the dashboard (who the owner is, when it was last published, etc). However, if they attempt to click on the dashboard to view it, they'll be met with a 403 error screen that says "Sorry...you don't have permission to access this Dashboard. Please request access from [the dashboard owner]." Also worth noting, not sure if relevant or not: if the user tries to click on the kebab icon (⋮) next to the name of the affected dashboard, nothing happens (i.e. it doesn't pop-up the options menu like normal). For the user in question, as far as we can tell, there's absolutely nothing they can do to fix this on their own. There doesn't appear to be any way to resolve this error or remove the dashboard from their list for good. This is affecting multiple users, not just one or two specific people. I'm experiencing it myself. I've tried clearing my cookies/site settings, as well as logging in while in Incognito/Private mode or using a different browser (to ensure it's not an issue with browser caching). None of these work, I still see the ghost dashboards and cannot remove them myself. The only workaround we've found is to ask the Dashboard Owner to re-share the dashboard with that user and then remove them a second time. This usually works but occasionally we need to repeat this a few more times before it finally "takes". Also, this doesn't help for when the dashboard was DELETED, since now there's nothing to re-share. A somewhat similar issue we've noticed is when initially sharing a dashboard with a user for the first time. We've gotten many complaint from people who received an email notification saying "so-and-so has shared the 'XYZ' dashboard with you", but when they login to view it, they cannot find it anywhere in their sidebar (even after looking in all folders or using the search at the top of the list). When this happens, the only workaround we've found is for the Dashboard Owner to remove the user in question and then immediately re-add them a second time. Like with the other issue, this usually fixes the problem (they'll start seeing the dashboard for real) but occasionally we need to repeat this a few times before it 'takes'. Any thoughts or suggestions about what might be going on here? How can we fix this so the workarounds I described aren't necessary? An important note: we don't use Sisense directly, but instead through a third-party application called TeamConnect where our dashboards are displayed via an iFrame. It's all powered by Sisense behind the scenes, but unfortunately it's an older Windows-based version (specifically: v8.2.0.10219), so there may be certain features that aren't available to us. Also, we do not have access to any of the backend/admin stuff for our e-Cube. If resolving this issue would require someone to log into that admin area, please let us know so we can work with the TC Support folks to get that taken care of. However, I'd still like to see the details myself; even if I can't go in and make the changes on my own, I'd like to have a better understanding of what the vendor will be doing on our behalf 🙂1.6KViews1like4CommentsTenants migration
I'm a new user using the Sisense platform as a Developer. I'm planning to create two tenants for two apps (second app will be ready in the future) in one server, however, before implementing tenants, I need to know if it is possible to migrate users from one tenant to another I've spent time reading the Sisense documentation, nevertheless, it is not clear if it is possible to achive such thing. Any help would be much appreciated!Solved1.5KViews0likes3CommentsCan we edit the data without using code before pushing it to the Elasticube?
Hi guys! May I seek for your help to see, before we push the data into Elasticube, is there anyway we can edit the data without using code (just like remove column/row, add fields like the way we use Excel/Spreadsheet)? For example: I have a dataset of csv file and it contains many junk data, many columns/rows are blank and null and I want to delete them before pushing it to Elasticube. Is there any workspace/function on Sisense that allow me to do that without any coding/script needed (I mean for no code user)? Thank you a lot~Solved1.4KViews0likes4CommentsAdding custom messages to the standard Sisense Login Page?
Hello, We are hoping to be able to add messages to users on our standard Sisense Login Page. Anything from reminding people about a new feature, to telling them about all the services our company offers (we host on behalf of other customers, but mostly use the out of the box Sisense application). Has anyone done something like this before (in a way that is supported by Sisense)? Thanks, ChrisSolved1.3KViews0likes2Comments