Auto Add Filter Based On User

Comments

11 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.

  • 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.

  • 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.

  • Avatar
    Keith Johnson

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

  • 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.

  • 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?

  • Avatar
    John Fisher

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

  • 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?

  • Avatar
    Ronen Avidor

    Hi Robert,

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

    Ronen

  • Avatar
    Robert Hauenstein

    Thank you Ronen!

  • 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"
    }
    ]

    }

     

     

Please sign in to leave a comment.