Followers

Tuesday, February 21, 2023

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 :

No comments:

Post a Comment