Invalid SQL in Measure Expression

[vishal29bhp]

Hello Everybody,

                                I am trying to add Measures Expression in jasperanalysis workbench in cdata element.

                                It is properly validated the mondrian connection. But when i fire MDX query this sql generates Invalid Syntax

                                Error.

                                My Measures are Net Sales , Target and I am  trying to get Last Year Sales From the Measure Expression.

                               

                               Example:

                                <Measure name="Last_Year_Sales" column="amount" aggregator="sum" visible="true">
                                    <MeasureExpression>
                                         <SQL dialect="mysql">
                                              <![CDATA[select distinct 0 as amount from ciph_time_d]]>
                                          </SQL>
                                   </MeasureExpression>
                                 </Measure>
                               

       I think the problem is it is taking sql in aggregate function but how do i get rid of this error.                                                             

Code:

Post Edited by vishal29bhp at 11/05/2009 11:37

[swood]

A MeasureExpression is to define a single column dynamically on the fact table, so it cannot be a full select statement as you have there.

 

Sherman

Jaspersoft