Knowledge
Note: We are actively completing a knowledge migration process. This space will grow over the next few months as this work is completed. Provide feedback and/or content requests via the Share BETA Feedback forms found below.
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

Choosing the Right Data Model for You

Introduction Customers often run into the question of what data model they should use (an Elasticube or a Live Model). The following article presents a few of the aspects you should consider when choosing between them. Sisense recommends you discuss ...

Ophir by Sisense Team Member
  • 47 Views
  • 0 comments
  • 0 kudos

How To Read Dates Before 1970

Question I have to display a field with dates such as 06/05/1851, 07/07/1891 and things like that. I tried to workaround this by using CreateDate() but the data displayed is 01/01/1970. Do you know how I can display the right date in Sisense? Answer ...

Community_Admin_0-1634394209314.png Community_Admin_1-1634394209431.png

Rolling Trailing 12 Months

Question I'm looking for how to create a chart that shows how my business is performing for the last 12 months at each month-end for a set period. For example, the period ending March '20 would sum up Apr '19 to Mar '20. April '20 would sum up May '1...

Numeric Representation Of Dates And Times

Question I have to do a MAX() in the dashboard. The main thing here is that I have to have the last second entry for that specific field. Answer We suggest you would use a float numeric representation of the date, adding the minutes and seconds AFTER...

Reason For Adding A Custom Table

Question What is the reason of adding a custom tables in the ElastiCube? As I understand all the customizations and calculations should be done in the Dashboard itself, so why do we need to create custom tables? Answer The reason to create the table ...

Recommendations For A Book/Tutorial On SQL For Sisense

Question For a novice starting out with Sisense and a very basic knowledge of SQL, would someone in this community be able to recommend a book and/or tutorial that could help expedite learning the SQL syntax used in the system to set up custom tables...

How To Concate Three Strings In Elasticube

Question I have requirement to combine and show the dimension. There are two dimensions Product and Product_Family. I want to display it as single dimension in charts like "Product 1 | Product Family 1", "Product 2 | Product Family 1", so on. Answer ...

How to Split Row On New Line

Question Currently have a one column custom SQL table that has multiple entries per row, separated by a new line. I would like to be able to split or break apart the multiple values so we are left with one normalized table/column that has all of the ...

Community_Admin_0-1634393472490.png Community_Admin_1-1634393472469.png

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