OBIEE11g variable usage in source sql?

Question

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

[Deleted User] · Answer

Yes. Session Variables can be overruled with what then is called Request Variables: http://gerardnico.com/wiki/dat/obiee/request_variable

Felipe_Idalgo · Answer

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