Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

How To Filter For The Last Two Records Using SQL In Ecube

Question How to find out if there exists the top 2 records for the same ClientID in a table. I know that the MAX gives the Top record and that SQL has the LIMIT 2 but I cannot use these two keywords in eCube. Answer This can be easily done within the...

Editing An Existing SQL Custom Import Query

Question I want to edit existing Custom Import Query, how can I do so? Answer From the context menu open on the table with custom import query Change connection settings for table: From there you will be able to see your custom import query and edit ...

Community_Admin_0-1634393286648.png

List Of Date Format Conversions

Question A date stored in a source system is not a datetime that Sisense recognizes. Converting it to a Sisense datetime allows powerful front end capabilities (such as drill down, quick functions and more). Answer Julian AddDays(CreateDate(1970,1,1)...

Connecting To The ElastiCube From Microsoft Excel

Question The purpose of this post is to demonstrate how to connect to a Sisense ElastiCube from Microsoft Excel. Answer Begin by installing the Sisense ODBC driver. https://documentation.sisense.com/latest/odbc.htm Once it is installed, go to ODBC-64...

Community_Admin_0-1634391787674.png Community_Admin_1-1634391787798.png Community_Admin_2-1634391787814.png Community_Admin_3-1634391787833.png

Any Logging On Schedule Synchronization Function

Question Is there any logging on changes made to the schedule sync? We have an instance where one schedule build was disabled, and we would like to find out why. Answer The log that shows these actions in the ElastiCube server is called ECM.log and i...

Get ElastiCube from Process ID

Question I would like to be able to track memory consumption of my ElastiCubes, but I can't find an easy way to link the process ID of my ElastiCube to the cube name. Answer If you open the Task Manager, go to the Details tab and right-click on one o...

Community_Admin_0-1634390814957.png

Using SQL Coalesce To Handle Null Values

Question SQL NULL is not technically a value, but rather a state. Fields are not equal or not equal to null, they are or are not null. As such, null fields can get a little tricky when attempting different kinds of transformations. For example, mathe...

Community_Admin_0-1634390659280.png Community_Admin_1-1634390677037.png Community_Admin_2-1634390677023.png Community_Admin_3-1634390677018.png

Flattening JSON Objects In SQL Server

Question In instances where tables within SQL Server contain JSON objects within a column you can use the import SQL query editor feature in Sisense to flatten these objects into individual fields. For example: Can be turned into: Answer To accomplis...

Community_Admin_0-1634390519573.png Community_Admin_1-1634390519543.png Community_Admin_2-1634390519666.png Community_Admin_3-1634390519659.png

Consortium Data By Masking Sensitive Values

Question Some organizations provide Sisense to their clients as part of their business offering. Some of these organizations would like also to provide clients with the consortium data derived from Sisense - a single ElastiCube where clients submit t...

Community_Admin_0-1634390318706.png Community_Admin_1-1634390318600.png Community_Admin_2-1634390318620.png Community_Admin_3-1634390318581.png

Removing Leading Zeros

Question What is the best way to remove leading zeros? I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213. Answer If all of your data with leading zeros will always be some sort of numerical string (i.e. there ...

Community_Admin_0-1634390116642.png

Filtering On Multiple Tags In A Single Row

Question A relatively common database design strategy is to have a tag column with an arbitrary number of tags. Here is an example in which we look at numbers between 1 and 10 and tag them as even, odd, perfect, or parts of the Fibonacci sequence: No...

Community_Admin_0-1634389875348.png Community_Admin_1-1634389886856.png Community_Admin_2-1634389886818.png Community_Admin_3-1634389886833.png

LAG / LEAD Functions

Question LAG & LEAD Functions are functions that give access to multiple rows within a table, without the need for a self-join. The LAG function is used to access data from a previous row, while the LEAD function is used to return data from rows furt...

Community_Admin_0-1634389201706.png Community_Admin_1-1634389201499.png Community_Admin_2-1634389201175.png Community_Admin_3-1634389201530.png