Hitachi Vantara Pentaho Community Wiki
Child pages
  • 06. Adding Row Level Security to a Pentaho Metadata Model

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Wiki Markup
This example defines an MQL Formula for three different roles.  The Admin Role has full row visibility, the Sales and Engineering Roles may only see data that joins to rows with their particular department. (The syntax is \[PentahoDoc:business_table.business_column\] = value).

Role

Constraint

Admin

TRUE()

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="2feeec7cf4412877-45737326-4bad4e5c-8575ade9-c7b8e335d1f9e9dabbc82487"><ac:plain-text-body><![CDATA[

Sales

[PentahoDoc:BT_OFFICE.BC_DEPARTMENT]="Sales"

]]></ac:plain-text-body></ac:structured-macro>

<ac:structured-macro ac:name="unmigrated-wiki-markup" ac:schema-version="1" ac:macro-id="246d905cc2ef4106-4ca9a2ff-4bd047c4-944f9f1c-4c16835c0d3396b0de76972a"><ac:plain-text-body><![CDATA[

Engineering

[PentahoDoc:BT_OFFICE.BC_DEPARTMENT]="Engineering"

]]></ac:plain-text-body></ac:structured-macro>

...