mdx - Openi Plugin for Pentaho not working with mondrian roles -


i have mondrian schema file role configuration, restricting role central region.

<role name="central">     <schemagrant access="all">      <cubegrant cube="quadrant analysis" access="all">        <hierarchygrant hierarchy="region" access="custom" rolluppolicy="partial">           <membergrant member="[region].[central]" access="all">           </membergrant>        </hierarchygrant>      </cubegrant>     </schemagrant> </role>

in pentaho, have user central_user roles authenticated , central.

also, uncommented mondrian-one-to-one-userrolemapper in pentahoobjects.spring.xml

i evaluating openi , saiku plugins pentaho.

in saiku plugin, analysis report correctly filters , shows central region.

but in openi plugin, report shows regions.

is there other additional settings required openi make pass role information mondrian?


Comments

Post a Comment

Popular posts from this blog

Java sticky instances of class com.mysql.jdbc.Field aggregating -

i noticed (via jmap+jhat) app leaking storing many instances com.mysql.jdbc.field  class - double checked code make sure closing preparedstatements, find few missing didn't change outcome. - preparedstatement created , closed right away - several others created @ start , reused many times - using org.apache.tomcat.jdbc.pool.datasource connection pool what can cause type of behavior? are closing of preparedstatements / result sets using: preparedstatement stmt (possible assignment here); try { // work prepared statement resultset rs; try { while (rs.next()) ... // process results } { rs.close(); } } { stmt.close(); } so guarantee result sets closed when finished (regardless of exceptions) , statements closed (regardless of exceptions)? there other ways write that, idea same. if you're doing of properly, unless have many references it's taking inordinate amount of memory, it's ok , nothing needs done it.
Read more