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

Forum Posts

Migrating Elasticubes from Windows to Linux

Hi, I want to export elasticube from windows Sisense and import it to the Linux Sisense. I am able to export elasticube of type .ecube and .ecdata from Windows Sisense(7.0.2) But my Linux(L2022.8)  is only allowing import of .smodel files. Could anyo...

Akhila by 8 - Cloud Apps
  • 1483 Views
  • 1 replies
  • 0 kudos

Identify Unused Fields on Cube

As our reporting needs and abilities change over time some fields on a cube become unnecessary. Has anyone found a way to identify what fields are NOT being used to easily trim down cubes?   Thanks,

gwolfe by 10 - ETL
  • 1272 Views
  • 1 replies
  • 0 kudos

Builds succeed, but records missing

Has anyone else run into a situation where Elasticube builds succeed, but only return a partial set of records? I'm finding that it is only happening in our largest Redshift table. There are 1.5 million records...the build is shown as successful but ...

how to increase the chunck size

I have a table that has 1454334099 records and the build downloads 100000 in one hour it downloads 100.000.000 how can I increase the chuck or what is the best alternative to decrease the build times?

alexgv12 by 9 - Travel Pro
  • 2811 Views
  • 3 replies
  • 0 kudos

ElastiCube Data Security

I am having issues with setting up Data Security - The goal is to create a hierarchy in which each employee can see only his/her data alone.  I have set up the ElastiCube to also join manager emails so a manager can see his/her whole team.  Upon show...

Capture.PNG
Rkile by 8 - Cloud Apps
  • 1051 Views
  • 1 replies
  • 0 kudos

How do I connect MySQL to Sisense?

This is my first time using Sisense, I was asked as part of the interview process to get myself familiar with Sisense platform so I signed up for a free trial to use Sisense. I'm wondering if I can connect MySQL to Sisense on MacOS? Because I saw tha...

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

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

Resolved! How do I display the earliest date as a column in a pivot table?

Hi, I need to create a healthcare pivot table with three columns.  Provider Name, number of claims by provider, and earliest date of encounter for each provider. Something like above.. However this being a pivot table is it possible to achieve the l...

hkkwon89_0-1661186465092.png
hkkwon89 by 9 - Travel Pro
  • 3697 Views
  • 3 replies
  • 1 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...

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
  • 1509 Views
  • 1 replies
  • 0 kudos

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
  • 2262 Views
  • 2 replies
  • 0 kudos

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
  • 2506 Views
  • 2 replies
  • 0 kudos