Passing Variables from Agent to Analysis

2aab23a2-de99-4333-ab7f-8cd0c977d554

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]

@{xyz} are references to presentation variables which won't have any value definition since they won't be instantiated and populated in the context of an Agent.

You'll have to use Session or Repository variables.

2aab23a2-de99-4333-ab7f-8cd0c977d554

I appreciate the help.

Can you point me in the right direction? I have two columns measures, each pointed to a particular year. This year and last year. I have a prompt where the user inputs a year, and both columns correctly calculate the year based on that prompt

How can I do this through a scheduled agent? A repository variable would be hard coded, and session variables aren't dynamic in this way as far as I can tell. What are my options? Is this functionality even possible?

[Deleted User]

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.

2aab23a2-de99-4333-ab7f-8cd0c977d554

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]

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.