US and Worldwide: +1 (866) 660-7555
Results 1 to 9 of 9

Thread: Dynamic Schema

  1. #1

    Default Dynamic Schema

    Hi All,
    I have a question about the Dynamic Schema in Mondrian, I need to create 500 roles maybe more. I have been reading the documentation and found this [1][2] but is possibole to find any sample or one how to .
    I am using saiku, is a problem?
    Thanks

    [1] http://mondrian.pentaho.com/api/mondrian/spi/DynamicSchemaProcessor.html
    [2] http://mondrian.pentaho.com/document...e_xmla_servlet
    Last edited by rafaeltaptap; 06-10-2013 at 07:59 AM.

  2. #2

    Default

    My solution is to manage 2 parts: the cube definition part and the role part, then the system merge 2 parts together. That way if you modify roles, you can recreate all OLAP files easily.

  3. #3
    Join Date
    Sep 2011
    Posts
    26

    Arrow

    You have to implement and compile (.jar) a Java class like this:

    Code:
    public class CustomDynamicSchema extends FilterDynamicSchemaProcessor implements DynamicSchemaProcessor {
    public CustomDynamicSchema() {
    
    }
    @Override
    public String filter(String schemaUrl, Util.PropertyList connectInfo, InputStream stream) throws Exception {
    String schema = super.filter(schemaUrl, connectInfo, stream);
    // Modify schema here
    return schema;
    }
    }
    You have to add the .jar in WEB-INF/lib and if you are using Saiku also in pentaho-solutions/system/saiku/lib.

  4. #4

    Wink Dynamic Schema

    Hi xgumara,
    Thanks this information is amazing but i have a question do you know any sample ?
    Thanks for your support
    Last edited by rafaeltaptap; 06-14-2013 at 07:15 AM.

  5. #5

    Default

    Hi,
    I am implement the class, but don't work the log, class and configuration file : https://gist.github.com/sowe/5798002
    Thanks

  6. #6
    Join Date
    Sep 2011
    Posts
    26

    Default

    What configuration do you have in pentaho-solutions/system/olap/datasources.xml?

  7. #7

    Default

    Hi xgumara:
    Thanks i'm resolve the problem , thanks for your tip

  8. #8

    Default

    Hi Rafaeltaptap,

    Could you please help, how did you solve the problem? My case is similar, based on roles the view of a person should change. The person cannot access the fields not meant for him/her.

    I am also using saiku

    Thanks,
    Ramya

  9. #9

    Default

    Please someone help...I need to create such schemas with my latest project.

    Thanks,
    Ramya

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
  •