Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Exporting report outputs(PDF, CSV) to Network Shared File system(Linux Server) from Agents in OBIEE

Received Response
405
Views
15
Comments
Rank 5 - Community Champion

Hello Experts,

How would we achieve this,

Exporting report outputs(PDF, CSV) to Network Shared File system(Linux Server) from Agents in OBIEE 12C. Please help.

Regards,

Abinash

Welcome!

It looks like you're new here. Sign in or register to get started.
«1

Answers

  • Rank 2 - Community Beginner

    Hello,

    a good starting point would be to study https://support.oracle.com/rs?type=doc&id=1610118.1

    While this document was especially provided for Oracle BI 11g, general tasks are still the same for OBIEE 12c.

    In general you...

    1. ...create an Java EJB (or use that precompiled Application given by Oracle in Doc 1610118.1 )
    2. ...deploy your Application to your managed server (bi_server1)
    3. ...configure OBIEE ActionFramework (using OBIEE 12c it's ActionFrameworkConfig.xml in <domain_home>/config/fmwconfig/biconfig/actions !!) to register your EJB and make it available within BI
    4. ...create your agent calling your Java EJBs
    5. ...provide values for your parameters (filename and content, e.g. pdf/csv/excel file)

    In contrast to prebuild applications/EJBs provided online, oracle released its sourcecode as well. Nevertheless it might be a good idea to always check precompiled java-applications by using a java decompiler first

    Hope this little description will help you.

    Regards

    Chris

  • Rank 10 - Analytics Guru

    Nice write-up Chris

  • Rank 5 - Community Champion

    Hi chris,

    I tried everything as per steps mentioned in the Doc 1610118.1 . No luck.

    I am getting below errors while invoking the EJB. Any suggestions?

    pastedImage_0.png

    pastedImage_1.png

    Regards,

    Abinash

  • Rank 5 - Community Champion

    Hi,

    Why dont you try using BIP for this?

    Can BI Publisher Shared Storage use NFS volumes managed by the NFS Automounter? (Doc ID 2010519.1)

    Thanks,

    Sareesh

  • Rank 5 - Community Champion

    Phew!!

    Eevrything is good with https://support.oracle.com/rs?type=doc&id=1610118.1 except while creating and mapping credential key in EM.

    Document mentioned to have WLSJNDI as username, but I used weblogic as username and it worked.

    Thanks Chris and Christian for the help!!

    Regards,

    Abinash

  • Rank 2 - Community Beginner

    I am getting the same error , what did you do to fix it ?

  • Rank 5 - Community Champion

    Can BI Publisher Shared Storage use NFS volumes managed by the NFS Automounter? (Doc ID 2010519.1)

    Thanks,

    Sareesh

  • Rank 10 - Analytics Guru

    @Saresh-Oracle not sure why that Dic ID keeps being mentioned. Abinash never talked about that and explicitly re-stated that another Doc is the one.Yes, BIP can do this via bursting (the documentation link I posted).

    pastedImage_0.png

  • Rank 5 - Community Champion

    @ Christian Berg, thats upto 3624414

Welcome!

It looks like you're new here. Sign in or register to get started.