OBIEE11g variable usage in source sql?

User_0PDV4

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

Felipe_Idalgo

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

[Deleted User]

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