Knowledge
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
  • 659 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 ODBC-64...

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

intapiuser by Community Team Member
  • 322 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
  • 1389 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
  • 5448 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
  • 238 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
  • 677 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
  • 680 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
  • 468 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 [email protected]

Share this page: