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

Forum Posts

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 7 - Data Storage
  • 17 Views
  • 0 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 9 - Travel Pro
  • 54 Views
  • 0 replies
  • 0 kudos

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 7 - Data Storage
  • 98 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 9 - Travel Pro
  • 221 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 8 - Cloud Apps
  • 167 Views
  • 3 replies
  • 0 kudos

Unwanted categories in dashboard filter

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

cglowe_0-1653315136304.png
cglowe by 8 - Cloud Apps
  • 81 Views
  • 1 replies
  • 0 kudos

Using Google Ads connector for EC models with CDATA Driver

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

guyraz_0-1652802810366.png guyraz_2-1652802810349.jpeg guyraz_3-1652802810339.png
guyraz by Sisense Team Member
  • 119 Views
  • 0 replies
  • 0 kudos

Values not appearing in pivot table

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

amelia by 9 - Travel Pro
  • 256 Views
  • 2 replies
  • 0 kudos

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
  • 202 Views
  • 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
  • 456 Views
  • 4 replies
  • 0 kudos