Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Drill through to BIP report not working with RUN TIME PROMPTS

edited Sep 16, 2024 5:09PM in Planning 4 comments

Hi All

From EPBCS application, we are trying to drill through to source system i.e. BIP report.

The BIP Report has 2 Run time parameters

P_YEAR (Values = 2024)

P_MONTH (Values = 08)

could you please guide what should be the drill through URL mentioned in the DRILL URL in map dimensions in DM, so that when integration runs for Aug-24 or Sep-24, it loads into EPM , and drill through WORKS. (with RTPs opening BIP report)

https://****.fa.ocs.oraclecloud.com/xmlpserver/Custom/HHHHH/FX_Rates_EPM.xdo?_xmode=4&P_YEAR=$START_PERIODKEY[YYYY]$&P_MONTH=$START_PERIODKEY[MM]$

below is the BIP Report

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!