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...
This post has become outdated. You can find guidance on choosing a data model on our documentation site here. https://docs.sisense.com/main/SisenseLinux/choosing-the-right-data-model.htm Introduction Customers often run into the question of which d...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Capturing accurate business transactions is imperative in understanding business operations. If data is constantly changing, such as being deleted or updated, how do you ensure your Elasticube is in sync with your data source? Depending on the use ...
Question What is the reason of adding a custom tables in the ElastiCube? As I understand all the customizations and calculations should be done in the Dashboard itself, so why do we need to create custom tables? Answer The reason to create the t...
Question We have multiple clients and to maintain this we modeled the dim_client table and we implemented the data security rules on this table. We have 2 fact tables (fact_sales and fact_budget) to have the sales information and sales target inform...
Question How to do a lookup using two conditions (i.e., pulling project number on a unique equipment for a specific day)? Answer You can only use one field as the key field in Lookup function. So, it is better to create a combined key (using conca...
