HamzaJ
Data Integration
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: 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.15Views1like0CommentsRe: 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 Hamza17Views0likes0CommentsRe: 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 Hamza93Views0likes1CommentRe: How to create a filter within a widget?
Hey Astroraf , I do not know if this is possible with Blox. I am not a Blox Expert :) We use the Advanced Filters plugin from Ravid_PaldiTeam / Benji_PaldiTeam which does exactly this: https://www.paldi.solutions/sisense-plugins/advanced-filters They have a free trial and Ravid/Benji are always happy to help. Hamza33Views0likes0CommentsRe: Data Security Synchronization between Elasticubes
Hey MikeGre , Great find. I took a look at it and...; It works with custom code e.g. jupyter notebooks. This is implemented within the elasticube functionality. You can create a cube, select this notebook and it will ran with every cube refresh. Cube refreshes you can schedule. You could also implement this in the source cube and everytime it refreshes it will copy the DS to another cube. It doesnt seem it does a lot of validations. I only see it validates cubes exists or not Yes. It should work. Linux only btw Hamza28Views2likes1CommentRe: Data Security Synchronization between Elasticubes
Hey MikeGre , This is not possible. You could manually export the updated model and import it as the older model, e.g. export elasticube B and import it as elasticube A. However this does mean that the elasticubes are also the same in regards to tables and fields etc. Otherwise you could use a python script to pull the datasecurity from B and push it to A. Hamza32Views1like0CommentsRe: How to achieve a Booking Summary by Day of the Week by Hour of the day?
Hey Astroraf , As far as i know this will not be possible on the front-end. If it is possible to change it in the datamodel, then you can change de weekday labeling to something like 1. Monday, 2. Tuesday etc. With a javascript you can hide 1. etc. Another option would be to use a formula per weekday field. So per weekday add something like the following: contribution(booking_id, weekday) . Filter weekday on monday. CLick OK and rename the formula to monday. Repeat for every weekday. Now you can sort them in any order you want. Hamza42Views1like0Comments