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?
I didn't found dashboard usage elastic model in my sisense how should i get that
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 ...
For the problem of needing to associate multiple date columns in a fact table to a date dimension table, I have always taken the approach of aliasing the date column in the dimension table with a new column having a descriptive column name for associ...
I am trying to add a column to my report using the DDiff formula but getting the following error (also attached): Error querying your data modelBE#208517 Internal Analytical Engine Error: org.antlr.v4.runtime.misc.ParseCancellationException My fromul...
I have a user table with a property MembershipType. I also have a second table with documentations that our staff are filling for each user over time The common key here is "username". I need to create a breakdown of # of documents filled per members...
Hi, I am using REST_API from the custom code section and want to query my elasticube but i am getting a below error:{'error': {'status': 401, 'httpMessage': 'Unauthorized'}}I am using the below query:logical_sql_res = sisense_conn.get_logical_sql(que...
After elastic cube built, I need to refresh the cubes based on the flag exists in Database.I created and build the elastic cube and now I want to refresh this cubes , if column value in give database in Y. instead of defining the interval
Hi Team,Iam trying to find a solution, we have a dashabord with pivot widget and a blox button to export the widget to xml.We have a requirement, where we should hide/not to display already downloaded rows, each row will have a uiqueid.Please suggest...
Hi, I am trying to export and import dashboards and their elasticubes and datasets from one sisense server to another via sisense rest api but I can't seem to find anything to help me with this. I have tried to use data model api (/api/v2/datamodel-e...
