Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: dynamic cubes...

  1. #1
    Join Date
    Mar 2003
    Posts
    207

    Default dynamic cubes...

    Would it be feasible to generate the definition xml (eg foodmart.xml) files on the fly, say with a servlet for example? this would allow you to programatically specify roles and dimensions available in a given cube depending on e.g: the user authenticated etc..
    is there some overhead that I don't know about that would make this a problem, or are the cubes in any case generated on a session basis?
    Cheers
    Ati.

  2. #2
    Join Date
    Nov 1999
    Posts
    1,618

    Default RE: dynamic cubes...

    Yes, it would. Two approaches are possible.
    First, since the catalog is a URL, you could make it a URL -- say a JSP page -- which generates an XML document according to supplied parameters.
    Or you could use code in the application server which first establishes a Mondrian connection, then uses the programmatic API to create or alter the schema. Schema.createDimension() is an example of the kind of method you can call.
    Roles are a great way of customizing the schema depending upon who is logged in. Since Mondrian does not support authentication itself, if you allow end-users to supply the full connect string, they would easily be able to circumvent the access-control offered by roles. So, as you guessed, the a better way to use roles is to use programmatic code which figures out the appropriate role for the authenticated user, then applies the role to the connection.

  3. #3
    Join Date
    Mar 2003
    Posts
    207

    Default RE: dynamic cubes... and servlets and...Q/A?

    I need to dynamically change the roles used by users, and had planned to use a generate role name with different permissions for each user (custom generated, based on userid). Problem is that the jpivot's catalogURI seems to be only willing to accept a file - local URI....
    I can change it (been doing a lot of jpivot mods lately), but if I change it, would mondrian accept a catalog URI like:
    "
    http://localhost/Olap/servlet/XMLgen
    "
    where XMLgen is a servlet which returns the XML with the appropriate generated role?
    Ati

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.