nataliia_kh
ETL
Joined 2 years ago
User Profile
User Widgets
Contributions
Using constants with special characters in custom tables [Linux] [Windows]
When using backslashes (\) in Sisense custom table queries, values like N\A may be rendered as NA due to MonetDB's handling of escape characters. To avoid this, use a forward slash (/) instead, or properly escape the backslash in your query. This ensures your data is displayed accurately during the build process.Data Group configuration for EC2EC connections [Linux]
When using EC2EC connections in Sisense, it's important to configure Data Groups properly to avoid build failures caused by the "Stop When Idle" feature. Data source cubes must remain in the Running state, so they should be moved to a dedicated Data Group with "Stop When Idle" turned off. This ensures EC2EC builds complete successfully without interruption.Resolving Build Failures Due to Memory Issues [Safe-Mode]
This is the guide of which settings should be checked and adjusted to resolve the problem and prevent future occurrences, in cases when cubes fail with the error ‘Safe-mode’. Please follow the steps below, and after that try to re-build the failed cubes.Resolving Missing Generic JDBC Connector in Sisense
This article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This problem arises due to changes in the framework that affect the visibility of certain connectors for non-admin userResolving Missing Parse Option in SQL DB Connection
This article addresses the issue of the missing "Parse" option when connecting to an SQL database in Sisense. Users may encounter this problem when attempting to parse data from SQL DB connections. This guide will explain why the "Parse" option might be unavailable and provide steps to resolve the issue.Resolving DBLink Issues in Sisense for Postgres Connections
This article addresses the issue of using DBLink with Postgres connections in Sisense. DBLink is a feature in PostgreSQL that allows users to connect and query data across different databases. However, users may encounter limitations when attempting to use DBLink within Sisense's custom import queries. This guide explains the issue and offers a solution to effectively manage data from multiple databases in Sisense.Resolving Missing Generic JDBC Connector in Sisense
This article addresses the issue where the Generic JDBC connector is not visible under available connectors for users logged in with a designer account in Sisense version 2023.6 or newer. This problem arises due to changes in the framework that affect the visibility of certain connectors for non-admin users.
