Data Models
cancel
Showing results for 
Search instead for 
Did you mean: 

Knowledge Base Articles

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
  • 10501 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
  • 1519 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
  • 1079 Views
  • 0 comments
  • 0 kudos