OBIEE11g variable usage in source sql? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE11g variable usage in source sql?

Received Response
1
Views
2
Comments
User_0PDV4
User_0PDV4 Rank 4 - Community Specialist

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