Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: CDE, MDX and SQL with user visibility

  1. #1

    Post CDE, MDX and SQL with user visibility

    I'm using Pentaho CDE and many users.
    mdx with extracting data follows the profiling set.
    with sql extracts all the data and are not those of user visibility.
    What can I enter as a condition where will respect for profiling? (Where ${ })

    how can I insert the condition: (Where $ {<user login in>}).
    Which variable cde registered user login in?

    Thanks in advance
    Last edited by ettorecoletti; 02-17-2014 at 03:20 AM.

  2. #2
    Join Date
    Dec 2013



    I didn't test it myself, but I think you can create a Simple Parameter say pUserID and then create a function in your chart/table/query/.. component with something like this: function userID() {pUserID =Dashboards.context.user; } Then in your MDX (or SQL) query you can use it like: WHERE {[SOME MDX].[${pUserID}]}

    With Dashboards.context.roles you can fetch all the roles assigned to that user.


  3. #3


    Thank you,
    it's OK.
    Dashboards.context.user and Dashboards.context.roles


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.