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...
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 ...
SUMMARY:My Live Model is slow. Source data is big, but a dashboard filter picks just one item, so I think it can be fast. This feels like a common use case for a Live Model.DETAIL:My dashboard is based on a live model that queries SQL Server. The use...
In Sisense, I'm looking for a way to create a new column in a table, with percentile values of a different column.I am open to design suggestions/approach. What the best way to accomplish this.Such that: 1. Have a filter created on percentile values ...
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, I have a pivot table where there are various areas listed 1-15 but it will order it by the first number in the series ie. 1, 10, 11, 2 , 3Is there a way around this so it will read 1, 2 , 3... 10 , 11
Hi @Angelina_QBeeQ ,I want to set the rank independently for each month based on measure.Rank logic: RANK([Overall Vol],"1224",[l3_demand],[Months in contact_date])As per below sc, rank shd be 1,2,3....for Mar and similarly 1,2,3...for Feb and so on....
I'm having an issue joining two tables an suspect it's due to the integer value within the tables. In SQL, I'd join like this:SELECT top 1000 * FROM tblOrderRouteStops R WITH(NOLOCK)INNER JOIN tblOrderRouteStopsParcelAssigned PA WITH(NOLOCK)ON R.PKID...
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)
