[Mondrian] virtual cube measures break cube

Paul Stoellberger p.stoellberger at gmail.com
Fri Jul 15 14:56:06 EDT 2011


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=detail&aid=3312701&group_id=168953&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>





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20110715/14462e67/attachment.html 


More information about the Mondrian mailing list