Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Control/filter query results using SQL instead of MDX queries

  1. #1
    Join Date
    Dec 2016
    Posts
    19

    Default Control/filter query results using SQL instead of MDX queries

    Hello,

    in my company, we have a couple of dashboards whose data come from MDX queries. In the mondrian schema file, we have defined several roles and associated each user to one or more roles according to the business rules. As we use MDX queries, the results from the queries are filtered according to the user roles.

    However, I'll need to replace some MDX queries with SQL queries, and I don't want to control and filter the data in the front-end for security reasons.

    I've found this post, in which the OP asks for how to pass the user role as a private parameter. But my question is: how can I control and filter the query results using this parameter in my SQL query?
    How can I emulate the cube and hierarchy access restrictions in the SQL queries corresponding to the current MDX queries of the dashboards?

    Thank you!
    Best regards,

    Bruno
    Last edited by amaralbf; 03-16-2017 at 08:26 AM.

  2. #2

    Default

    Hi all,

    Some answer?

    Thanks in advance.

  3. #3
    Join Date
    Jan 2015
    Posts
    18

    Default

    We do something similar passing information across to enable security. You can di it by passing the session value into the SQL as you would any other parameter.

    Name:  2017-08-24_13-52-59.jpg
Views: 38
Size:  7.3 KB

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.