Hi Everyone,I have a few fact tables that all share the column "registration". In my original build, I created a dim table by just saying:Select Distinct [registration ]from Table1 etcNow that I have other fact tables, is it possible to append all of...
EDIT: Sample data-set attachedHi there, I'm working on a dashboard that needs to accurately filter inventory records based on dbt snapshot dates (dbt_valid_from and dbt_valid_to) in SiSense. I face a similar challenge to another recent user post usin...
Hi Everyone, I am very used to using PowerBI, where one way to create a dimension table, you would duplicate the table you were looking for, choose the column you wanted and then removed duplicates. This was all done in power query.I am now wondering...
Hi Sisense Community,I'm working on an inventory dashboard in Sisense and I'm using dbt Snapshots to maintain historical inventory data. My snapshot table includes dbt_valid_from and dbt_valid_to columns to track the period for which each inventory r...
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...
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 r...
Does anybody know if regex is an option in Sisense custom tables? Can't find any documentation and it's not listed in available functions. I know I can use it in MySQL tables, but having it in custom tables will be very useful.We are using Sisense Cl...
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, - Dennis
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 ...
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 ...
Either with python or native features? @DRay
Hi,I'd like to create a Box & Whisker Plot to show the distribution of "Bookings" by "Day of Week" across the time period so the client/tenant should be able to see, for example, that on Mondays their bookings can range from 150 to 325 but there are ...
I am embedding iFrame into a web app and getting a pop-up to documentation. Is there a way to turn this off in the Sisense admin section? This is just a test environment but I don't want my users to see this pop-up. @DRay any suggestions?
I am creating a new JDBC connector and when I import the JDBC connector icon it appears slightly to the left. Is there a reason for this, or is there something within the JDBC connector configuration that manages this? @DRay
Hi SisenseWe would like to change the ownership of a datamodel (built on live connection) from user 1 to user 2. Can someone share the process?
