HamzaJ
Data Integration
Joined 10-20-2021
User Profile
User Widgets
Contributions
Re: What does an ElastiCube put in RAM
Hey Tim , To my understanding; When a EC is build all imported data is stored on the disk (unless configured otherwise like S3). Whenever a cube is (re)build, the first time a user opens a dashboard, generates a report or does any action concerning data from the EC the EC is queried based on the data stored on the HDD. This query result is stored in RAM. So for example if you have a dashboard with 10 different widgets , there will be 10 query results stored in the RAM (simply put, it does deserve some nuance). This way when a (different) user opens the same dashboard the results are loaded quicker. However changing the result, for example with filters, will have longer loading times due to it not being cached (depending on server resources and datagroups configuration). Leading to an increase of RAM usages. In the end depending of the usage of Sisense and the specific EC loading data will be a mix of hdd and ram. The mix is mostly determined if users query same/similar data or if it is more volatile. As far as I know Sisense handles cache in a 'smart' way meaning that not uses query results are dropped. How it specifically/technically works on a detail level, is something I think Sisense can answer. Hamza22Views0likes0CommentsRe: How to Display Category with 0 Values in Bar/Line Chart?
Hey Astroraf , I know there is a way to do this, but i cant recall the correct formula/steps. I tried it myself but couldnt get it. If there are not to much categories you could try the measured filter route. Otherwise I think a edit on datamodel level is needed. Hamza65Views0likes1CommentRe: How to Display Category with 0 Values in Bar/Line Chart?
Hey Astroraf , I think it is dependent on how the data is stored. If it is in the same table i think a you can do this with a formula that counts all categories (e.g. count(categories), ALL(filter1),All(Filter2)) . If it is stored in multiple tables then i do not think it is possible, unless; you are on the newest linux version of sisense which supports join types and you can select a different join type then inner join if the amount of categories is limited you can apply a measure filter (e.g. (count(ID), Category=A) per category and repeat it. Hamza74Views0likes3CommentsRe: How can I turn JAQL query into a SQL query?
Only admins can run sql?query= if I am not mistaken. That jaql/sql endpoint is the only endpoint that translates jaql to sql. If it isnt usable, then I am afraid there is no way to translate a jaql to sql within Sisense itself. You would have to translate it somehow yourself unfortunately.75Views1like0CommentsRe: How to filter a table/pivot table: Filter one column that does not equal another column?
Hey Astroraf , You would need to use a formula and then filter on that formula. It can , i think, only be done with a CASE-/IF-statement. If your column is numerical you can do; case when max(A)=max(B) then 1 else 0 end Hamza66Views0likes0CommentsRe: How can I turn JAQL query into a SQL query?
Hey asael, If i am not mistaken there is an api that does exactly this. If you need to automate the process this could be the way. If it is more a one of kind of thing , then you can edit the widget , hit the three dots and select sql query. It will give you the sql code Hamza146Views0likes1Comment