Knowledge Base
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

DBfarm Cleaner, remove unattached cubes

When a build fails, the folder that was created up to that point with the data will still remain on your server. This can consume 100s of GB and required to clean from time to time. The attached application runs on the server cleaning all unnecessary...

intapiuser by Community Team Member
  • 547 Views
  • 0 comments
  • 0 kudos

Enable Sending Sisense Monitoring Logs

Sisense collects data when you or your users install or use Sisense products or services. Sisense uses the data collected for internal and support-related purposes such as improving our products and services, improving customer engagement, conducting...

intapiuser by Community Team Member
  • 819 Views
  • 0 comments
  • 0 kudos

Developing Custom REST Connectors

Sisense lets you import data from multiple sources using built-in connectors or by a customized connector. Sisense custom REST connectors framework enable you to program your own connectors to popular data sources which support REST services, to impo...

intapiuser by Community Team Member
  • 402 Views
  • 0 comments
  • 0 kudos

Exploring ElastiCube data with ODBC connection to R

Problem You want to determine if there are any problems with your dataset from the ElastiCube and whether the question you are asking for Sisense with R integration can be answered by the data that you have. Solution Installing the Sisense ODBC driv...

intapiuser by Community Team Member
  • 552 Views
  • 0 comments
  • 0 kudos

Data Denormalization for Faster Dashboard Query Response

Introduction This post will explain how to denormalize your ElastiCube schema in order to get faster query response in SiSense Web. Purpose/Benefit Denormalization of data is used to reduce the query response time in SiSense Web.  It is most useful f...

intapiuser by Community Team Member
  • 650 Views
  • 0 comments
  • 0 kudos

Maximize Dashboard Performance

What is good dashboard performance? Dashboard performance is the time it takes to load a Sisense dashboard.  We want our users to have a good experience when working with our data.  The time taken to load the dashboard is the first step.  Each indi...

intapiuser by Community Team Member
  • 2829 Views
  • 0 comments
  • 0 kudos

Data Transpose Guide

Source data that is flattened may require some or all of the columns of a source table to be transposed, in order to work seamlessly with SiSense’s functionality. This post will outline the cause and two possible solutions to this issue. The first so...

intapiuser by Community Team Member
  • 2546 Views
  • 0 comments
  • 0 kudos

Duplicate Drill Hierarchies for Another ElastiCube

Introduction This article will demonstrate one way to create duplicates of your hierarchies that use a different ElastiCubes. This could be useful if you have several ElastiCubes with the same schema, and you don't want to manually re-create the hi...

intapiuser by Community Team Member
  • 355 Views
  • 0 comments
  • 0 kudos

Install Error Service 'W3SVC' (W3SVC) failed to start

During the install of Sisense, you may run into the following error:  We're sorry, There was an error with your Sisense installationService 'W3SVC' (W3SVC) failed to start. Please restart your computer and try installing again. The W3SVC service is ...

intapiuser by Community Team Member
  • 16003 Views
  • 0 comments
  • 0 kudos

Dynamic Dimension/Value Chart

Version: 1.1 Download the plugin attached Introduction This article explains how to install and configure the Dynamic Dim/Value Chart plugin as seen below.  The Dynamic Dim/Value chart allow Dashboard designers to predefine multiple dimension and/or...

intapiuser by Community Team Member
  • 790 Views
  • 0 comments
  • 0 kudos

Export Tables To CSV Post Plugin

Download Zip: ExportTablesToCSVPostPlugin Files included: ectools.zipectools_sisense_ver<6.4.zip - (only for versions 6.4 and below)python-2.7.11.amd64.msiconfig_example.txtEC_export.dll This post explains how to install and configure the post plugi...

intapiuser by Community Team Member
  • 953 Views
  • 0 comments
  • 0 kudos

Trend Lines (Menu Based)

  Introduction Use this extension to plot a regression line within a chart. It works for Line, Bar, Column and Scatter charts. It is menu driven and does not require any script to be written. It will plot a regression line for each series in the cha...

intapiuser by Community Team Member
  • 651 Views
  • 0 comments
  • 0 kudos

Logging Users Out Of Sisense From Your Site

Download: Post Message Introduction The following forum post explains how to log your users out of Sisense from your native application. Purpose Single sign-on (SSO) systems enable your users to authenticate themselves in your online services and th...

intapiuser by Community Team Member
  • 1351 Views
  • 0 comments
  • 0 kudos

Dashboard Handbook Creator

  This script creates a word-document of the given dashboard IDs. This document includes dashboard name and Widget name,description and image.  Config settings.yml Edit settings.yml with your information ! Be carefull running this script. It searche...

intapiuser by Community Team Member
  • 212 Views
  • 0 comments
  • 0 kudos

The Smart Label

Download: Smart Label   Introduction The following article describes steps needed to add to create smart text widget to present ElastiCube fields as text.   Implementaion Steps Extract the folder in the attached zip file into \...\Sisense\PrismWeb\p...

intapiuser by Community Team Member
  • 1179 Views
  • 0 comments
  • 0 kudos

Bullet Chart

Download: Bullet Chart  Introduction This article explains how to import a bullet chart plugin into Sisense.The bullet chart plugin support column charts and bar charts. The plugin supports version 5.8 and up. Bullet chart is used to compare the dat...

intapiuser by Community Team Member
  • 818 Views
  • 0 comments
  • 0 kudos

Python 3 Script to Import Many ElastiCubes

Introduction The attached script is intended to loop through all ElastiCube folders in your ElastiCubeData folder and import them. Business Case This solution has a couple of possible use cases.  The first is to facilitate migrating a Sisense environ...

intapiuser by Community Team Member
  • 348 Views
  • 0 comments
  • 0 kudos

Simple Radar Chart Design

  SIMPLE AND CLEAN DESIGN FOR A RADAR CHART RadarChart-V1.zip Install: Download the attachment.Extract the .zip folder into the plugins folder. If the folder does not exist, create it prior to extracting the .zip file.For V7.1 and earlier: C:\Progr...

intapiuser by Community Team Member
  • 315 Views
  • 0 comments
  • 0 kudos
Labels