Pentaho/Mondrian: how to set "dynamic roles" for logged user?
<p>I want to filter <em>sales data for Agent Dimension</em>. One Agent can log in Pentaho and see only his data and related sub-agent (hierarchy agent-sub agent is defined in a <code>closure table</code>). I can't do a Role for every Agent because the dimension is SCD type 2 (so the structure/relation between agent/sub-agent can vary in time).</p>

<p><em>How I can obtain this particular filter/role schema access?</em> </p>

<p>Any help is appreciated, Thanks in advance.</p>

<p><strong>EDIT:</strong>
<a href="https://github.com/gioma68/mondrian-dsp" rel="nofollow">Here</a> you can find a sample code for my solution (ant project on Github)</p>