Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: USER() and ROLES() supported in Role Based Constraints?

  1. #1
    Join Date
    Nov 2010
    Posts
    19

    Question USER() and ROLES() supported in Role Based Constraints?

    Can the functions USER() and ROLES() be used in Role Based Constraints?

    The documentation is vague on this point; they're mentioned in Global Constraints, but not Role Based Constraint

    When I attempt to use either:

    IN([BT_USERID_2_SHOPDATA.BC_USERID_2_SHOPDATA_CUST_ID]; USER())
    or
    IN([BT_USERID_2_SHOPDATA.BC_USERID_2_SHOPDATA_CUST_ID]; ROLES())

    I get an error such as:
    ParentException: org.pentaho.pms.core.exception.PentahoMetadataException: SqlOpenFormula.ERROR_0014 - Function ROLES is not supported.

  2. #2

    Default

    have you found a solution for this? i'm having the same problem..=/

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.