Resolved! How to decrypt the encrypted columns
I have a few columns in the database that are encrypted. I checked with my data warehouse team and they said it is something Sisense is doing. Does anyone know how to decrypt these columns?
Forum Posts
Discarding Elasticube Changes Pending
Hi, having updated an elasticube model some of the relationships broke and I want to revert the changes back to the last built version; is there a way to do this easily? I can't go into the front end view of the model now, so only have access to the ...
Question regarding multi node build
In the linux server, if we use multi servers, we want to build the cubes in one server and copy to the other serving nodes and attach the cubes. We were doing it by copying the data folder in the Windows environment previously. Now we are upgrading i...
Migrating data out of Sisense
Dear community members - happy new year. Although I have seen this post it doesn't full gives me what I need. Am working on project which is funded therefore our license was paid thru the funder and unfortunately the funds have runout and we want to ...
Issues with Incremental Build on JDBC table
Hi all, CONTEXT ------------------We use GenericJDBC connector with custom queries to fetch data from our mongodb data source on Sisense. Our data model is similar to a star schema with one DIM table and several aggregated fact tables. Till date we h...
Unwanted Join Path
I'm facing an m2m error on one of my widgets. From the Analyze Widget JAQL view, I can see the issue is that inventory.tenant_id and vendor.tenant_id are not connected directly to tenant.id. The problem is that they are joined directly in the elastic...
Is it safe to delete PrismWeb logs
Hi, I found that "C:\ProgramData\Sisense\PrismWeb\Logs" occupied 5 GB space. This folder is not mentioned in Sisense documentation for clean up. SO is it safe to delete these logs? And please mention if you have any other suggestions on cleaning up C...
Formula to Return SUM similar to a SQL IN Statement in a GRAND TOTAL
Scenario: My organization has ACCOUNT that have multiple balances associated with them, and each account has a TYPE These accounts tie into a PORTFOLIO We have a Pivot that is to return all PORTFOLIOS and the SUMs of these ACCOUNTS. But we would like...
AccumulateBy with Connection change
Hi Team, I have cube with 800M rows and it is currently building incrementally. I got scenario where my DB source upgraded and I should change my connectivity of cube. What should happens if build a schema build? will my build bring only latest data ...
Retrieving previous rows data in Sisense Data Modeling
Hello all, I have a requirement where we need to get the value of last row's ending balance as beginning balance of the current row and this process should carry on for next 100 rows. And we don't have any base table for this and everything is build ...
refresh the schema to a table through the api
Is it possible to refresh the schema to a table through the api?
Migrating Elasticubes from Windows to Linux
Hi, I want to export elasticube from windows Sisense and import it to the Linux Sisense. I am able to export elasticube of type .ecube and .ecdata from Windows Sisense(7.0.2) But my Linux(L2022.8) is only allowing import of .smodel files. Could anyon...
Managing Elasticube Tables - How to move data from a table to another
Hi all, Sometimes, you can manage two tables in an Elasticube, one for historical data, and other for a month data. When the date goes to the next month, this accumulated monthly data needs to be copied to the historical data. The data is managed by ...
Identify Unused Fields on Cube
As our reporting needs and abilities change over time some fields on a cube become unnecessary. Has anyone found a way to identify what fields are NOT being used to easily trim down cubes? Thanks,
how to increase the chunck size
I have a table that has 1454334099 records and the build downloads 100000 in one hour it downloads 100.000.000 how can I increase the chuck or what is the best alternative to decrease the build times?
