Build Analytics
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Resolved! Using Coalesce with Lookup in a custom column

I need to create a custom column on one of my tables. This column will be a LOOKUP from another table. However, if the current row has no match in the remote table, I want to use the value from the current match column. Here is what I am attempting t...

CDavidOrr by 9 - Travel Pro
  • 1782 Views
  • 3 replies
  • 0 kudos

LAG/LEAD in Sisense Data Modeling

Hello all, I want to know whether there's a possible alternate for Lag and Lead functions in Sisense. I want to design a table where the row values are to be calculated based on the previous row values. The example of the model I want create is attac...

adityak by 7 - Data Storage
  • 934 Views
  • 1 replies
  • 0 kudos

Links in Pivot Table

Hello, I am trying to create a column that links to our gift pages on our crm. The problem is when it goes to the url, it has the donor data at the top from the last viewed donor, instead of the donor data of the gift. Our solution is first to open t...

Resolved! Pulling Sisense user data into an elasticube

Is there an easy way to pull some of the user data that's stored in Sisense into an elasticube? Specifically what I'm trying to do is pull a table of user IDs and names for all of our users with Sisense accounts and use this data in a dashboard. I ca...

mattmca by 9 - Travel Pro
  • 1160 Views
  • 2 replies
  • 0 kudos

Sisense Data Models Data Dictionary

Sisense documentation lists Data Dictionary as one of the product features. Documentation for that is shown here: Creating Data Dictionaries. However, this feature only supports the creation of table and column description information. This is helpfu...

Silutions_0-1660937843078.png

Building Cube - Long Time Initializing and Finalizing

My cubes can take 15-20 minutes during the initializing and finalizing steps when building. This is out of the 25-30 minutes it takes to do the entire build - so over 50% of our build time is coming from these steps. Does anyone have an idea what cou...

vrice by 8 - Cloud Apps
  • 1428 Views
  • 2 replies
  • 0 kudos

How to filter out dates past the current date

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 ...

amelia by 10 - ETL
  • 523 Views
  • 0 replies
  • 0 kudos

Resolved! In Sisense, how can you "group by" in ranges?

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...

leo82 by 9 - Travel Pro
  • 1265 Views
  • 1 replies
  • 0 kudos

Resolved! PREV query getting error

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 a...

amelia by 10 - ETL
  • 1841 Views
  • 4 replies
  • 0 kudos

Max # of columns in source 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 . Please...

mattmca by 9 - Travel Pro
  • 1446 Views
  • 3 replies
  • 0 kudos