nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12C export dashboard/report data to PDF using Agents

7688438

Hi, We have below requirement.Please provide your inputs. We are using OBIEE 12C.We would like to generate PDF File for every Location ID based on data level security. Location ID's: 1000 1001 1002 1003 1004 1005. ========= Our business requirement is to generate PDF report based on Location ID.We have only one report for all Location ID's.Based on location ID we would like to generate PDF data file for that particular location.Please let me know your inputs. Output should be: 1000.pdf 1001.pdf 1002.pdf 1003.pdf 1004.pdf 1005.pdf Thanks, R

Find more posts tagged with

Accepted answers

All comments

7688438

We followed/Implemented below Doc.But it is working only for one location ID.We would like to generate all Location ID Pdf's based on Location data(Data Level Security). OBIEE 11g: How To Create and Invoke Enterprise Java Beans (EJB) Using The Action Framework (Doc ID 1610118.1). Appreciated your inputs. Thanks, R

7688438

Can any body suggest some inputs on this issue?

Gianni Ceresa

Agents are meant to target users: the content is generated and sent to users, not wrote on disk. This means that either you have as many agents as you have values in your prompt and you set each and every single one to a different value, or that you have different users which by their setup have different content in that same dashboard/analysis. This is generally achieved by having the agent executed as the recipient: OBIEE will login as every single user set as recipient and run the content as that user, applying security or pre-defined filters accordingly.

For what you look for BI Publisher seem to be a better match, as it can be used to simply generate content for every single value without targeting users as agents do.

4117887

Gianni,

Thanks for your Inputs.

Basically we are trying to implement BI Publisher Bursting Process in OBIEE with Agents.With Bursting process we are missing Dashboard KPI's,Graphs.

Our business wants us to generate PDF files based on Location ID and copy to FTP server.We have total 550 Locations but Report is same for all Locations.

We would like to split the report based on Location ID and generate content to PDF.

Any other Approach? with or with out OBIEE...

Thanks,

Gianni Ceresa

4117887 wrote:...or with out OBIEE...

For this one, pick whatever other tool on the market doing the kind of analysis you look for and deal with it.

As said agents are targeted on users, therefore that's how you could cheat. Link the various locations to different users and change your analysis to be reactive to the user session and your agent will be executed with different locations all the time.

You are cheating and use a tool for something it isn't meant for, you can't expect a simple checkbox

7688438

Gianni,

Our business used to have solution with BO,They are asking us to provide the same solution using OBIEE.

I am trying to find the way to make this happen...

Thank you,

Gianni Ceresa

At some point even the business is "smart" enough to understand you can't change the product and expect the exact same behaviour, or .... why did you even change and gave up on BO?

As said, you are cheating with the tool, so play the game of how the tool is developed! Agents are meant for users, this means users is a way to cheat to pre-filter the single analysis with various values dynamically.

Users have sessions, sessions have variables, prompts/filters can be set to use session variables.

I can't really be more explicit than that

7688438

I think we can Achieve it by passing ODI Variable to BI and call BI agent in ODI Package. I would like to try the below process. https://www.ateam-oracle.com/integrating-odi-with-obiee-how-to-invoke-odi-scenarios-load-plans-from-obiee https://community.oracle.com/message/13858142#13858142

[Deleted User]

To add to Gianni's excellent reply: You are far better off learning and comprehending the tool (ANY tool) than making it do things "some other tool did".

If you used to own an ox cart and now someone hands you the keys to a Ferrari...will you complain that you can't feed it grass anymore or that it doesn't go "mooooo" when you poke it with a stick? (BTW please never poke a Ferrari with a stick...).

No. You'll learn how to drive the car. And more specifically: How to drive THAT car! You won't drive it like a VW Lupo. You won't drive it like a Toyota Yaris. You'll drive it like a Ferrari.

Coming back to the tool: Everything else than using the tool as it's built and maybe adding some bells and whistles is plainly and simply a total waste of time and money.