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

Knowledge Base Articles

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
  • 2063 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 hier...

intapiuser by Community Team Member
  • 231 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 a ...

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

Connecting Sisense to R Server

Problem You want to establish the connection between Sisense server console to the R server. Solution Installing Rserve Open an R console window. Run the command prompt: > install.packages("Rserve") Running Rserve Open an R console window. Load the R...

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

Control Chart

Please note this article is useful for Windows users and users who use older Linux versions that pre-date the Analytical Engine. Control charts are a common way to show a trend line of some metric, as compared to an upper and lower boundary. This art...

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

Resolving the ODBC_Wrapper.dll Error When Connecting Via ODBC

Scenario: A common error when trying to connect via ODBC to a data source is: "Could not load file or assembly 'ODBC_Wrapper.dll' or one of its dependencies..." This error can occur after successfully setting up the ODBC connection in the Windows ODB...

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

Year over Year for the past x months

Analytical Need Sometimes we wish to see how we are performing in the last x months and comparing that to the previous parallel period. For example, we wish to see how we perform from Sep last year to Aug this year and compare it with Sep 2 years ago...

intapiuser by Community Team Member
  • 1168 Views
  • 1 comments
  • 1 kudos

Auto Add Filter Based On User

Download: Auto FilterIntroductionThis article explains how to automatically add a dashboard filter, based on the logged in user.Purpose/BenefitsIn order to provide a better user experience, you may want to automatically set a filter on your dashboard...

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

Disable "Add To Pulse" Feature On Widgets

DISABLE "ADD TO PULSE" FEATURE ON WIDGETS FOR ALL VIEWERS Few businesses don't want their Users (Viewers) of the dashboard to add pulse alerts from the visualizations of the dashboard. Though we don't have any feature in the current version of the pr...

intapiuser by Community Team Member
  • 543 Views
  • 3 comments
  • 0 kudos

Troubleshooting Guide: General Website Loading Issues

This page is meant to provide an initial reference for website loading issues. Topics: 1. Page Doesn't Show Up 2. No Dashboard Panel on Left Side of Analytics Page/Bottom of Analytics Page 3. Queries are not Returning Data (Including Dashboards) 1. P...

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

Calculate Running Sum

Analytical Need There are cases where you wish to know for a certain point in time, how much you have accumulated up until now.This is called Running Sum.Although it is possible to use this in the dashboard, we may need to have the running sum on eac...

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

Blox Dropdown Placeholder

By default, BloX will use the first element in your dropdown as the default text in the dropdown box.Instead of this value, the following method adds a different default non-selectable value.Steps For Implementation Add the addPlaceholder class to yo...

intapiuser by Community Team Member
  • 424 Views
  • 1 comments
  • 0 kudos

REST API - Adding Data Level Security

When building code to automate the process of adding users (or groups), it may be beneficial to add security around those users. Follow the steps below to learn how to add data level security through the REST API: Step 1 From your SiSense home page, ...

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

Calculating Weighted Average

Analytical Need Weighted average refers to the mathematical practice of adjusting the components of an average to reflect the importance of certain characteristics. This practice can be useful in different scenarios, a few examples: In economics, thi...

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

Time Dimension

Analytical Need Many times we would like to deep dive into our data and view it in a more granular fashion to conclude from it. Certain business needs might require us to use date-time hierarchies to help us understand performance trends such as Sale...

intapiuser by Community Team Member
  • 525 Views
  • 0 comments
  • 0 kudos
Labels
Community Toolbox

Recommended quick links to assist you in optimizing your community experience:

Developers Group:

Product Feedback Forum:

Need additional support?:

Submit a Support Request

The Legal Stuff

Have a question about the Sisense Community?

Email [email protected]

Share this page: