Basic Questions About Agents

Chris Arnold

Some background:

For the past year or so I have been a 'front-end' developer for a company that used OBIEE 12c.

Just this past week, I started employment at a new company that uses OBIEE 11g (11.1.1.9.0).

I have noticed some things with agents that have me puzzled. I've done some internet searching, but can't seem to get any definitive answers. Here are my issues/questions:

(1) At my 12c company, we were able to deliver the Entire Dashboard in Excel format via an agent. I cannot find this option in our 11g environment. I see in this post ( http://obiee911.blogspot.com/2014/02/how-to-export-entire-obiee-dashboard-to.html ) that they are saying this option became available as early as version 11.1.1.7.1 (which preceeds our version of 11.1.1.9.0). But I still cannot find the option.

Is this some option in the config files that I need to have turned on?

(2) At my 12c company, I remember we would create agents very often where the analysis being delivered had several 'is prompted' filters in them. When creating the agent, I don't ever recall getting any option to hard-code values for those filters when creating the agent. The analysis would simply be delivered as though the filters were not there at all. If I wanted hard-coded values in those filters for a specific set of recipients, I would actually make a separate report with the desired values, and deliver that new analysis to them.

But now that I'm working in 11g, I am seeing that whenever I create an agent on an analysis that has 'is prompted' filters, I get the option to set values on those filters. I'm certainly not complaining...I like having this option. I certainly would like to have had it (known how to use it)when I was working in the 12c environment.

So for my own sanity, I'm trying to find out if this is some option in the configuration that must be turned on or off (and we just had it OFF in my 12c environment)...or if this option was actually dropped in 12c (which I could not imagine Oracle ever doing with something this useful).

Any insight would be greatly appreciated.

Thanks for any help or advice on these things.

Chris

Gianni Ceresa

Hi Chris,

To be allowed to send the entire dashboard (or a dashboard page) via email with an agent you must first be allowed to export the entire dashboard / dashboard page.

Check in the Administration > Manage Privileges page to see if you have the permission for that (or actually it's more the user the agent use who needs that privilege).

Gianni Ceresa

For your second point I still have that in 12c (12.2.1.2.0) :

I do not remember a setting for that honestly.

Wasn't it because you were sending dashboards / dashboards pages instead of an analysis?

Chris Arnold

Thank you Gianni! That certainly answers my question. I have only marked your reply as 'Helpful' (instead of marking it 'Correct Answer') so as not to totally close my thread -- as I'm still hoping that someone might add some insight on the 2nd question I posed also.

My apologies for that, and thanks again!

Chris

[Deleted User]

+1 - it's still there and there isn't really any "way to turn it off" that I ever have come across.

Chris Arnold

Very weird. Not sure why I did not see that option when I was working with 12c at my last employer.

Oh well...I have the option now, and I'm sure we will have it when we upgrade our current environment up to 12c.

I appreciate everyone's input. Thanks for the answers!

Chris