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...
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 ...
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,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, 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 algorit...
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. ...
Data model is scheduled to build daily. However, without indicating an error, it fails to do so. Manual build works and updates data as it should. Please review with me.
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...
I have 2 type of data tables: assignments and completions. I want to perform the following formula.(# assigned_completions + # unassigned_completions) / (# assignments + # unassigned_completions)My elasticube has assignments and completions as differ...
I have a count of unique values and use (value,ALL(days_in_date)) function but is still being affected by my blox date filter. I need a way to calculate an all time formula for one column that is not affected by the date filter. Any ideas?This is wha...
Can anyone direct me to a guide on what I need to do to import Active Directory data within Sisense Cloud?The only documentation I can find is here: https://docs.sisense.com/main/SisenseLinux/connecting-to-microsoft-active-directory.htmHowever that t...
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 builds...
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?
