Connecting Sisense to Local SQL Server in Sisense version 7.4.4 and newer Open SQL server and initially connect using windows Authentication. Go to Security > Logins, right click and Create new user as seen in example below.3. Next go to “User Mappin...
For organizations embedding Sisense into their application using an iFrame we have identified a situation where the iFrame may not render when browsing to the application using Safari. This can be fixed with one setting change in the Safari browser. ...
Sisense JS Plug N Play - Embed In Minutes! A simple and easy jump start solution for embedding Sisense using Sisense.js on your website! SisenseJSPlugNPlayV1 DEPENDENCIES: JQuery SisenseJsPlugNPlay.js Sisense deployment with open CORS Cookie from sis...
Question: How can I update an embedded widget using a JAQL query and post to /jaql using sisenseJS?Answer:JAQL is just the syntax for querying data - it is not inherently bound to any specific widget or dashboard, which in turn means that executing a...
The above error may occur as a result of a timeout on the SQL server. This is more likely to happen when one or more of the following conditions apply: The MySQL server is at a remote location (possibly with poor network connectivity) Heavy network t...
Question:In pivot tables, we would like to show column grand totals on top of the table and row grand totals at front. Please let us know how to alter positions.Asnwer:This script will move the grand total row to the top. widget.on('ready', function(...
Analytical Need You want to display a chart/table with the Top X and Bottom X, all in the same widget Modeling Challenge Sisense allows setting ranking filters based on a measure, but this is only for Top OR Bottom. Solution Widget Filter: Create you...
IntroductionThere is no OOTB option to roll up a date by the day of the week.Use this simple trick to achieve this with a simple custom field which will display and sort as a calendar day without any additional script.InstructionsCreate an expression...
IntroductionQuick functions are a great way to perform comparative analysis based on time periods. However there is no easy way to do a comparison to date. e.g. YTD vs YTD Last Year. e.g. If today is Sep 27, 2018 then we want to compare Jan 01 - Sept...
IntroductionUsing line markers can be a great way to compare data whether it be over time or across a category. However, creating a marker requires using the Javascript API to hide the line. The steps below outline how to remove the line from a serie...
Question: I am looking for a way to hide the latitude/longitude from the tool-tip in a scatter map. It appears by default and I searched through other posts but couldn't find anything. I still want the tool tip to appear, just remove the lat/long. An...
IntroductionThe purpose of this article is to show you how to use a bar chart as an indicator to provide an overview and allow you to make selections.Bar charts are normally used to provide quantitative visualizations across wide sets of data. Howeve...
Question: How to see the latest date in the Pivot? Solution: You need to change the date to an integer. Then I used the script in the comments in a previous post, and was able to request results. This is the script we used var m_names = new Array("Ja...
The purpose of this post is to provide the instructions to use a bar or column chart to create a widget where you can compare a value such as revenue to multiple goal levels. In order to do this I had to add a slight modification in the Elasticube. T...
Purpose: To create a product aggregation in Sisense (multiplies all values together, similar to the way a sum function adds all values together). Situation: A financial use case has a table with relative daily gains/losses for certain securities (thi...
