Hyperion Planning linkage with OBIEE

JanGLi

Hi,

I have a bit of situation here. I have a clubbed figure in hyperion planning and it's breakup report in OBIEE. Is there any way i can link that cell/form to that OBIEE report.

Any workaround? Any manual way of linking it??

Thanks in advance.

Regards

Dayalan Punniyamoorthy

Did you checked this blog, John have covered it well here More to life...: Planning data source in OBIEE 11.1.1.9

HTH,

Dayalan P.

JanGLi

Thanks for sharing the doc. I have seen the blog and it is more like

i bring my dimension into BI and create reports. (correct me if i am wrong)

What i was looking for is a link which can take me from hyperion data form to OBIEE report.

Or i think we could achieve this by creating a report in OBIEE from the dimensions we brought from hyperion? is it possible?

Regards

USER1211

What version of Hyperion are you on?(including patch level)

How was the data loaded into Hyperion?( FDMEE? Essbase load rules?)

What version of OBIEE are you on?

Based on the general information you provided it appears you are looking for some type of drill  functionality.  Hyperion Planning would not be able to natively pass you to OBIEE reports.

The option you have :

If you loaded the Data via FDMEE you could have set that up for Drill through by which you could Drill from Planning to FDMEE to the Source System(could essentially be some URL).

You can look at third party tools like Drill-bridge.

Certainly the belief is you would do the due diligence in setting up and testing the various aspects of the integration(single sign on etc) and giving consideration of the feasibility of such an approach.

Hopefully the above information is helpful to you.

JohnGoodwin

Drill-through just creates a drill through region in EAS, it can customised in any way without FDMEE, Drillbridge, it is possible to create a new drill through region through EAS or MaxL, API against a planning essbase database.

I have never tried to set up drill through to OBIEE though but if you know the url to pass it can be done.

Cheers

John

Dayalan Punniyamoorthy

Do you mean you want to open a OBIEE report from Hyperion Planning data form?

If yes, may try something like this. From your Data form you can add a comment and in the comment you can add a link to a OBIEE report. i did tested for a local document published in the Workspace (used the smartcut url) and it works.

Of course you can create a report using the Hyperion metadata & data. Pull the needed data (Budget for FY17) from Hyperion Planning and get that loaded into OBIEE (multiple methods available) and create the reports in OBIEE.

HTH,

Dayalan P.