sneak
Cloud Apps
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Setting Up SSO SAML 2.0 With Azure AD
RJ_Ponzio - I have found this can be configured by using multi-tenant config in Sisense (under Admin > User Management > Tenants). However, there are practical reasons why it didn't work for my use case, because the multiple different tenants all needed access to the same dashboards and data models. The Sisense multi-tenant architecture, as I understand it, intentionally separates those elements between tenants so that one deployment can be used to serve multiple distinct organizations.1.1KViews0likes0CommentsRe: Auth0 SAML SSO: Can we configure a user to be part of multiple groups?
Hello! I'm not a Sisense rep, but have been working with the platform for the last 4 years or so. I can confirm that SSO accounts can be assigned to multiple user groups (Team A, Team B, etc.), but I am not aware of a way to set multiple roles (Viewer, Designer, Data Designer, Data Admin, Admin) for a single user/account. However, even a user who has Designer role will not automatically have permission to design on every Dashboard. The design permissions for individual dashboards are still delegated by higher roles (admin, data admin, and dashboard owner). The same is true for Data Model design permissions; even a Data Designer cannot manipulate a given Data Model unless they are specifically granted permissions by a higher role account. So, effectively, if you limit your power users with Designer and Data Designer permissions, they will operate as a Viewer of many things and a Designer of only those things they are granted explicit permission to. Keep in mind, Data Admin and Admin roles have additional ability to explore and grant themselves permissions to things that were not previously explicitly granted to them, hence the "admin" designation. Hope this helps!1.5KViews1like0CommentsRe: What is the alternative to LENGTH function when building a dashboard?
I don't believe this is possible out of the box, though you may be able to use some Javascript to achieve the desired functionality. However, what I would recommend is to create a custom table in the elasticube (rather than a custom column, if you do not want to muddy the perception of the prod database tables). In your custom column, you can extract only the id of records which match the conditions (less than 32 characters in length), create a relationship from the custom table to the primary table on "id", then use the id field from the custom table to apply a filter to the widget that you want to affect.1.4KViews0likes0CommentsRe: Dashboard filter not affecting Table type widget
Try verifying that the filter behavior of the widget is set to "slice/filter" rather than "highlight" it may be that the rows you're filtering to are simply being highlighted and are not in the current view of the table, making it seem like nothing happened. From the widget filter panel, select "slice/filter":2.5KViews0likes1CommentRe: Force Pivot Table Rows/Columns to Show When No Data Present
I considered creating fake records that have null values for either Likelihood or Consequence, then force-hiding those N/A rows/columns from the pivot table. I had mild success with this method for preserving the 5x5 matrix, but it is messy and not a robust long-term solution. Was hoping someone with more JS experience than me might think of a straightforward, if not simple, solution.1.7KViews0likes0CommentsForce Pivot Table Rows/Columns to Show When No Data Present
I'm working on a custom pivot table implementation that has rules for coloring to recreate the concept of a risk matrix. Here's the code: widget.on('domready', function(sender, ev) { var widgetId = 'widget[widgetid*=' + sender.oid + ']'; //console.log('START') var i = 0 $('div.table-grid__content', widgetId).parent().parent().parent().css('border', 'black solid 1.5px') $('div.table-grid__content', widgetId).parent().css('border', 'black solid 1.5px') $('div.table-grid__content', widgetId).parent().css('text-align', 'center') $('tr', widgetId).each(function() { if ($(this).index() == 7) { $(this).hide() } else { $(this).css("display", "") } if ($(this).index() > 1) { $(this).find('td', widgetId).each (function() { if ($(this).index() == 1) { $(this).css('background-color', 'green') $(this).css('color', 'white') } if ($(this).index() == 2) { if ($(this).parent().index() > 4) { $(this).css('background-color', 'green') $(this).css('color', 'white') } else { $(this).css('background-color', 'yellow') $(this).css('color', 'black') } } if ($(this).index() == 3) { if ($(this).parent().index() < 3) { $(this).css('background-color', 'red') $(this).css('color', 'black') } else if ($(this).parent().index() < 6) { $(this).css('background-color', 'yellow') $(this).css('color', 'black') } else { $(this).css('background-color', 'green') $(this).css('color', 'white') } } if ($(this).index() == 4) { if ($(this).parent().index() < 4) { $(this).css('background-color', 'red') $(this).css('color', 'black') } else if ($(this).parent().index() < 6) { $(this).css('background-color', 'yellow') $(this).css('color', 'black') } else { $(this).css('background-color', 'green') $(this).css('color', 'white') $(this).css('fontSize', '24') } } if ($(this).index() == 5) { if ($(this).parent().index() < 5) { $(this).css('background-color', 'red') $(this).css('color', 'black') } else if ($(this).parent().index() < 7) { $(this).css('background-color', 'yellow') $(this).css('color', 'black') } else { $(this).css('background-color', 'green') $(this).css('color', 'white') } } if ($(this).parent().index() >= 7) { $(this).css('background-color', 'white') $(this).css('color', 'black') } }) } }); //console.log('FINISH') }) The above code works and produces the table as desired as seen here: However, when an applied filter causes some rows/columns to not have any data present, they are hidden, which messes up the whole matrix. I need it to remain as a 5x5 matrix, regardless of what records are filtered out. Here's what it looks like when some records are filtered out (notice that Consequence = 4 and Likelihood = 2 are now missing from the table). Here is what the data panel looks like for the pivot table: Any ideas on some javascript / jQuery that can override the default Pivot behavior and ensure the Rows/Columns stay visible even no applicable data fits in those cells? Thanks in advance for your help. Hopefully this could be re-used and improved for others as well, to create Risk Matrix widgets.1.7KViews0likes1CommentRe: Pop up on Dashboard Load
Try adding a simple JavaScript snippet in the dashboard initialization event: dashboard.on('initialized', function () { alert('Updates in Progress'); }); But keep in mind, while the alert is popped up, the actual loading may take a backseat. I haven’t tested this particular use case, but this should give you a starting point. Let me know how it goes!3.8KViews0likes1CommentRe: Is there a way to pass specific filters for Jump to Dashboard?
From JTD Technical Details page: Note: When excluding the date dimension using parameter excludeFilterDims, (Calendar) must be used or the exclusion will not work. Example:[Table.Dimension(Calendar)] I remembered reading this on the JTD docs. So, since you're excluding a date, try: excludeFilterDims:"[NOTES.OldestNoteDateOfVisit(Calendar)]" I haven't done this use case before, so let me know if that works. Play around with the syntax a little if need be.7KViews0likes0Comments