BO Condition in a derived table

[Former Member]

Hi everyone,

When I try to create a condition in the derived table "Der_Tab_SS" (derived from Tab_SS) writing into the condition area "Der_Tab_SS"."ZFISCALWEEK" != '0' knowing that ZFISCALWEEK is a char, I get into the error message Exception, DBD, ORA-00904: "Der_Tab_SS"."ZFISCALWEEK" not valid identifier.

But the table and the fileds are correctly existing!

Which mistake am I doing? Can someone kindly help?

[Former Member]

Hello,

I think, the syntax is not correct. Perhaps this helps:

You define a derived table Der_Tab_SS:

The sql of the derived table is:

select dim1, ZFISCALWEEK, measure1 from

source_table

where source_table.ZFISCALWEEK" != '0'

In the where you must use the qulifier of the source table. If you have a complex derived table an you want to set after the calculation a filter, you can define the derived table as:

select * from (

select dim1, ZFISCALWEEK, measure1 from

source_table

where ....

)

where ZFISCALWEEK" != '0'

hope that helps.

Andreas

[Former Member]

Hi,

You mean, you want to add that inside Derive table definition or Condition object (yellow funnel) after Derive is created?

In second case try to 'clickout' the definition by clicking objects/columns you want to use to verify - maybe you have some missing letter or sth.