EPM Cloud - Drill Through from SmartView

Drill Through we can do using 3 ways:

1. Workbench data
2. Data Form
3. SmartView

Once you open SmartView, Right Click on Data Cell and Click on Drill through

Before this step we can select below to open Drill through in web browser or in new sheet

In SmartView >> Options >> Advanced >> Drill Through Launch

Once you click on Drill Through, you will get open in New Web Browser or In New Sheet.

If you face any issue regarding the above drill through option with Excel, you have to add extension to the browser. Please refer below document for the same.

Unable To Drill Through On SmartView Reports The information you’re about to submit is not secure (Doc ID 2825480.1)

Thanks,

Mady

EPM Cloud - Drill Through to File using Drill Through Definitaion in Calc Manager

We can drill back to Source using Workbench Data, Data Forms, and also using SmartView

Using Workbench data, we can drill through to Source, steps documented in below link:

https://hyperion-mady-epm-cloud.blogspot.com/2023/01/drill-through-using-data-management.html

Using Data Form, Go to Navigate - Rules - Select Database Properties as showing below

Expand EPM Cloud 

          "Application Name"

                 >> Expand application name    

                        >> Right click on Cube name 

                                >> Select Drill Through Definition 

Click on + sign and Enter URL name, XML, and click Add Region. Enter the combination of Data Form.  

XML Contents:

<?xml version="1.0" encoding="UTF-8"?>

<foldercontents path="/">

  <resource name="Drill Through to source" description="" type="application/x-hyperion-applicationbuilder-report">

    <attribute name="name" type="string" xml:lang="ja" value="ソースにドリル・スルー"/>

    <attribute name="name" type="string" xml:lang="en" value="Drill Through to source"/>

    <attribute name="name" type="string" xml:lang="zh_TW" value="鑽研至來源"/>

    <attribute name="name" type="string" xml:lang="tr" value="Kaynakta Detaya Git"/>

    <attribute name="name" type="string" xml:lang="ko" value="소스로 드릴스루"/>

    <attribute name="name" type="string" xml:lang="no" value="Gjennomdrilling til kilde"/>

    <attribute name="name" type="string" xml:lang="nl" value="Drill-through naar bron"/>

    <attribute name="name" type="string" xml:lang="iw" value="תחקור למקור"/>

    <attribute name="name" type="string" xml:lang="cs" value="Přejít ke zdroji"/>

    <attribute name="name" type="string" xml:lang="th" value="ดริลล์ผ่านไปยังที่มา"/>

    <attribute name="name" type="string" xml:lang="it" value="Esegui drill-through nell'origine"/>

    <attribute name="name" type="string" xml:lang="fr" value="Exploration amont vers la source"/>

    <attribute name="name" type="string" xml:lang="ru" value="Детализация до источника"/>

    <attribute name="name" type="string" xml:lang="ro" value="Detaliere la sursă"/>

    <attribute name="name" type="string" xml:lang="zh_CN" value="穿透钻取到源"/>

    <attribute name="name" type="string" xml:lang="fi" value="Siirry lähteeseen"/>

    <attribute name="name" type="string" xml:lang="ar" value="الاستعراض التشعبي إلى المصدر"/>

    <attribute name="name" type="string" xml:lang="sv" value="Borra genom till källa"/>

    <attribute name="name" type="string" xml:lang="pt_BR" value="Fazer drill-through para origem"/>

    <attribute name="name" type="string" xml:lang="pl" value="Drąż skrośnie do źródła"/>

    <attribute name="name" type="string" xml:lang="fr_CA" value="Forage transversal jusqu'à la source"/>

    <attribute name="name" type="string" xml:lang="de" value="Drillthrough zur Quelle"/>

    <attribute name="name" type="string" xml:lang="hu" value="Áthatoló részletezés a forrásig"/>

    <attribute name="name" type="string" xml:lang="es" value="Obtener detalles hasta origen"/>

    <attribute name="name" type="string" xml:lang="da" value="Bor igennem til kilde"/>

    <action name="Drill Through to source" description="" shortdesc="">

      <url>./aif/modules/com/hyperion/aif/gl/main/FdmeeMain.jsp?module=aif.drilldown&amp;sso_token=$SSO_TOKEN$&amp;rcp_version=$RCP_VERSION$&amp;$ATTR(ds,id)$</url>

    </action>

  </resource>

</foldercontents>

Add Region:

@List(<Row members, Column Members>, Fix members etc)

Click Ok. 

Now Check the Data Form you can find this combination cell like below. Symbol in the cell right corner top.

You can drill through using SmartView also with same Data form. you can find the same in next blog.

Thanks,

Mady

Reference :

Unable To Drill Through On SmartView Reports The information you’re about to submit is not secure (Doc ID 2825480.1) https://www.epmmarshall.com/drill-through-in-pbcs-and-hyperion-planning-without-fdmee/