<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I can't agree with you about nullParentValue attribute -- this one is
used to indicate which member is a root (real root, not the allmember).<br>
Our hierarchy has a single root and it has "-1" in PARENTID column.<br>
However, I removed it and tried to drill into AllMember -- no effect.<br>
<br>
I removed hideMemberIf -- no effect.<br>
<br>
ANCESTORID in Oracle DDL is defined as Integer, but probably returned
in JDBC metadata as NUMBER (one of these funny Oracle tricks).<br>
I have checked SQL: no difference when typing "1000.0" or "1000".<br>
<br>
The first things which seems to be very surprising is why it logs that
query returns 0 rows, while it doesn't?<br>
What is the logic around this output? Doesn't it simply return the
number of rows in ResultSet?<br>
<br>
Also I noticed a recent bug: <a class="moz-txt-link-freetext" href="http://jira.pentaho.com/browse/MONDRIAN-767">http://jira.pentaho.com/browse/MONDRIAN-767</a><br>
Although it talks about virtual cubes, the description looks very
similar to my case...<br>
<br>
Thanks.<br>
<br>
Anton <br>
<br>
01.07.2010 3:32, Julian Hyde wrote:
<blockquote cite="mid:B3724247CC174AE4868D9DC854D58294@mackerel"
type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<meta name="GENERATOR" content="MSHTML 8.00.6001.18928">
<div><span class="030003123-30062010"><font color="#000080"
face="Lucida Sans" size="2">The attributes hideMemberIf and
nullParentValue are usually only used in ragged hierarchies. Do the
problems go away if you remove them?</font></span></div>
<div><span class="030003123-30062010"></span> </div>
<div><span class="030003123-30062010"><font color="#000080"
face="Lucida Sans" size="2">I notice that it is joining to '... =
1000.0'. Is ANCESTORID an integer in the database? Does that query
return different results if you change 1000.0 to 1000?</font></span></div>
<div><span class="030003123-30062010"></span> </div>
<div><span class="030003123-30062010"><font color="#000080"
face="Lucida Sans" size="2">Julian</font></span></div>
<br>
<blockquote
style="border-left: 2px solid rgb(0, 0, 128); padding-left: 5px; margin-left: 5px; margin-right: 0px;">
<div dir="ltr" class="OutlookMessageHeader" align="left"
lang="en-us">
<hr tabindex="-1"> <font face="Tahoma" size="2"><b>From:</b>
<a class="moz-txt-link-abbreviated" href="mailto:mondrian-bounces@pentaho.org">mondrian-bounces@pentaho.org</a> [<a class="moz-txt-link-freetext" href="mailto:mondrian-bounces@pentaho.org">mailto:mondrian-bounces@pentaho.org</a>] <b>On
Behalf Of </b>Anton Nikitin<br>
<b>Sent:</b> Wednesday, June 30, 2010 5:49 AM<br>
<b>To:</b> <a class="moz-txt-link-abbreviated" href="mailto:mondrian@pentaho.org">mondrian@pentaho.org</a><br>
<b>Subject:</b> [Mondrian] ParentChild hierarchy in Mondrian 3.2<br>
</font><br>
</div>
I am experiencing some difficulties after upgrading from 3.1.2 to 3.2.0
with parent-child hierarchy.<br>
<br>
I have a hierarchy defined as follows:<br>
<br>
<tt> <Dimension name="Liquidity Risk Group"><br>
<Hierarchy hasAll="true" allMemberName="All Nodes"
primaryKey="NODEID"><br>
<Table name="LIQUIDITYRISKGROUP"/><br>
<br>
<Level approxRowCount="100" name="Risk Group"
column="NODEID" nameColumn="RISKGROUPNAME"<br>
parentColumn="PARENT" nullParentValue="-1"
type="Numeric" uniqueMembers="true"<br>
levelType="Regular" hideMemberIf="Never"><br>
<Closure parentColumn="ANCESTORID"
childColumn="NODEID"><br>
<Table name="RISKGROUPCLOSURE" /><br>
</Closure><br>
</Level><br>
</Hierarchy><br>
</Dimension></tt><br>
<br>
And with such definition it returns empty cells if MDX includes any
member from this hierarchy other than AllMember.<br>
If I comment out closure definition it starts to work correctly.<br>
<br>
During analysis I found the following in Mondrian log:<br>
<tt><br>
<br>
[2010-06-30 16:26:51,896] [DEBUG] (RolapUtil )
Segment.load: executing sql [select "RISKGROUPCLOSURE"."ANCESTORID" as
"c0",
sum("DAILYCFBYRISKGROUPHIERARCHY"."STRESSCFAMOUNTPLUS"+"DAILYCFBYRISKGROUPHIERARCHY"."STRESSCFAMOUNTMINUS")
as "m0" from "<br>
RISKGROUPCLOSURE" "RISKGROUPCLOSURE", "DAILYCFBYRISKGROUPHIERARCHY"
"DAILYCFBYRISKGROUPHIERARCHY" where
"DAILYCFBYRISKGROUPHIERARCHY"."NODEID" = "RISKGROUPCLOSURE"."NODEID"
and "RISKGROUPCLOSURE"."ANCESTORID" = 1000.0 group by
"RISKGROUPCLOSURE"."ANCESTORID"], exec 15 ms<br>
<br>
[2010-06-30 16:26:51,896] [DEBUG] [/lrm230] [OTIDO\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:aln@192.168.1.171">aln@192.168.1.171</a>] -
(RolapUtil ) Segment.load: done executing sql [select
"RISKGROUPCLOSURE"."ANCESTORID" as "c0",
sum("DAILYCFBYRISKGROUPHIERARCHY"."STRESSCFAMOUNTPLUS"+"DAILYCFBYRISKGROUPHIERARCHY"."STRESSCFAMOUNTMINUS")
as "m0" from "RISKGROUPCLOSURE" "RISKGROUPCLOSURE",
"DAILYCFBYRISKGROUPHIERARCHY" "DAILYCFBYRISKGROUPHIERARCHY" where
"DAILYCFBYRISKGROUPHIERARCHY"."NODEID" = "RISKGROUPCLOSURE"."NODEID"
and "RISKGROUPCLOSURE"."ANCESTORID" = 1000.0 group by
"RISKGROUPCLOSURE"."ANCESTORID"], <b>exec+fetch 15 ms, 0 rows</b><br>
<br>
[2010-06-30 16:26:51,896] [DEBUG] [/lrm230] [OTIDO\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:aln@192.168.1.171">aln@192.168.1.171</a>] -
(FastBatchingCellReader$Batch) Batch.loadAggregation (millis) 15<br>
[2010-06-30 16:26:51,896] [DEBUG] [/lrm230] [OTIDO\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:aln@192.168.1.171">aln@192.168.1.171</a>] -
(FastBatchingCellReader) loadAggregation (millis): 15<br>
[2010-06-30 16:26:51,897] [DEBUG] [/lrm230] [OTIDO\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:aln@192.168.1.171">aln@192.168.1.171</a>] -
(ResultBase ) RolapResult<init>: FREE_MEMORY: 197383kb
63.82%<br>
[2010-06-30 16:26:51,897] [DEBUG] [/lrm230] [OTIDO\<a
moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:aln@192.168.1.171">aln@192.168.1.171</a>] -
(mdx ) 1: exec: 18 ms</tt><br>
<br>
It reports that query returned 0 rows (if I understand it correctly).<br>
But when I tried to execute the same SQL manually against my database
it returned one row.<br>
<br>
Could anybody help me with it? We didn't change schema definition and
database content, so it worked in 3.1.2.<br>
Any hint why closure could stop working would be much appreciated...<br>
<br>
Thanks.<br>
<br>
Anton Nikitin<br>
</blockquote>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
Mondrian mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Mondrian@pentaho.org">Mondrian@pentaho.org</a>
<a class="moz-txt-link-freetext" href="http://lists.pentaho.org/mailman/listinfo/mondrian">http://lists.pentaho.org/mailman/listinfo/mondrian</a>
</pre>
</blockquote>
</body>
</html>