Infosys’ blog on industry solutions, trends, business process transformation and global implementation in Oracle.

« Oracle Data Visualization Cloud Service | Main | Different Flavours of Hyperion Security »

Cross Module Integration-EPBCS and EPRCS

Turbocharge your EPM planet with cross module integration "EPRCS - EPBCS Integration"

 Its only, just a matter or a question of time that EPRCS will be the most preferred Cloud Reporting Service available in the EPM market. As strong as this comes you would second it in another not greater than 600 seconds as you reach the C ya later climax of this blog.

Gone are the days of dossier when the Decision makers seamlessly miss insights, chill the soup, miss the story behind the data. Purposeful Intent of the EPRCS is being a One stop shop for managing all your reporting needs.  Let's get beyond merriness is advocating this process driven approach, never before seen in reporting.

Process for defining reports, authoring reports, reviewing and approving reports. Regulatory report packages get's published, financial and management reports of your company in a much secure and collaborative and process driven approach. If I understand it correctly, this is Cloud Only solution and hence would be a great Value add with the never seen before capabilities and features on your report publishing process.

Just like many, I too got carried over by the naming similarity and miss-understood it as HFR ( Hyperion Financial Reporting) on Cloud and was later proven wrong. May be it was intended to co-work other technologies in the reporting gamete like Smart view and financial reports. 

While there are other Blogs of mine that takes a deep dive into EPRCS and its features and capabilities along with details of the latest December upgrade, this one will retain focus on the recent repeat asks from peers..."How to integrate EPBCS with EPRCS".

I am making a serious attempt here to enable the reader quickly come up to speed on using EPRCS and integrating it with other EPM stack of products like EPBCS, FCCS, OAC.

First let us take a peek into integration EPBCS and EPRCS (integrating here is not DATA but marrying the User interface) advantages of these and as a matter of fact in general would be

o   Seamless Customer experience

o   Enterprise wide well connected system

o   Maximum utilization of the products on the ground

o   Extreme flexibility hand picking and mixing what to choose from source instance for integrating

o   Plenty of Cloud based tools

o   Ease of Importing/Exporting artifacts within the various Cloud products

Should I be using EPRCS to integrate it to EPBCS by setting up EPBCS as a "Source" in EPRCS Data Source. Well, with all signs on a traditional HFR developer that's  the route that brain would take. As I generously elaborate in all my articles, EPM has a magical touch and that really left me wondering, if this is the only way to tunnel to EPBCS. What was I thinking by digging onto the targets..shouldn't I obviously know that there should be a way to set it up in EPBCS?? Well If I want to pull in the user interface all or selective from EPRCS and use it within the EPBCS world for super enhanced power packed design then a big YES, so I decided to take a look at the EPBCS landing you see below:


Let's get to the apparent Tools section and open it up to enjoy what it has in store for us..


Prithiba_Pic2.png this must be it. As simple to navigate and it's like almost most and definitely the commonly used administrator activities are indeed available on the cards right in front of you, very intelligently arranged and Thanks for Oracle for that...Someone there had really done a deep thinking into not only giving all that we can ask for but also in a way that is very convenient and comfortable for us!

Since I don't have any connection set up yet, this is what I am going to see the first time I land at "Manage Connections"





Onto the top right, it wasn't that difficult to find the Add Connection...


Oh What a sight...that I see when I click onto Add Connection...Beautiful ladies lined up to volunteer to be targets for our connection set up and at this context, without any detour I better select Oracle Enterprise Reporting Cloud service to reach any closer to accomplish the mission intended!


The Create Connection pop-up is self-explanatory with the below basic mandatory fields for completing the connection set up.

  • 1.       URL - The URL of the Enterprise Performance Reporting Cloud Service
  • 2.       Connection Name - That's for you to choose and I would say EPRCS-Conn
  • 3.       Description -I would lay out Details of the intended use for this connection.
  • 4.       Service Administrator - The user id that would actually be used for the connectivity- must be service admin or identity domain
  • 5.       Password- The password for the above user id
  • 6.       Domain - This is the domain in which the EPRCS is hosted. Apparently this means that cross domain / cross pod integration is also possible! Wow..!!

Once you "Validate" the connection and make it successful you are good to go to the next of "Save and Close" on the top right. Another though fancy yet helpful item here is the Domain entry at the last box at the bottom autofills based on the URL entered in the first box. So you can never go wrong here, even if you intend to!!nce the connection has been saved, you can find it appended to the list in the manage connections. From here, you can also perform further editing or deletion.


Bingo! Just click on the home icon and to the navigator you will see the new connection!


Let's now see how to play around with the newly added target application. Click the connection name and you will see the application opening in the same browser tab. On the other hand, you can also click the open window icon and the application will open in a brand new browser window.

Did I just see what I just saw? One user Login-Single point of Entry-Access to multiple cloud services!! Another magical moment!!

Since I believe that the same can be applied to all the EPM cloud services, all the cloud pods that I have access to and that's exactly what I am going to cook tonight.

One last tip with this write-up. We can also add any card or cluster from the target application to your source application. How that can happen is via the navigation flows.


Once you click on "Add Existing Card/Cluster" the library window will open. Also on the left side you will have the option to choose one of your connections.

Gladly into the seamless world of connectivity...! 

Signing Off for now...Prithiba.D

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

Please key in the two words you see in the box to validate your identity as an authentic user and reduce spam.

Subscribe to this blog's feed

Follow us on

Blogger Profiles