AnsweredAssumed Answered

Clarity Studio course Multi-Dimensional Portlet problem

Question asked by Phil_S on Aug 19, 2010
Latest reply on Aug 20, 2010 by navzjoshi00
Can anybody advise me on what may be wrong with the following example query? I am running it on an Oracle-based environment. If I attempt to run the SQL code generated in the query preview window in an IDE then it works fine. However in the query window it generates error "OracleORA-00936: missing expression SQL Text".

Many thanks.
SELECT    
  @SELECT:DIM:USER_DEF:IMPLIED:RESOURCE:R.ID:int_res_ID@, 
  @SELECT:DIM_PROP:USER_DEF:IMPLIED:RESOURCE:R.FULL_NAME:ResourceName@, 
  @SELECT:DIM:USER_DEF:IMPLIED:TIMEPERIOD:TP.prID:TimePeriodID@, 
  @SELECT:DIM_PROP:USER_DEF:IMPLIED:TIMEPERIOD:to_char(TP.prStart,'yyyy-mm-
dd'):PeriodStart@, 
  @SELECT:metric:user_def:IMPLIED:Sum(TE.prActSum/3600):Actuals:agg@ 
FROM      
        SRM_RESOURCES R, 
        PRTIMEPERIOD TP, 
        PRTIMESHEET TS, 
        PRTIMEENTRY TE 
WHERE     
R.ID = TS.prResourceID 
AND TS.prTimePeriodID= TP.prID 
AND TS.prID= TE.prTimeSheetID 
AND      @FILTER@ 
GROUP BY R.ID, R.FULL_NAME,TP.prID,(TP.prStart) 
HAVING   @HAVING  FILTER@ 

Outcomes