Show full date format in the pivot or table widget If you want to show the full date format, like 2024-11-20 18:00:00 in the Pivot or Table widget, please do the following: 1. Go to the elasticube find the Date column and duplicate it ALT text: A us...
Use case You have specific libraries in Notebooks that have to be installed to run Custom code tables. However, these libraries can be uninstalled automatically (during upgrade or other system changes). Solution Add the following Python code into th...
Resolving Elasticube(s) not starting to build process issue Summary This article addresses the issue where Elasticubes are not properly starting the build process and fail to produce a build error (before the initialization process can begin). Step-...
Resolving Issues with Updating EC2EC Passwords in Elasticube Connections Summary This article addresses the issue of updating EC2EC (Elasticube to Elasticube) passwords in the context of employee off-boarding or password changes. Specifically, it c...
Troubleshooting "BBP Error 1551" in Sisense ElastiCube Builds Summary This article provides a comprehensive guide to troubleshooting the "BBP error 1551" that occurs during the build process of ElastiCubes in the Sisense Windows environment. The err...
Automating Dashboard Ownership Transfer in Sisense with UserReplaceTool Managing and deleting user accounts in Sisense can create manual processes when users leave an organization or change roles. A frequent issue is the reassignment of dashboar...
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...
Workaround for "File exceeds Limitation of 500 MB" If you try to import a CSV file to Elasticube and receive a message "File exceeds the limitation of 500 MB" As a workaround, you may upload large .csv files to the File Manager and then point to th...
* 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...
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...
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...
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...
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)
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 cha...
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 ...
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-Servi...
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? An...
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 '...
Question I have to do a MAX(<ColumnName><of DateTimeFormat>) 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, ad...
