IntroductionThis tutorial describes exporting large cubes with data (*.sdata) - more than 2 GB using the Sisnese CLI Commands.PrerequisitesSometimes you need to export from Sisense large cubes - more than 2GB but you cannot do it by using the Sisense...
Restoring missing connector Introduction Sometimes connectors can go missing for some reason, leading to a breakdown in data connectivity. Restoring these connectors is crucial to maintaining a smooth data flow within your Sisense environment. This a...
IntroductionThis tutorial describes the steps to modify the owner of an Elasticube, a crucial task for managing your data efficiently. By following these instructions, you'll be able to transition ownership from one user to another seamlessly.Prerequ...
Sisense lets you import data from multiple sources using built-in connectors or by a customized connector. Sisense custom REST connectors framework enable you to program your own connectors to popular data sources which support REST services, to impo...
* Disclaimer: This works for Windows only. It will work in future with Linux versions as well. Once it does, I will update the post. Sometimes, we need to export a table from the Elasticube to a CSV file. We can then import it to the next build, to s...
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...
Configuration of Share Permissions for a Data Model Does Not Save the Changes Question For Data Admins and Data Designer users, there is a function available to configure share permissions for the Data Model. Sometimes it can be noticed that new chan...
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 ca...
Introduction This article will guide you on how to configure the Data Groups’ parameters based on the current performance and business requirements. What are "Data Groups”? The “Data Groups” administrative feature allows configuring Quality-Of-Servic...
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 dat...
![83227784_3726975083979609_8570336295451099136_n[1].jpg](/t5/image/serverpage/image-id/602i3D789947CB5B424B/image-size/medium/is-moderation-mode/true?v=v2&px=400)
Question I have to display a field with dates such as 06/05/1851, 07/07/1891 and things like that. I tried to workaround this by using CreateDate() but the data displayed is 01/01/1970. Do you know how I can display the right date in Sisense? Answer ...
Question I'm looking for how to create a chart that shows how my business is performing for the last 12 months at each month-end for a set period. For example, the period ending March '20 would sum up Apr '19 to Mar '20. April '20 would sum up May '1...
Question I have to do a MAX() in the dashboard. The main thing here is that I have to have the last second entry for that specific field. Answer We suggest you would use a float numeric representation of the date, adding the minutes and seconds AFTER...
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 table ...
Question Is there any way to get the views to execute sequentially instead of simultaneously? How does the dashboard in Sisense execute the queries? Answer The Sisense client application does attempt to send out all queries (one per widget) at once, ...
