Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Caio Zioli
    Reports based on SaaS extensions built in PaaSAnswered
    Topic posted April 12, 2016 by Caio ZioliGold Trophy: 10,000+ Points, tagged BI Publisher, OBI Answers, OBIEE Answers, OTBI 
    170 Views, 9 Comments
    Title:
    Reports based on SaaS extensions built in PaaS
    Summary:
    How to created reports consolidating data from JCS-SX and ERP Cloud
    Content:

    Does any one have a documentation or experience on what's is the best way to achive this ?

    How to create a report that consolidate data from PaaS extensions and ERP Cloud ?

    Best Rgds

    Best Comment

    Gopinath Kartheesan

    Former is correct Caio.  We used DBCS Schema to refresh the custom objects automatically.

    Comment

     

    • Gopinath Kartheesan

      We created custom objects in ERP Cloud and refresh those tables from PaaS on a periodic basis.  Later we used the BI Publisher to build reports from Custom objects + seeded tables in ERP Cloud.

      • Caio Zioli

        Hi Gopinath, tks a lot for your reply.

        Just to better understand:

        Did you created something like a job on DBCS Schema and used a service to update the custom objects automatically ? Or it was manually replicated from PaaS to SaaS ?

        Kind Rgds

    • Gopinath Kartheesan

      Former is correct Caio.  We used DBCS Schema to refresh the custom objects automatically.

      • Caio Zioli

        Hi Gopinath,

        We were also considering to use BICS for this same purpose. Generate reports consolidating data from SaaS and JCS-SX. Do you think it may also be considered as an option ?

        Kind Rgds

         

         

    • Gopinath Kartheesan

      BICS is also another option.  You may have to check on the licensing part and also check with Oracle if they have certified to be used with SaaS and PaaS together and whether the Data refresh will happen automatically or we have to push it to BICS data warehouse manually.  What I heard during the demo last time is that for the first release, there are no automatic push from SaaS or PaaS to BICS.

      • Caio Zioli

        Got it Gopinath ! Tks a lot.

         

        Please, i trying to find the service name to refresh the custom objects automatically. Which one did you use ?

         

        Kind Rgds

    • Kumaran Raviprakash

      Can you guide me on how to create custom objects in ERP cloud as  have a similar sort of requirement

    • Jairo Rojas Mendez

      Can you guide me on how to create custom objects in ERP cloud as  have a similar sort of requirement

    • Sunny Chugh

      Hi

      would like to know if anybody has created a custom data source in SaaS Bi publisher and then have used the custom objects from PaaS DBCs in the BI reports ?

      regards

      sunny