How to login Sisense with admin ID after onboarded to Azure?
During the installation and minimal 2 IDs will be created under Administrator group. However, after onboarded to Azure and Admin has no way to login using the 2 IDs since these 2 IDs are not exist in Azure. Any dedicated login page available in Sisense to enable Admin login?2.2KViews0likes10CommentsHow to identify and download logs from the Sisense server
To identify and download ec-bld logs in Sisense, first, log into the Sisense server and run kubectl -n sisense get pods | grep bld during the cube build to find the relevant pod name. Once the build is complete, locate the log file in /var/log/sisense/sisense/ (for single-node) or use kubectl cp commands to retrieve logs from fluentd or management pods (for multi-node). Finally, access the Admin File Manager > Data folder to download logs and clean up local copies if needed.2.1KViews1like0CommentsBlox Search Field usage for multiple columns
Hi, I'm creating a dashboard with a table with multiple columns containing text. I've created individual filters for the columns. I tried adding the Blox Search Field widget but it is only allowing me to search one column. I created multiple buttons to search and clear each column. Is it possible to create one button that searches all buttons? Here is an image of the Search Field widget with my current implementation:Solved2KViews0likes8CommentsCalculate Days Until Date+3 Years
Hello, I am trying to calculate how many days until a certain date, provided date+3 years within a formula. All I want to do, for example, is show how many days it is until expiration, given expiration is 3 years after the provided date, but I can't quite figure out how to do this. I know Sisense and date functions are like oil and water for some reason but this isn't that difficult of a calculation. I should also mention, editing the underlying data source or elasticube (live model in this case) is not (nor should it have to be with a BI tool) an option. Scripting would be a last resort but not off the table. Any help would be greatly appreciated! Logically it would be something like this, but of course this doesn't work (not worried about leap years so 365*3=1095 to simplify) DDiff(NOW(),[MyDate]+1095) A very simple Excel formula for reference as well: DATEDIF(TODAY(),EDATE(A2,36),"d")Solved1.6KViews0likes3CommentsResolving installation error for Sisense - sisense-installer/bin/activate: no such file or directory
This article provides basic understanding of a common error encountered during the installation of Sisense on Linux systems. Verifying Python packages exist ... ./sisense.sh: line 240: sisense-installer/bin/activate: No such file or directory Error occurred during generic_pre_install section Exiting Installation ...1.5KViews0likes0CommentsHow to record a .har file and identify if specific requests are present in logs
To record a .har file in Chrome, open Developer Tools > Network tab, enable recording, clear logs, and reproduce the issue before exporting the file. To check for jaql requests, filter by "jaql" in the Network tab and inspect the request status and X-Request-ID. For on-premise Sisense, use cat /var/log/sisense/sisense/<log_file_name> | grep <X-Request-ID> (single-node) or kubectl exec (multi-node) to search logs for the request.1.5KViews1like0CommentsRetrieving total count and paginating large datasets with Compose SDK
I'm currently working on implementing a custom table to handle a large dataset in Sisense, and I'm encountering some performance challenges related to pagination. Here's the scenario I'm facing: Requirements: Retrieve the total number of records that match a filter condition (to get the total count for display and pagination). Efficiently paginate the results by fetching only the records for the current page, based on page size (e.g., 10, 25, 50 records per page), without retrieving all records at once. The Challenge: While I can use offset and count to paginate the records and fetch only the records for the current page, I don't have a way to determine the total number of records that match the filter condition without retrieving all of the records first. For large datasets, fetching the entire dataset before pagination is causing performance issues, since Sisense retrieves all the records matching the filter condition before applying pagination, which is inefficient. What I'm Looking For: Is there a way to retrieve the total count of records matching the filter condition without fetching the full dataset? How can I fetch only the records for the current page (using offset and count), while still being able to display the total number of matching records? Does anyone has experience implementing efficient pagination in Sisense for large datasets or can share any best practices, examples, or solutions?Solved1.5KViews0likes4CommentsHow to Troubleshoot UI Issues Using DevTools (HAR File & Console Logs)
If a webpage, dashboard, or widget isn't loading properly, encounters errors during exporting, importing, editing, or opening, or if buttons are unresponsive and error messages appear, you can use Developer Tools (DevTools) in your browser to diagnose the issue. This guide will show you how to: - Check the Network tab for failed requests. - Use the Preview and Response tabs to see details of errors. - Check the Console tab for other issues. - Save a HAR file to share with support.1.5KViews1like0CommentsHow to check specific pods CPU/memory consumption in Grafana
To check pod CPU and memory usage in Grafana, go to Dashboards > All Pods per Namespace, select sisense, adjust the time frame, and filter by pod name. Ensure CPU and memory graphs are visible in screenshots, taking separate ones for different pod types.1.4KViews2likes0CommentsUse of 'beforeRender' inside Table?
Hi, I'm using the CSDK on Angular 18 to run my micro-analytics components, I'm trying to replicate a table that I have on a dashboard using the Table component, but I need to make some customization to the Table itself like rendering some columns like an HTML to load images. Checking the docs I don't see any documentation about the use of "beforeRender" but inside the Chart component that allows the use of the 'table' type, it allows it, I wonder if is possible to use it or there is an alternative for my use case?Solved1.3KViews0likes3Comments