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...
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...
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...
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...
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 '...
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...
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...
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...
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 ...
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 ...
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),...
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...
Question:When an elasticube is created in desktop version of elasticube manager, only a .ecube file gets created, where as when an elasticube is created in web version of elasticube manager, a folder with the elasticube name is created that contains ...
Question:This post we will talk about accumulation via millisec by using a unix timestamp transformationIn this use case, We will be working with a CData Elasticsearch ODBC driver and client need a way to accumulate data base off milliseconds.Naively...
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 ...
Recommended quick links to assist you in optimizing your community experience:
Need additional support?:
