Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 218 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
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