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!1View0likes0CommentsTable Widget - Horizontal scroll
I’ve been trying to make the scrollbar always visible on the Table widget. I followed the code suggestions from this post, but after implementing the code, I don’t see any change in the widget. Is there any other solution to make the scrollbar visible all the time on the Table widget? Thanks in advance!Solved262Views0likes5CommentsColored labels in table
I'm having an issue with the widget script to color the labels in a table created by harikm007 in a previous post. https://community.sisense.com/t5/build-analytics/colored-labels-in-table-widget/m-p/10780 I have successfully been able to implement the script. However, the color flashes quickly when I load the dashboard then disappears. Any reason why or if I have to change the script?Solved654Views0likes7CommentsHow to Dynamically update formula?
I am trying to create a formula that dynamically changes with the dashboard filter that I set. The formula is: ( ([Total count], [@Months in Date Range]) / ([Total count], [@Previous 12 Months]) ) - 1 The Previous 12 months is the previous 12 months that I select from the dashboard filter so say the range is from 2024-09 to 2023-10, then the previous 12 months is 2023-09 to 2022-10. DRay Liliia_DevX do you know how to do this?Solved203Views1like6CommentsFiltering within a function
Attempting to create a filtered value by editing the formula. I want to see Count of total people for where risk is high. Field 1: People (All peoples name linked to a risk group) Field 2: Risk Group (High, Medium, Low) COUNT([People], [Risk_Group]) I right click on field [Risk_Group] then I edit the filter for the field as High. But I get a Syntax Error:Solved407Views0likes2CommentsHow to Have Break By Switchable Dimensions Update Title
I am trying to have the Break By Update the title of the Switchable Dimension rather than dimension. My script goes as follows. prism.registerSwitchDimension({ widget: widget, widgetTitleTemplate: "{{val}} By {{dim}}", // Dynamically updates title with value and dimension maxItemsBeforeSubMenuIsCreated: 5, // Keeps the menu clean if more dimensions are added dimensions: [ { panel: 'break by', // Ensure this matches the panel name in your widget dims: [ { "index": 0, "dim": "[GMV_ORDERS_DASH_UNION.SUPPLIER]", "datatype": "text", "title": "Supplier", "widgetTitleTemplate": "{{val}} By Supplier" }, { "index": 0, "dim": "[GMV_ORDERS_DASH_UNION.MANUFACTURER]", "datatype": "text", "title": "Manufacturer", "widgetTitleTemplate": "{{val}} By Manufacturer" }, { "index": 0, "dim": "[GMV_ORDERS_DASH_UNION.CUSTOMER]", "datatype": "text", "title": "Customer", "widgetTitleTemplate": "{{val}} By Customer" } ] } ] }); DRay Liliia_DevX541Views0likes6CommentsWEEKOFYEAR Function - Change Start of Week to Friday from Monday at Calculated Col Level
Hello Sisense Community, I would like to change Start of Week on "WEEKOFYEAR" function to Friday from default Monday at the column level (not at general server config settings). Is there a standard formula available? Thanks, - DennisSolved547Views0likes3CommentsSharing the datacube with multi tenants
Hi Team, I am currently implementing multi-tenancy in Sisense and sharing a single Elasticube across multiple tenants while enforcing Row-Level Security (RLS). The goal is to ensure that each tenant only accesses their respective data while using the same cube. I successfully shared the Elasticube with Tenant1, but when trying to access it, I get the following error: Error Loading Model Unexpected error value: { isOperational: false, message: "Request failed with status code 500", code: undefined, statusCode: 500, method: {some html tags and ids} Contact your system administrator for more information. The error persists even after confirming that: The Elasticube is correctly shared with Tenant1. Tenant1’s users, designers, and admin have access permissions. Multi-Tenancy is enabled in Sisense. Has anyone faced a similar issue when sharing an Elasticube across tenants? Any insights or suggestions would be greatly appreciated! Thanks in advance for your help.362Views0likes2Comments