Hitachi Vantara Pentaho Community Forums
Results 1 to 13 of 13

Thread: New Analysis View wizard and Mondrian roles

  1. #1

    Question New Analysis View wizard and Mondrian roles

    Hi all,

    How do I use Mondrian roles with “New Analysis View” wizard?
    In version 1.7, the developer creates a “solution” with the “Analysis view” component passing a “Role” parameter and everything is ok.

    Now, in ver. 3.5, this new wizard creates a problem in the use of Mondrian roles. Have anyone a tip?

    []s
    Mauro

  2. #2

    Default

    No, New Analysis is no different, passing a role from a session variable to an xaction located in solution/system/mondrian/...

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3

    Default

    Tom,

    Thanks for the rapid response.


    I think there is some work to do: alter analysis_view_template.xml, build some role register, get role from that register (like in this thread http://forums.pentaho.org/showthread.php?t=73843). Correct?

    Regards,
    Mauro

  4. #4

    Default

    Yeah so the basic workflow goes like this:

    User logs in, xaction is processed at login that assigns a session variable called role(or similar) with the rolename, this is then captured in the new analysis xaction and then passed to the pivot view component which includes it in the mondrian call.

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  5. #5
    Join Date
    Mar 2010
    Posts
    2

    Default Should work with Mondrian-UserRoleMapper?

    Hi,
    Based on information on http://jira.pentaho.com/browse/BISERVER-3891
    one should also be able to use the roles already defined on the BI platform if the Mondrian roles carry the same name.
    I tried activating the bean Mondrian-One-To-One-UserRoleMapper in the file pentahoObjects.spring.xml, but I cannot get it to work.
    Does anyone know if there are more parameters needing changes?

    Thanks in advance!
    Per

    For info: my environment lies on a Windows Server 2003 and I'm using the BIserver CE 3.5.2 (and the provided Analysis View) and the Schema Workbench 3.1.6 (for cube generation, role setting and publishing to biserver)

  6. #6
    Join Date
    Oct 2007
    Posts
    26

    Default

    There's no more parameters or setting you need to change other than to un-comment the role mapper that you want to use. I've tested this extensively with Analyzer and it works fine. I don't know about Analysis Views.

  7. #7
    Join Date
    Mar 2010
    Posts
    2

    Default

    Thank for your reply Benny, but I'm trying to make this work in the Community Edition and I believe Analyzer is only available in the Enterprise Edition.
    My question therefore remains - how can I make the Mondrian-UserRoleMapper work in the Community Edition?

    /Per

  8. #8
    Join Date
    Oct 2007
    Posts
    26

    Default Replace the file analysis_view_template.xaction

    Try to replace the file
    pentaho-solutions/system/mondrian/analysis_view_template.xaction

    with the one I attached.
    This works for me in the Community Edition.
    I have not 'invented' this myself, I found a working example with the javascript and used that to construct this new template.

    Hope it works for you,

    Edwin
    Attached Files Attached Files

  9. #9

    Default

    3.5.2 has a mondrian role mapper build into solution/systempentahoObjects.thingy which will do all that for you
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  10. #10
    Join Date
    Oct 2007
    Posts
    26

    Default Mapper was tried, but I had an issue in CE

    I used the role mapper in a client situation with Analyzer and the Enterprise Edition and it worked fine. But when I made a 'New Analysis View' in that setup, the role security didn't work.
    I encounter the issue in both the Enterprise Edition (on Ubuntu) as well as in Community Edition 3.5.2 on Ubuntu 9.1 and Windows 7, both 64 bit.
    I used the first variant of the mapper, the one that assumes that the BI roles are also present in Mondrian.
    Maybe I have some setup wrong.

  11. #11

    Default

    I only tried direct role = role mapping but that did work on 3.5.2 CE.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  12. #12

    Default

    also tried MondrianOneToOneUserRoleListMapper but didn't work ...

  13. #13
    Join Date
    Aug 2008
    Posts
    16

    Default

    A exemple of analysis_view_template.xaction and other untitled.xaction setting role session parameter
    Last edited by diego.muriel; 09-16-2010 at 01:56 PM.
    --
    Diego Muriel
    Brasil-SP

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.