<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
        {mso-style-priority:99;
        mso-style-link:"Balloon Text Char";
        margin:0in;
        margin-bottom:.0001pt;
        font-size:8.0pt;
        font-family:"Tahoma","sans-serif";}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
span.BalloonTextChar
        {mso-style-name:"Balloon Text Char";
        mso-style-priority:99;
        mso-style-link:"Balloon Text";
        font-family:"Tahoma","sans-serif";}
.MsoChpDefault
        {mso-style-type:export-only;}
@page WordSection1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
        {page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">I’m in the process of implementing programmatic roles in our adhoc reporting tool. We’re currently running Mondrian stand alone against our OLAP schema and we would like to dynamically create roles for each user.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The problem I’m having right now is with the granting of access to specific objects in the schema (schema, cubes, dimensions, hierarchies, & members). Is there a way to convert a olap4j metadata object (Schema, Cube, Dimension, etc) back
to a legacy Mondrian olap object?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The reason I ask is the grant method on the RoleImpl class only accepts the legacy Mondrian.olap.* objects. Should I use a legacy Mondrian.olap.connection to lookup the objects that I want to grant access to?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks in advance for your help.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"><br>
<b>Andrew Yim</b><br>
Software Engineer<br>
<br>
</span><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0072CE">Truven Health Analytics</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"><br>
</span><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A">O:</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"> 734.913.3174<br>
</span><b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A">M:</span></b><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"> 734.347.8669<br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0072CE">andrew.yim@truvenhealth.com</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"><br>
</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#0072CE">truvenhealth.com</span><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:#25282A"><br>
<br>
<img width="300" height="51" id="Picture_x0020_1" src="cid:image001.gif@01CEE5D2.D53869A0" alt="Truven Health Analytics"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>