Sunday, January 18, 2015

Drill-Back to Source System to Source System Oracle General Ledger using FDMEE via Planning/Essbase

Author:-Sanjay Purohit
I have seen few posting on Oracle community regarding the FDMEE Drill Through functionality setup and required Oracle-GL responsibilities. FDMEE provides drill through functionality from planning to source systems. This functionality is very useful for financial/function users who want to verify the data accuracy from GL and also wants to know the source of transaction.

Objective
The purpose of this article is to demonstrate how to setup the drill through form Hyperion Planning to Oracle GL using FDMEE. I will not cover source system/data load and other FDMEE related setup.
Enter the Oracle GL URL by going to . Make sure you enter the URL such as http://Sanjay.epmcult.com:18000

Navigate -> Administer - > Data Management -> Setup -> Source System  

Enabling “Drill Region” to Target Application by going . Make sure you enter
Navigate -> Administer -> Data Management ->Setup -> Target Application -> Application Option
Setup the Drill region to “Yes

Setting UP Appropriate GL responsibility
Navigate -> Administer -> Data Management ->Setup -> Source Accounting Entities and select “GL Inquiry/Reports User” responsibility


Make sure when data is loaded you should be “Crate Drill Region HPL_DRILL_REGIONS”


Now let’s go to Planning application and drill through to Oracle-GL. The data from should have drillable views


 By  click you should be landed to FDMEE Data load location. This location stores the EBS URL

You should be able to see the General Ledger screen with dollar value. Make sure you login user should have “GL Inquiry/Reports User”  Responsibility



Hyperion Account Properties

Depp Dive into Drill-Through


 Essbase Documentation
https://docs.oracle.com/cd/E36352_01/epm.1112/esb_tech_ref/frameset.htm?maxl_credrillthrough.html

Posted by at

6 comments:

  1. AnonymousTuesday, January 20, 2015 at 11:55:00 AM PST

    Hi Sanjay, Thanks for detail post.

    I am trying to achieve drill through back to GL (11 version),however, in step 3 (above), I only see the "General Ledger Super User" responsibility, how do I make FDMEE to populate other responsibilities (Such as "General Ledger User").

    Thanks for your input in advance

    ReplyDelete
  2. Sanjay PurohitTuesday, January 20, 2015 at 3:32:00 PM PST

    FDMEE should display all the responsibility if it configured properly. Are you using APPS user in ODI ? APPS should pull all.
    If you are not seeing all the responsibility then you need to
    Re-Initialize the source system
    On the source accounting entities screen – Clear the responsibility name and save it. Then log off from FDMEE and go to same screen then click on search screen you must see all the responsibilities.
    Cache kills. Sometime FDMEE keep caches.

    ReplyDelete
  3. AnonymousThursday, February 26, 2015 at 10:54:00 AM PST

    Can you please specify dimension details setup involved for enabling drill down?

    ReplyDelete
  4. AnonymousThursday, February 26, 2015 at 3:53:00 PM PST

    Sanjay - Can multiple responsibility be associated to the source accounting entity? Thanks in advance.

    ReplyDelete
  5. Sanjay PurohitThursday, February 26, 2015 at 10:28:00 PM PST

    I will try to prepare one more detail posting regarding the drill back and dimension setup

    ReplyDelete
  6. Sanjay PurohitThursday, February 26, 2015 at 10:30:00 PM PST

    Multiple responsibility cannot be associated with source entity? any specific reason you are looking to associate multiple responsibility? I would rather assign multiple responsibilities at user level in GL than FDMEE.

    ReplyDelete

Subscribe to: Post Comments (Atom)