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

Forum Posts

Resolved! How to grant View only Access on the Elasticubes to Designers

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

Rajesh by 8 - Cloud Apps
  • 1 replies
  • 2 kudos

Resolved! How to create Custom Columns: ThisWeek, ThisWeekPrevYear?

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

EricB10 by 8 - Cloud Apps
  • 4 replies
  • 0 kudos

Resolved! Un-weighting an average value

Hello all, I have what I hope is a simple question. We have a database that can be boiled down to the image below. Each entry has a date (YYYYMM) and whatever the monthly member count is for that entry (Members). We want an average member count of Q4...

pcolson by 8 - Cloud Apps
  • 5 replies
  • 0 kudos

Using answer to a calculation within another calculation

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

CLewis_0-1643412425107.png CLewis_1-1643413787436.png
CLewis by 8 - Cloud Apps
  • 4 replies
  • 0 kudos


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


Connect to PI Historian

Can you give me some tips on how to connect an elasticube to a PI Historian server? Is there an add on for PI Historian that I need? We want to combine data from an Oracle database with PI Historian data to show both in a dashboard.


How to create a table with a range of dates?

Hi,I have a use case were I have this tableI want to plot in a chart in continues dates (i.e. from the minimum date of launch_time to the current date).e.g. 1/1/20 - 1/12/22 and count the number of instances that were alive in a certain date based on...

TomerA by 8 - Cloud Apps
  • 3 replies
  • 0 kudos

Not connecting to Azure cloud SQL via Federator

We are using enterprise version of Sisense using another UserName , when we connect directly from Sisense source connection MsSQLserver we are able to successfully login Azure cloud SQL(this is the vendor cloud- where the Sisense IP is whitelisted in...

Dskumar87 by 7 - Data Storage
  • 1 replies
  • 0 kudos

Tips on Managing Formulas / Getting Consistent Calculations

Question for y'all: How do you maintain consistent calculations of key metrics? Custom columns in the data model won't work b/c I need aggregations that can be easily filtered (e.g. can't add activation % to my base table b/c my stakeholders want to ...

hlorosc by 9 - Travel Pro
  • 4 replies
  • 0 kudos

Analysing EC Builds

I was looking for a way to analyse EC Builds in an easy way to identify where potential bottlenecks within the buildprocess could be. I have created a python script which exports EC build logs (can only export latest build logs) to JSON and converts ...

HamzaJ by 12 - Data Integration
  • 1 replies
  • 7 kudos

Resolved! Benchmarking in Sisense

What is the best approach in Sisense for sharing benchmarking information while maintaining customer confidentiality? When I was a Sisense customer a key differentiator for us was showing our customers how their performance metrics compared to others...