<html>
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi,<br>
<br>
I've the following start schema:<br>
<br>
<b><span style='font-weight:bold'>tables</span></b>: users [userid, username]
(dimension table), <br>
groups [groupid, groupname]
(<u>not a dimension table</u>),<br>
<b><span
style='font-weight:bold'>user_group</span></b> [id, userid, groupid] (<u>not a
dimension table</u>), - <i><span style='font-style:italic'>A mapping table
between users and groups</span></i><br>
timeDimension [id,
year, month_of_year, day_of_month] (dimension table)<br>
fact_url_hits [id,
userid, timeid, hits], (fact table)<br>
<br>
The MDX query is: <br>
<br>
<b><span style='font-weight:bold'>SELECT {[Measures].[URL Hits]} ON COLUMNS,
NON EMPTY {[Time].[2008].Children} ON ROWS FROM [MondrianTest] WHERE [DimUsers].[Group
Name].[<font color=red><span style='color:red'>group5</span></font>]</span></b><br>
<br>
Here <font color=red><span style='color:red'>group5</span></font> is a value
from <b><span style='font-weight:bold'>groupname</span></b> column in <b><span
style='font-weight:bold'>groups</span></b> table.<br>
<br>
I'm trying to define the <b><span style='font-weight:bold'>DimUser</span></b>
dimension as following:<br>
<br>
<Dimension name="DimUsers" foreignKey="userid"><br>
<Hierarchy hasAll="true" primaryKey="userid"
primaryKeyTable="users"><br>
<Join leftKey="userid" leftAlias="user_group1"
rightAlias="Users" rightKey="userid"><br>
<Join leftKey="groupid"
leftAlias="user_group" rightAlias="groups" rightKey="groupid"><br>
<Table name="user_group"/><br>
<Table name="groups"/><br>
</Join><br>
<Table
name="users"/><br>
</Join><br>
<Level name="User Name"
table="users" column="username" type="String"
uniqueMembers="false"/><br>
<Level name="Group Name"
table="groups" column="groupname" type="String"
uniqueMembers="false"/><br>
</Hierarchy><br>
</Dimension><br>
<br>
I'm getting following exception:<br>
<br>
Exception in thread "Thread-0" java.lang.UnsupportedOperationE<wbr>xception<br>
at mondrian.rolap.RolapCubeHierarc<wbr>hy.extractNewAliases(RolapCubeH<wbr>ierarchy.java:179)<br>
at mondrian.rolap.RolapCubeHierarc<wbr>hy.extractNewAliases(RolapCubeH<wbr>ierarchy.java:176)<br>
at mondrian.rolap.RolapCubeHierarc<wbr>hy.<init>(RolapCubeHierarchy<wbr>.java:88)<br>
at mondrian.rolap.RolapCubeDimensi<wbr>on.<init>(RolapCubeDimension<wbr>.java:48)<br>
at mondrian.rolap.RolapCube<wbr>.getOrCreateDimension(RolapCube<wbr>.java:658)<br>
at mondrian.rolap.RolapCube.<init<wbr>>(RolapCube.java:145)<br>
at mondrian.rolap.RolapCube.<init<wbr>>(RolapCube.java:175)<br>
at mondrian.rolap.RolapSchema<wbr>.load(RolapSchema.java:438)<br>
at mondrian.rolap.RolapSchema<wbr>.load(RolapSchema.java:335)<br>
at mondrian.rolap.RolapSchema.<wbr><init>(RolapSchema.java:226)<br>
at mondrian.rolap.RolapSchema.<wbr><init>(RolapSchema.java:79)<br>
at mondrian.rolap.RolapSchema<wbr>$Pool.get(RolapSchema.java:923)<br>
at mondrian.rolap.RolapSchema<wbr>$Pool.get(RolapSchema.java:732)<br>
at mondrian.rolap.RolapConnection<wbr>.<init>(RolapConnection.java<wbr>:152)<br>
at mondrian.rolap.RolapConnection<wbr>.<init>(RolapConnection.java<wbr>:83)<br>
<br>
<br>
First thing which I want to know is whether I can incorporate a mapping table (user_group
in this case) in mondrian schema or not. If so, what is the problem in my DimUser
definition?<br>
<br>
Thanks,<br>
<font color="#888888"><span style='color:#888888'>-Madhav</span></font></span></font></p>
</div>
</body>
</html>