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 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
  • 465 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
  • 242 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
  • 196 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
  • 201 Views
  • 0 comments
  • 0 kudos

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

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

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: Solution: To accom...

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

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. Solution: If all of your data with leading zeros will always be some sort of numerical string (ie ther...

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

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

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

Split A Delimited Field Into Rows

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

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

Supporting Updates And Deletions In DB When Building Accumulate

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

intapiuser by Community Team Member
  • 273 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