[prev in list] [next in list] [prev in thread] [next in thread]
List: mondrian
Subject: [Mondrian] Infinity in results with Calculated Members while using
From: Venkatesh U <venkatesh20 () gmail ! com>
Date: 2011-01-08 4:58:07
Message-ID: AANLkTi=mOgWku4-GqFos15ViSkTGonUVn886o2fVjHJj () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I am trying the below query
String avgMdx = "WITH "
+ "SET [ExceptSegments] AS' "
+ "{([All NetWorkInformations],[All CallDirections],[All
TimeOfDays],[All Locations],[All PeriodOfWeeks],[All DayOfWeeks],[All
UOMs],[All Services],[All SubscriptionTypes])}' "
+ "SET [FilterDimensions] AS ' "
+
"{([NetworkInformation].[Off-Net],[PeriodOfWeek].[Weekday])}' "
+ "MEMBER [Measures].[AvgSpend] AS "
+
"'[Measures].[SumOfCost]/{CrossJoin([Measures].[CustomerCount],[ExceptSegments])}.Item(0)',
"
+ "format_String=\"#,###.000\" "
+ "SET "
+ "[TimeDimension-CurrentSelection] AS ' "
+
"{[TimeDimension.MonthLevel].[JAN-2010]:[TimeDimension.MonthLevel].[MAR-2010]}'
"
+ "SET "
+ "[TopLocations] AS ' "
+ "GENERATE( "
+ "[TimeDimension-CurrentSelection] "
+ ", TOPCOUNT( "
+ "[TimeDimension.MonthLevel].CURRENTMEMBER "
+ "* "
+ "[Location].[LocationLabel].Members "
+ ",5,[Measures].[SumOfCost]))' "
+ "MEMBER [Location].[Others] AS ' "
+ "[Location].[All Locations] -
Aggregate(extract(Intersect(CrossJoin([TimeDimension.MonthLevel].CurrentMember,[Location].[LocationLabel].Members),[TopLocations]),[Location]))'
"
+ "select [Measures].[AvgSpend] on 0, "
+ "{[TopLocations] * [FilterDimensions],
[TimeDimension-CurrentSelection] *[Location].[Others] * [FilterDimensions]}
on 1 "
+ "from [SpendAnalytics] ";
mdxParsetest.parsedObject = mdxParsetest.parser.parseSelect(avgMdx);
CellSet cSet =
mdxParsetest.statement.executeOlapQuery(mdxParsetest.parsedObject.toString());
PrintWriter pw = new PrintWriter(System.out, true);
RectangularCellSetFormatter rcsf = new
RectangularCellSetFormatter(true);
rcsf.format(cSet, pw);
The results come with Infinity when i use OLAP4j
AvgSpend
======== ================= ======= ======= ========
JAN-2010 Karongi Off-Net Weekday
NO_NAME MENTIONED Off-Net Weekday
Huye Off-Net Weekday
Nyabihu Off-Net Weekday Infinity
Gakenke Off-Net Weekday Infinity
FEB-2010 Kicukiro Off-Net Weekday
Nyamagabe Off-Net Weekday
Nyaruguru Off-Net Weekday
Nyagatare Off-Net Weekday
Nyamasheke Off-Net Weekday
MAR-2010 Burera Off-Net Weekday Infinity
Nyaruguru Off-Net Weekday
Nyamagabe Off-Net Weekday
Rubavu Off-Net Weekday Infinity
Huye Off-Net Weekday
JAN-2010 Off-Net Weekday Infinity
FEB-2010 Off-Net Weekday Infinity
MAR-2010 Off-Net Weekday Infinity
But the Same works fine with Jpivot and MondrianQueryServlet
Results: [Measures].[AvgSpend][TimeDimension.MonthLevel].[JAN-2010][Location].[Karongi]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[JAN-2010][Location].[NO_NAME
MENTIONED] [NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]
[TimeDimension.MonthLevel].[JAN-2010] [Location].[Huye]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[JAN-2010]
[Location].[Nyabihu]
[NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]83.161
[TimeDimension.MonthLevel].[JAN-2010] [Location].[Gakenke]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]88.459[TimeDimension.MonthLevel].[FEB-2010]
[Location].[Kicukiro] [NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]
[TimeDimension.MonthLevel].[FEB-2010] [Location].[Nyamagabe]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[FEB-2010]
[Location].[Nyaruguru] [NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]
[TimeDimension.MonthLevel].[FEB-2010][Location].[Nyagatare]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[FEB-2010]
[Location].[Nyamasheke] [NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]
[TimeDimension.MonthLevel].[MAR-2010][Location].[Burera]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]102.613[TimeDimension.MonthLevel].[MAR-2010]
[Location].[Nyaruguru] [NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]
[TimeDimension.MonthLevel].[MAR-2010][Location].[Nyamagabe]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[MAR-2010]
[Location].[Rubavu] [NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]70.150
[TimeDimension.MonthLevel].[MAR-2010] [Location].[Huye]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday][TimeDimension.MonthLevel].[JAN-2010]
[Location].[Others]
[NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]1,068.224
[TimeDimension.MonthLevel].[FEB-2010] [Location].[Others]
[NetWorkInformation].[Off-Net]
[PeriodOfWeek].[Weekday]1,191.337[TimeDimension.MonthLevel].[MAR-2010]
[Location].[Others]
[NetWorkInformation].[Off-Net][PeriodOfWeek].[Weekday]1,134.190
Could anyone help me to understand whats happening? I am using same
mondrian.jar and olap4j.jar available in the jpivot, where the query returns
proper results.
Thanks,
Venkatesh
[Attachment #5 (text/html)]
<div><font class="Apple-style-span" color="#333333">I am trying the below \
query</font></div><div><font class="Apple-style-span" \
color="#990000"><br></font></div><div><font class="Apple-style-span" \
color="#990000">String avgMdx = "WITH "</font></div>
<div><font class="Apple-style-span" color="#990000"> + "SET \
[ExceptSegments] AS' "</font></div><div><font class="Apple-style-span" \
color="#990000"> + "{([All NetWorkInformations],[All \
CallDirections],[All TimeOfDays],[All Locations],[All PeriodOfWeeks],[All \
DayOfWeeks],[All UOMs],[All Services],[All SubscriptionTypes])}' \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + "SET \
[FilterDimensions] AS ' "</font></div><div><font class="Apple-style-span" \
color="#990000"> + \
"{([NetworkInformation].[Off-Net],[PeriodOfWeek].[Weekday])}' \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + "MEMBER \
[Measures].[AvgSpend] AS "</font></div><div><font class="Apple-style-span" \
color="#990000"> + \
"'[Measures].[SumOfCost]/{CrossJoin([Measures].[CustomerCount],[ExceptSegments])}.Item(0)', \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + \
"format_String=\"#,###.000\" "</font></div><div><font \
class="Apple-style-span" color="#990000"> + "SET \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + \
"[TimeDimension-CurrentSelection] AS ' "</font></div><div><font \
class="Apple-style-span" color="#990000"> + \
"{[TimeDimension.MonthLevel].[JAN-2010]:[TimeDimension.MonthLevel].[MAR-2010]}' \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + "SET \
"</font></div><div><font class="Apple-style-span" color="#990000"> \
+ "[TopLocations] AS ' "</font></div><div>
<font class="Apple-style-span" color="#990000"> + "GENERATE( \
"</font></div><div><font class="Apple-style-span" color="#990000"> \
+ "[TimeDimension-CurrentSelection] "</font></div>
<div><font class="Apple-style-span" color="#990000"> + ", \
TOPCOUNT( "</font></div><div><font class="Apple-style-span" color="#990000"> \
+ "[TimeDimension.MonthLevel].CURRENTMEMBER "</font></div>
<div><font class="Apple-style-span" color="#990000"> + "* \
"</font></div><div><font class="Apple-style-span" color="#990000"> \
+ "[Location].[LocationLabel].Members "</font></div>
<div><font class="Apple-style-span" color="#990000"> + \
",5,[Measures].[SumOfCost]))' "</font></div><div><font \
class="Apple-style-span" color="#990000"> + "MEMBER \
[Location].[Others] AS ' "</font></div>
<div><font class="Apple-style-span" color="#990000"> + \
"[Location].[All Locations] - \
Aggregate(extract(Intersect(CrossJoin([TimeDimension.MonthLevel].CurrentMember,[Location].[LocationLabel].Members),[TopLocations]),[Location]))' \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + "select \
[Measures].[AvgSpend] on 0, "</font></div><div><font class="Apple-style-span" \
color="#990000"> + "{[TopLocations] * [FilterDimensions], \
[TimeDimension-CurrentSelection] *[Location].[Others] * [FilterDimensions]} on 1 \
"</font></div>
<div><font class="Apple-style-span" color="#990000"> + "from \
[SpendAnalytics] ";</font></div><div><font class="Apple-style-span" \
color="#990000"><br></font></div><div><font class="Apple-style-span" color="#990000"> \
mdxParsetest.parsedObject = mdxParsetest.parser.parseSelect(avgMdx);</font></div>
<div><font class="Apple-style-span" color="#990000"><br></font></div><div><div><font \
class="Apple-style-span" color="#990000">CellSet cSet = \
mdxParsetest.statement.executeOlapQuery(mdxParsetest.parsedObject.toString());</font></div>
<div><font class="Apple-style-span" color="#990000"> PrintWriter pw = new \
PrintWriter(System.out, true);</font></div><div><font class="Apple-style-span" \
color="#990000"> RectangularCellSetFormatter rcsf = new \
RectangularCellSetFormatter(true);</font></div>
<div><font class="Apple-style-span" color="#990000"> rcsf.format(cSet, \
pw);</font></div></div><div><br></div><div><div>The results come with Infinity when i \
use OLAP4j</div><div> </div><div> \
AvgSpend</div>
<div>======== ================= ======= ======= ========</div><div>JAN-2010 Karongi \
Off-Net Weekday </div><div> NO_NAME MENTIONED Off-Net Weekday \
</div><div> Huye Off-Net Weekday </div>
<div> Nyabihu Off-Net Weekday Infinity</div><div> Gakenke \
Off-Net Weekday Infinity</div><div>FEB-2010 Kicukiro Off-Net Weekday \
</div><div> Nyamagabe Off-Net Weekday </div>
<div> Nyaruguru Off-Net Weekday </div><div> Nyagatare \
Off-Net Weekday </div><div> Nyamasheke Off-Net Weekday \
</div><div>MAR-2010 Burera Off-Net Weekday Infinity</div>
<div> Nyaruguru Off-Net Weekday </div><div> Nyamagabe \
Off-Net Weekday </div><div> Rubavu Off-Net Weekday \
Infinity</div><div> Huye Off-Net Weekday </div>
<div>JAN-2010 Off-Net Weekday Infinity</div><div>FEB-2010 \
Off-Net Weekday Infinity</div><div>MAR-2010 Off-Net Weekday \
Infinity</div></div><div><br></div><div>But the Same works fine with Jpivot and \
MondrianQueryServlet</div>
<div><br></div><div><span class="Apple-style-span" style="font-family: 'Times New \
Roman'; font-size: medium; -webkit-border-horizontal-spacing: 2px; \
-webkit-border-vertical-spacing: 2px; ">Results:<table class="resulttable" \
cellspacing="1" border="0" style="background-color: rgb(170, 170, 170); ">
<tbody><tr><td nowrap class="slicer" rowspan="1" colspan="4" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; "> </td><td nowrap class="columnheading" \
colspan="1" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Measures].[AvgSpend]</td></tr><tr><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Karongi]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; ">[Location].[NO_NAME \
MENTIONED]</td><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Huye]</td><td nowrap class="rowheading" style="background-color: rgb(221, \
221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Nyabihu]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
83.161</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, \
221, 221); font-size: 10pt; ">[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Gakenke]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
">88.459</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, \
221, 221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[FEB-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Kicukiro]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">[TimeDimension.MonthLevel].[FEB-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Nyamagabe]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[FEB-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Nyaruguru]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">[TimeDimension.MonthLevel].[FEB-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Nyagatare]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[FEB-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Nyamasheke]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Burera]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
">102.613</td></tr><tr><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Nyaruguru]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Nyamagabe]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Rubavu]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
70.150</td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, \
221, 221); font-size: 10pt; ">[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[Location].[Huye]</td><td nowrap class="rowheading" style="background-color: rgb(221, \
221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
"></td></tr><tr><td nowrap class="rowheading" style="background-color: rgb(221, 221, \
221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[JAN-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Others]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
1,068.224</td></tr><tr><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[TimeDimension.MonthLevel].[FEB-2010]</td><td \
nowrap class="rowheading" style="background-color: rgb(221, 221, 221); font-size: \
10pt; ">
[Location].[Others]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">[NetWorkInformation].[Off-Net]</td><td nowrap \
class="rowheading" style="background-color: rgb(221, 221, 221); font-size: 10pt; ">
[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; \
">1,191.337</td></tr><tr><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[TimeDimension.MonthLevel].[MAR-2010]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[Location].[Others]</td><td nowrap class="rowheading" style="background-color: \
rgb(221, 221, 221); font-size: 10pt; ">
[NetWorkInformation].[Off-Net]</td><td nowrap class="rowheading" \
style="background-color: rgb(221, 221, 221); font-size: 10pt; \
">[PeriodOfWeek].[Weekday]</td><td class="cell" style="font-family: courier; \
background-color: rgb(255, 255, 255); font-size: 10pt; text-align: right; ">
1,134.190</td></tr></tbody></table></span></div><div><br></div><div>Could anyone help \
me to understand whats happening? I am using same mondrian.jar and olap4j.jar \
available in the jpivot, where the query returns proper results.</div>
<div><br></div><div><br></div><div>Thanks,</div><div>Venkatesh</div>
_______________________________________________
Mondrian mailing list
Mondrian@pentaho.org
http://lists.pentaho.org/mailman/listinfo/mondrian
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic