Auto Add Filter Based On User

Comments

14 comments

  • Avatar
    Keith Johnson

    This is something that have wanted for quite a while.  I've tested it, and it seems to automatically attach itself to every dashboard using this EC.  Is that correct?  We only need it on some of the dashboards.

    1
    Comment actions Permalink
  • Avatar
    Joseph Peters

    Is it possible to use this for emailed dashboards?  I want to be able to send users information about their specific department in a daily email and can't use data security.

    1
    Comment actions Permalink
  • Avatar
    John Fisher

    How would I use this with two seperate cubes and two dashboards?  I have been able to get it to work with one.

    0
    Comment actions Permalink
  • Avatar
    John Fisher

    We got this working with two elasticubes.  You just copy the config section again in the .js file with the new settings.  In order to get it to work you will need to sign-out of the dashboad and back in.  Refreshing the web page will not work.  We also reset IIS too.

    0
    Comment actions Permalink
  • Avatar
    Keith Johnson

    Is it possible to use this type of mechanism in a widget script instead of a plugin?

    0
    Comment actions Permalink
  • Avatar
    John Fisher

    Is there a way to get the filter to default to "Include all" if there is no value provided from the table?

    0
    Comment actions Permalink
  • Avatar
    John Fisher

    Is it possible to use this to setup a dependent filter?

    0
    Comment actions Permalink
  • Avatar
    Robert Hauenstein

    This broke with 7.2. I recieve the following error:

    POST http://url-here:port/jaql/query 404 (Not Found)

    Does anyone have any ideas?

    0
    Comment actions Permalink
  • Avatar
    Ronen Avidor

    Hi Robert,

    Just uploaded an updated version, please download and give it a try/

    Ronen

    0
    Comment actions Permalink
  • Avatar
    Robert Hauenstein

    Thank you Ronen!

    0
    Comment actions Permalink
  • Avatar
    Eloy Meira

    Hi,

    I was able to use this to create a custom filter but how do you create more than one? I tried different ways but could not add more filters.

     

    This below is the one I created and it works but we need more filters.

    // Define config settings
    var config = {
    "maxResults": 3000,
    "filters": [
    {
    "server": "localhost",
    "elasticube": "Sales360",
    "filter": {
    "dim": "[users.sales_org]",
    "datatype": "text",
    "title": "User_Email"
    },
    "queryMatch": {
    "dim": "[users.sales_user]",
    "datatype": "text"
    },
    "querySelection": {
    "dim": "[users.sales_org]",
    "datatype": "text"
    },
    "type": "first"
    }
    ]

    }

     

     

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi (Edited )

    Hi Everyone, I'm not a Sisense employee but rather an implementation partner, but I'm modifying this plugin to support several requirements of one of our clients so I can answer several questions people asked here. Feel free to reach out directly if you have any further questions to ravid@paldi.solutions 

    @Keith Johnson

    1) The plugin doesn't support configuration at the dashboard level, only the cube level. We have developed this for our client so feel free to reach out and I'll guide your developer on where hey should modify the code to support this request. modify 

    2) You can modify the code so it will run at the widget level but I highly recommend against that as it won't be very stable. In case you need it to run at the widget level I would suggest modifying the script to include configuration on a widget-level basis. 

    @Joseph Peters

    No, it is not possible to use this in Sisense email reports. Even if you have a developer to work on it as technically you don't have a way to interact with Sisense reporting configurations. 

    With that in mind, we have a developed an in-house tool that does exactly that and much more (for example you can set on a per-user  basis the filter, the email title the email content, the frequency and you can even choose which widgets to be added to the email even if they are originated from different dashboards). 

    Feel free to reach out for more details about the tool

     

    @John Fisher  and @Eloy Meira

    - You can setup many filters, on different cubes

    - different dashboards will be impacted only if there are configurations for their associated cubes 

    - To do this, you need to add another Filter entry to the filters array. It should be something like this: 

    var config = {
    "maxResults": 50,
    "filters": [
    {
    ## your 1st filter configurations
    },
    {
    ## your 2nd filter configurations
    },
    ]
    }

     

    @John Fisher

    Yes, it is possible to add and include all" as a fallback or any other logic that you would like to have. Feel free to reach out and I'll guide your developer on where they should modify the code to support this request

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    Anyone experiencing issues with the plugin after upgrading to 7.3? 

     

    the plugin worked fine on 7.2 but after upgrading to 7.3 we get the below error: 

    "Failed to load resource: the server responded with a status of 404 (Not Found)" 

    When opening the console, the full output of the reply object for the request to the cube is :

    Could you please fix the plugin to work 7.3

    Other than that, anyone else is experiencing issues with exporting dashboards to PDF? We're seeing an issue where ImageWidgets are not being rendered into the PDF when exporting the dashboard and it is fixed when de-activating the plugin (That is the reason why we upgraded to Sisense 7.3 in the first place as the support told us that it would solve it, it didn't. And instead - now the plgin doesn't work.) 

    0
    Comment actions Permalink
  • Avatar
    Ravid Paldi

    Quick update - it seems that the issue is fairly simple. 

    In the init.js file, simply modify the below line to your version: 

    {code}

    if (prism.version.startsWith("7.2")) {
    queryUrl = "/api/datasources/" + elasticube + "/jaql"
    }

    {code}

     

     

    0
    Comment actions Permalink

Please sign in to leave a comment.