Knowledge Base
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
  • 1224 Views
  • 1 comments
  • 2 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://www.sisense.com/data-connectors/odbc/ Once it is installed, go to ODB...

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

intapiuser by Community Team Member
  • 491 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, mathe...

intapiuser by Community Team Member
  • 2080 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: T...

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

intapiuser by Community Team Member
  • 396 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
  • 1120 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
  • 999 Views
  • 0 comments
  • 0 kudos
Labels