Filter on Metrics of Logical View

[NoobieRhyme]

I have created a Logical View to customize outer joins and running totals. Its attributes and metrics run on the report correctly but the problem occurs when I use a filter on the metric that uses the logical view. The logical view statement is repeated with a duplicated identifier name.


Here is the exact error message:


Status: Execution failed


Error: SQL Generation Complete

QueryEngine encountered error: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [42726:-340: on HSTMT] [IBM][CLI Driver][DB2/6000] SQL0340N The common table expression "RRDWRPT.LV0" has the same identifier as another occurrence of a common table expression definition within the same statement. SQLSTATE=42726



Anyone encountered this before? thanks!

 

[FLB]

If you don't show us how you wrote the SQL for the logical view, I don't think there is much we can do to help....