Hi,

i'm having a cube that cannot be loaded neither in PSW nor in saiku, but in 3.8 EE GA biserver (mondrian 3.2.1.13885 and 3-3-SNAPSHOT) :
i have recently posted an issue regarding measures in olap4j, maybe this is related? http://sourceforge.net/tracker/?func...53&atid=848534
Below the error and cube definition. Any input on that would be appreciated.
Thanks!

-Paul

Caused by: mondrian.olap.MondrianException: Mondrian Error:Error while parsing MDX statement 'WITH
MEMBER [Measures].[Actuals, No Total Rows]
AS '([Income Statement.~ Income Statement Settings ~].[Show Total Rows].[No],[Measures].[Actual Values])',
FORMAT_STRING = Iif([Measures].[TOTAL_ROW] >= 1, '|#,##0.00|style=green','|#,##0|style=white'),
[$member_scope] = 'CUBE',
MEMBER_ORDINAL = 1
SELECT FROM [GL Actual and Budget]'
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:841)
at mondrian.olap.Parser.parseInternal(Parser.java:814)
at mondrian.olap.ConnectionBase.parseStatement(ConnectionBase.java:106)
... 63 more
Caused by: mondrian.olap.MondrianException: Mondrian Error:MDX object '[Measures].[TOTAL_ROW]' not found in cube 'GL Actual and Budget'
at mondrian.resource.MondrianResource$_Def1.ex(MondrianResource.java:858)
at mondrian.olap.Util.lookup(Util.java:782)
at mondrian.olap.Id.accept(Id.java:107)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)
at mondrian.olap.fun.FunUtil.resolveFunArgs(FunUtil.java:1929)
at mondrian.mdx.UnresolvedFunCall.accept(UnresolvedFunCall.java:103)
at mondrian.olap.ValidatorImpl.validate(ValidatorImpl.java:80)

it seems to look up the CM "Actuals, No Total Rows" from the LEDGER cube in the VC as well, although its not specified in there at all for a reason I dont really understand.

<Schema name="Financials">
<Cube name="LEDGER" cache="true" enabled="true">
<Table name="FACT_GL_REPORTS" schema="TESTING">
</Table>
<Measure name="TOTAL_ROW" column="TOTAL_ROW" datatype="Integer" formatString="#,##0;(#,##0)" aggregator="sum" visible="true">
</Measure>
<CalculatedMember name="Actuals, No Total Rows" formula="([Income Statement.~ Income Statement Settings ~].[Show Total Rows].[No],[Measures].[Actual Values])" dimension="Measures">
<CalculatedMemberProperty name="FORMAT_STRING" expression="Iif([Measures].[TOTAL_ROW] &#62;= 1, &#39;|#,##0.00|style=green&#39;,&#39;|#,##0|style=white&#39">
</CalculatedMemberProperty>
</CalculatedMember>
</Cube>

<VirtualCube enabled="true" name="GL Actual and Budget">
<VirtualCubeMeasure cubeName="LEDGER" name="[Measures].[TOTAL_ROW]" visible="true">
</VirtualCubeMeasure>
</VirtualCube>
</Schema>






_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian