Passing Variables from Agent to Analysis

Question

I'm working in OBIEE 11.1.1.7 and I am having trouble assigning variable through an agent. I have columns which are derived from variables configured in the prompts tab.

For example:

YEAR(Production_Date) = @{p_report_year}

or

YEAR(Production_Date) = @{p_report_year} - 1

When the analysis is run manually, it prompts for the variable and then runs properly.  I haven't figured out how to assign a value to this variable through the scheduler. The agents I create properly assign values to filters that I have listed as "column is prompted" but I don't know how to assign that variable through the agent scheduler.

Can anyone help?

Thanks in advance!

[Deleted User] · Answer

Yes prompted filters with Agent context is just about as far as you can go.

As I said depending on your detailed requirements you'll have to think of something a bit more complex / clever / adapted.

2aab23a2-de99-4333-ab7f-8cd0c977d554 · Answer

I'm able to assign values to prompted filters, for example to prompt for a specific client. But it seems there's no way to similarly prompt for something that gets used in a variable sense, rather than a grandiose filter for the entire result set..

Thanks for your help

[Deleted User] · Answer

Repository variables can be dynamic (there are static and dynamic ones) and session variables are dynamic in nature by default - they're instantiated for each user session - and are either system or non-system.

Here's the documentation: https://docs.oracle.com/cd/E28280_01/bi.1111/e10540/variables.htm#BIEMG3104

You will never have the case where a scheduled agent "selects" a value from a prompt like a user does - there's simply no user doing the action of selecting. So you've got to think about what your requirement actually is and how you can reflect this in a variable in the RPD.