Silent Build Problems
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.
Forum Posts
All days in date not working
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...
2 events tied together by date filter
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...
Resolved! Set Conditional Formatting of cell Based on a Separate Measure
Hi @Angelina_QBeeQ ,I want to set color(red & green) of Rank cell based on Overall Vol measure.if Overall Vol>2000 then Rank cell will be Red else Green.Logic of Overall Vol is Count(call)
HTTP Error REST_API Jupyter Notebook
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...
refresh the schema to a table through the api
Is it possible to refresh the schema to a table through the api?
dashboard usage elastic model
I didn't found dashboard usage elastic model in my sisense how should i get that
Associate multiple date columns in a fact table to a date dimension table
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...
Formula to Return SUM similar to a SQL IN Statement in a GRAND TOTAL
Scenario: My organization has ACCOUNT that have multiple balances associated with them, and each account has a TYPE These accounts tie into a PORTFOLIO We have a Pivot that is to return all PORTFOLIOS and the SUMs of these ACCOUNTS. But we would lik...
Error when using DDiff function
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...
Resolved! How to model changing Membership Types when calculating Historical Data
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...
Refresh Elastic Cube Programmatically
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
To avoid duplicate exported data
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...
Copying a dashboard and its elasticube /datasets from one sisense server to another via rest api
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-...
How to migrate all the content of one dashboard to another already created dashboard?
Hi,We are working on integrating Sisense within our service platform and trying to achieve the following workflow:We have two dashboards created, dashboard A and dashboard B, both pointing to the same data source (Elasticube)Through the Sisense REST ...
