ElastiCube error. Error details: BE#184269 Failed to build custom table: staff_bw. SQL: MALException:run_default_logic_inst_prll failed:failed to apply parallel default logic operation: 'CMD_LT_int_prll'. This is whenever I add my case statement in m...
Suppose I have data organized in a pivot (widget). where within the pivot table, each rows represent a team member, e.g. (jack, jon, doe etc). The team members are part of teams, where 'team name' is a column in the same pivot (widget) I'd like to ge...
Hi! I have one metric here that is using the PREV() function to get data from 4 weeks ago. Hence, the date rows go all the way to 4 weeks in the future here. I have included a widget filter called current_date_flag, which is basically a row in my EC ...
Hi - We have a requirement to access Sisense User Id in the Live model SQL Queries. Do we have any way we can access the Sisense User Id/ Group via some variables?
Core issue: Dashboard filter is showing selectable categories which have no values in the table used by the dashboard. Example: I have a dashboard which presents data from the Charges (fact) table below. There is no reference to the Inventory table ...
I am working on importing a flat file (CSV) with a large number of columns (~350) into an elasticube. When I go to build the cube, even when only using a small number of sample rows, I get an error that says "Memory allocation has failed for <column ...
Hi Sisense community, My goal here is to calculate the total number of subscriptions churned between the current week and the last 4 weeks. However, I am getting an error that says there is an issue querying the data model - would anyone be able to ...
The Google Adwords native connector is no longer supported because they use Google APIs that are no longer supported by Google.New installations from 2022.5 and up will no longer contain the Google Adwords native connector. Note: The CDATA table/colu...
Hi all, I am creating a pivot table widget in Sisense and the values are all showing up as 0. I double-checked the widget JAQL and they're all using the same table so that shouldn't be the issue. I also checked the Sisense analytics for the table and...
I have the following pivot: Why does the RSUM show a value of $0 on 4/3 instead of (92+428+0)? Thanks! -Carter
I am trying to figure out is there a way to grant View only Access on the Elasticubes to Designers/Contributor Role so that they can view the Model while developing the reports without modifying the underlying model.I tried to set via RestAPI but I a...
I am using Generic JDBC connector to import data from our MongoDB.For certain requirements, I want to only import data from the past 7 days wrt the current date using the timestamp field present in the data.I have tried a bunch of regular SQL functio...
Hi,I am trying to create two boolean Custom Columns in my DimDate table to flag data in the current week, and data in the same week, previous year. This type of flag is easy to create for a monthly resolution, but weeks are tricky because they can s...
Hi Sisense Community!! Please reference the attached workbook that I drafted in Excel. I am trying to draft a daily view by week, of each employee's time worked. This screenshot shows an example of actual hours worked by day by employee. I am tryin...
Im looking to use the answer from one calculation in another calculation on a separate widget with different filter set up. This is my first calculation, it counts how many sales we have prior to drafting for each model and divides by the total numbe...
