ibot setup based on the data

user12863665

i have a requirement to send data only to specific reccivers who is in the report output. this should happen dynamically based on the output rows. 
Ex: Report output is like
Column 1, Column 2, Column 3

[ABC,ABC@XYZ.COM,100]

[CDE,CDE@XYZ.COM,200]

[FGH,FGH@XYZ.COM,300]

[IJK,IJK@XYZ.COM,400]

-- in the above scenario, only first row should devliver to ABC@XYZ.COM and only second Row should deliver to CDE@XYZ.COM,...so on.  Anyone suggest me best approach to get this done With ibots

M De Fanti

Hi,

I think you should use the "use analysis" option in the recipients tab of the agent.

Regards

Massimo

Gianni Ceresa

What Massimo said is how to get the list dynamically.

For the part where you want to filter the delivery, you will need to use OBIEE filtering as an agent is a normal OBIEE content.

How can you show different content of a same analysis to different users? You must either use row-level security with filters applied at the RPD level, VPD or similar or user named connections to the sources to filter the data at the source, or session variables as filters in the analysis.

Pick your option and go for it.

Christian Berg-0racle

In any case for what Gianni says the user has to be a "user" in the technical sense. I.e. a valid security principal of type "user". This is because the server does an implicit login as that user in order to apply data level filtering etc.

Gianni Ceresa

Christian Berg wrote:...the user has to be a "user" in the technical sense. I.e. a valid security principal of type "user". 

True, forgot to mention that, also because licensing apply: you want to produce OBIEE content by user? That user must have a license as you are using the tool...

Christian Berg-0racle

Gianni Ceresa wrote:Christian Berg wrote:...the user has to be a "user" in the technical sense. I.e. a valid security principal of type "user".  you want to produce OBIEE content by user? That user must have a license as you are using the tool...

Bingo! And that's the crux of it. People assume they can just get the tool and use it for whatever they want and to send to whoever they want. That's definitely wrong and a dangerous path in case Oracle ever drops by to check how many users are using the system. And personalized recipients count as 1 user each.