Coalesce in Query dramatically slows Elasticube build.
I have a coalesce in one my joins in my query and it is dramatically slowing the elasticube build. Anyone else experience? If so, do you have a better solution?
Forum Posts
Resolved! Web site demo request broken
Something seems seriously wrong on sisense.com. We are trying to request a demo but that functionality will not work. We also can't get the "Contact Us" page to work. We have tried on different browsers and I even attempted it on a personal machin...
Break by month not in chronological order (displaying 01/2025 before 12/2024)
Hi, I have some charts where the Break By is a date field which is displayed as MM/YYYY, and I have the charts filtered to show the Last 2 Months. Now that we're into a new year I've realized that the charts are displaying by numeric month order and ...
Best Practices for Optimizing Sisense Dashboards for Large Datasets
Hi everyone,I’m currently working on optimizing some Sisense dashboards that are handling large datasets, and I’d love to get some insights from the community on best practices.We’re pulling in millions of records, and while performance is decent, I’...
Resolved! New tabber implementation - multiple tabbers
I noticed new tabber implementation with UI controls. Great, I never liked scritping with widget IDs.There seems to be major flaw though. Consider this scenario: I have 2 tabbers on dashboard, one should only affect widgets a,b and c and 2nd should o...
Use dashboard API to get data in python dataframe
I have a widget which displays users with points and I want to fetch top 10 users from that widget.Also I need to select current month "01/2025" from the filter.Let me know how this can be done But I'm getting weired error.Please help! I'm an admin s...
Resolved! Linux Install Errors when /opt and /opt/sisense are both separate filesystems
I have found a bug in the Linux installer when both /opt and /opt/sisense are separate filesystems. The installer will give an error like ""Sisense /opt minimum requierment disk size: 50GB", even if the /opt/sisense directory is greater than the min...
Resolved! Sisense Intelligence - struggling with requests
I am having trouble with the setup of Sisense intelligence. I keep getting the same message when sending requests so not sure where I am missing anything. I set it up to use my OpenAI account and hope someone can confirm if my parameters are correct...
Resolved! Does Sisense free up RAM from crashed queries and builds?
I've been looking at RAM use. While experimenting, I sometimes build bad widgets or cubes that use lots of RAM and then fail with the "abnormal memory consumption" message. That's fine, but I noticed after the RAM use climbs up, it remains high. Afte...
an error occurred while executing request to connector: Thrift config is not defined
We recently moved this our Sisense server to a new node and are now getting this error connecting to a SQL Database in our reports. "an error occurred while executing request to connector: Thrift config is not defined"
Resolved! Query Plan Analyzer - is it reliable?
Looks to me like the Query Plan Analyzer incorrectly labels some joins as "many" when they should be "one". Also, it seems to analyze the SQL constructed by Sisense, not the database's query plan. Is that correct, or am I missing something? (My goal ...
BloX SJSON scrambled when using git?
I have a dashboard with several BloX widgets. I noticed after using the Git Interface to version control the JSON in the bLox widget gets scrambled. The widgets still work, but they become near-impossible to edit after the fact. Are there any know re...
SiSense Pivot table column header misalignment bug on refresh
reference bug: https://community.sisense.com/t5/build-analytics/pivot-table-widget-column-headers-and-column-data-out-of/m-p/2751Hello, i am experiencing something similar where the pivot table refreshes on misalignment of column headers, this bug on...
Xero JDBC Connection issue
Hi, Our team has an issue with Xero integration using JDBC driver. Unfortunately, it seems like the connections for other services works but not for Xero. Let me give you as many details as I can.First, we generate a connection string on our side to ...
Widget PNGs are blurry when downloaded
I suspect this may be a user-specific problem and not something system wide. We've only had one user complaing of the problem.When she uses the "Download Image" functionality from Sisense 2024.1, the resolution of the PNG is fuzzy/blurry, as if the r...
