Using an Element by Expression in a DM WHERE clause

Question

Summary

Content

Is it possible to use an Element by Expression that has been created in a data model in the where clause of the data set it has been created?

E.g

Created an Element by Expression that is (date1-date2)/86400000 'EbEOverdue'.  The data model has a parameter that is a number 'P_Overdue'.  I want to use each of these in the where clause;

WHERE 'EbeOverdue' > : P_Overdue

Message was edited by: 13131313

Venkat Thota - BIP · Answer

If your source is sql ,then create element by expression directly in sql query level and apply condition directly in query as

WHERE  (date1-date2)/86400000 > : P_Overdue

Or

create column for  (date1-date2)/86400000 ,suppose everdue and make inline query and apply where overdue>p_overdue

If source is not sql query then create lov for this paramter as SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable WHERE (date1-date2)/86400000  and use these list of values to filter report data directly.

Thomas Dodds · Answer

if you have

SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable

To be able to filter you can do one of the following:

1 -  SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable WHERE (date1-date2)/86400000 > : P_Overdue

2 - SELECT EbEOverDue FROM (SELECT (date1-date2)/86400000 'EbEOverdue' FROM tblTable) WHERE EbEOverDue > : P_Overdue

Venkat Thota - BIP · Answer

please clear your requirement ,Thanks