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: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: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: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, mathem...
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: Solution: To accom...
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 ...
Question: What is the best way to remove leading zeros? I have a field that is alphanumeric values (JONESBJ001, SMITH KC02, 0000012345, 0000555213. Solution: If all of your data with leading zeros will always be some sort of numerical string (ie ther...
Question: A relatively common database design strategy is to have a tag column with an arbitrary number of tagsHere 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:Now ...
Question: For a specific industry, like Education, even though the number of days is roughly the same every year, each academic year can start and end on different dates. The usual way of calculating YTD wouldn't work for this requirements because sc...
Question: A data source in your ElastiCube contains a field with multiple values in it delimited by a particular character (i.e - comma, semicolon, space, etc.). You need to parse that field and create a table with a record for every value in the del...
Question: When using "Accumulate By" builds (see below), Sisense will only import "new" records based on a selected INT or DATETIME index field - if values in the source DB exceed the maximum value of that index as of the previous ElastiCube build, t...
Recommended quick links to assist you in optimizing your community experience:
Developers Group:
Product Feedback Forum:
Need additional support?:
The Legal Stuff
Have a question about the Sisense Community?
Email community@sisense.com
