Help with CI/CD Workflow for Sisense + GitHub Integration
Hi everyone, We're currently using two environments—test and prod—and recently began using Sisense's Git integration with GitHub. We're now looking to improve our CI/CD process and wondering if anyone has come across solid documentation or examples. Specifically, we're hoping to: Automatically deploy changes from a feature branch in test to main in test after a pull request is merged Then automatically deploy the same changes to prod Has anyone implemented a workflow like this or found official guidance on automating these deployment steps? We'd love to avoid manually pulling these changes into each environment. Appreciate any advice, links, or lessons learned!
How to Dynamically Switch Between Multiple Data Models in a Single Dashboard?
Hello I am building a dashboard where different user groups need to view similar KPIs sourced from different ElastiCubes. For example; one group uses the Sales_US model & another uses Sales_EU. Rather than duplicating dashboards for each data model, I am exploring ways to dynamically switch between data sources within a single dashboard using a parameter or user/group attribute.🙂 Has anyone implemented a solution where the dashboard automatically pulls from the relevant data model based on user login, group / a dropdown selector? 😇 Ideally; I would like to avoid duplicating widgets and dashboards, and instead create a flexible design that changes context based on the selected (or detected) model.🤔Checked https://docs.sisense.com/main/SisenseLinux/embedding-dashboards-and-widgets.htm related to this and found it quite informative. If this isn’t natively supported, are there any creative workarounds using Sisense Blox, embedding API / script-based redirection/Generative AI Course ? 😇 I’m open to hybrid approaches as long as they maintain a good user experience. Thanks in advance!🙂
Build To Destination Failure
While Trying build to Destination in an elasticube model, I am getting destination viewer error. Is it related to any configuration issues and is it necessary to provide the database and schema parameter while doing Build to destination? Attaching the screenshot of the generated error
Handling Latest Records in widget (pivot/charts) in context of filters selected
Hi, I have a table with test cases (testcase_key, Type), cycles (cycle1, cycle2, ...), and executions (test_result, execution_timestamp). Scenario: A test can be executed multiple times within one cycle, and the same test case can also be executed in subsequent cycles. I want to keep only the latest execution of each test case in a pivot table. The dashboard has a filter for cycles. I can write custom SQL like this: SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (PARTITION BY testcase_key ORDER BY execution_timestamp DESC) as rn FROM executions ) sub WHERE rn = 1; The challenge with this approach is that it only shows the test case of the latest cycle. If a user selects any past cycle, I am not able to see the latest test case status and type for that cycle. I have also tried using JAQL, but it doesn't work as expected. Here is the JAQL query I used: { "top": 1, "by": { "table": "executions", "column": "actualenddate_ts", "dim": "[executions.actualenddate_ts]", "datatype": "numeric", "agg": "max" }, "context": { "partition": [ { "table": "executions", "column": "testcase_key", "dim": "[executions.testcase_key]", "datatype": "text" }, { "table": "executions", "column": "issue_key", "dim": "[executions.issue_key]", "datatype": "text" } ], "sort": { "table": "executions", "column": "actualenddate_ts", "dim": "[executions.actualenddate_ts]", "datatype": "numeric", "order": "desc" } } }
