Hallo
I get the Error
org.apache.jasper.JasperException: javax.servlet.jsp.JspException: javax.servlet.jsp.JspException: Mondrian Error:Named set in cube 'TestArchivedAndHot' has bad formula
if I try to use another cube from the Schema.
This is the Definition of the virtual cube:
<VirtualCube name="TestArchivedAndHot">
<VirtualCubeDimension name="Account"/>
<VirtualCubeDimension name="Mandant"/>
<VirtualCubeDimension name="Provider"/>
<VirtualCubeDimension name="MoccaAccount"/>
<VirtualCubeDimension name="Time"/>
<VirtualCubeMeasure cubeName="Test" name="[Measures].[SMSARCHIVED]" visible="false"/>
<VirtualCubeMeasure cubeName="TestToday" name="[Measures].[SMSHOT]" visible="false"/>
<CalculatedMember name="SMS" dimension="Measures">
<Formula>[Measures].[SMSARCHIVED] + [Measures].[SMSHOT]</Formula>
</CalculatedMember>
</VirtualCube>
I hope this is enough.
Thanks for help.
regards
Bastian