Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Using an Element by Expression in a DM WHERE clause
Summary
Using an Element by Expression in a DM WHERE clause
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
Answers
-
please clear your requirement ,Thanks
0 -
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.
0 -
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
0