Hi,our team enabled shared formulas in DEV and PROD. We create the dashboards in DEV and migrated to PROD. When migrating the PROD we are getting this error. If I edit the widget and go the 'values' section, all the values are empty so I need to re-a...
Assuming that you have a properly-designed dimensional cube structure, with no many-to-many problems... in your experience, what are the biggest factors that influence total cube size? (And therefore Sisense system performance impact, memory utiliz...
Hello,I need some help around converting the date field column.I have a Customer response table coming from Redshift. The date time field is originally stored in UTC format.But when pulling it into Sisense, it is displaying in local timezone.I wanted...
in a typical corporate data warehouse scenario, we'd have a wide range of facts covering different areas of the business. They in turn would likely be set up as different Elasticubes/models that have a small number of facts in each.However, it would...
There are a couple of dimensional modeling patterns that you see out there, that I'm wondering if Sisense supports correctly.1. Snowflaking - (I don't mean Snowflake the database) - having rollup, lower-grain dimensions hung off of other more detaile...
Hello,I need clarity on the lowest Sisense role needed to 'CREATE' new notebooks. Not just view, edit and own.The user guide (https://docs.sisense.com/main/SisenseLinux/sisense-user-roles.htm) says 'Data Designers' can, but someone has a hunch that i...
Hi all, I'm new to Sisense but not new to BI. I'm trying to put together some auditing on cube builds, ie. which cube, when, success or fail, build time. We running version 20.22.9 in Windows. I've found the logs but can't anything specific to bui...
Hi,As an OEM we give our customers the possibility to use designer-accounts to create their own reports. The difficulty we have been struggling with is how to simply explain our complex datamodel. We have been working on a solution that we want to sh...
I have figured out how to get list of custom tables in Sisense by connecting to MongoDB server and prismWebDB database. But then I run into some issues and would like to get guidance from the Community:I get list of custom tables from DatasetTables t...
I'm looking for help with using Sisense and Jupyter Notebook. Here's what I need to do:Load CSV data into a Sisense Elasticube table (Table A). (this I know how to do)Transfer data from Table A into a pandas dataframe for processing. How?I found a re...
Hi Team,I have calculated the manufacture share on pivot table at two levels ( Retailer and Category) using the formula:dupcount([custom manufacturer_sort])/(dupcount([custom manufacturer_sort]),all([custom manufacturer_sort]))Now, the default grand ...
I clicked "Duplicate As Live". I got an error "Live models can have only one dataset".I made sure I only have one dataset (see left side of picture below). So why am I getting the error?I did refresh schema on all tables, and made sure they all point...
Hi, We often need to have the metadata report about all Elasticubes and their contents. To cover this gap, we have developed an ElastiCube that is based on the REST API v2.0, which creates a data model for this purpose: There is a custom code algori...
I'm getting an odd bug in Fusion Pivot tables where columns will not sort (except first column which /can/ sort). The first column (a list of the names of various schools) will sort just fine ASC and DESC. For any other column sorting has no effect....
I have a data cube that is corrupt and I’d like to delete it.When I open it I get the following:and when I try to delete it, I get the following: I can't import over it: Any Ideas on removing it?
