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

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

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

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

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.Solution:Begin by installing the Sisense ODBC driver.https://documentation.sisense.com/latest/odbc.htmOnce it is installed, go to ODBC-64...

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

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

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

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

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

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 fieldSolution: We suggest you would use a float numeric representation of the date, adding the minutes and seconds AFTE...

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

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? Solution: The reason to create the ta...

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

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

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

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.Solution: This can be easily done within ...

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

Editing An Existing SQL Custom Import Query

Question:I want to edit existing Custom Import Query, how can I do so?Solution: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 ...

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

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)Solution:JulianAddDays(CreateDate(1970,1,1),...

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

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.Solution:The log that shows these actions in the ElastiCube server is called ECM.log and i...

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

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.Solution:If you open the Task Manager, go to the Details tab and right-click on one ...

intapiuser by Community Team Member
  • 88 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 community@sisense.com