Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 42 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 277 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OBIEE11g variable usage in source sql?
Hi all,
I have a question about using variables with sql in OBIEE. Situation is following:
- OBIEE11g installed on AIX/Oracle
- main data source is Oracle
- new data source is SQL Server and data is extracted by using sql clauses, not pure tables
Sql clauses has a date at least in four different places and that date determines data limits. And of course it changes - how can I use a date variable in that sql so that users can change it?!
BR,
Mari
Answers
-
Hi,
I can't undestand you very well
Are u using a sQL view on source (RPD - Physical Layer) instead of a table and you wanna filter that by date?
Why didn't you apply that directly on your analysis? a view will be solved by DB equally unless you use a materialized view
Felipe Idalgo
0 -
Yes. Session Variables can be overruled with what then is called Request Variables: http://gerardnico.com/wiki/dat/obiee/request_variable
0