Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to change the print template for OTBI - Analysis ?

Accepted answer
24
Views
3
Comments

Here is the step about this quesiton

Open OTBI Analysis , click Print -(Printable PDF / Printable HTML) , the page will display the table data and additional title (Like company logo and company name)

My question is how to change the company name in print page,

We try to find the "Print Option" in here Analysis - Result Page / Compund Layout, but can not find

We can find the related content from Analysis XML, but don't find the way to update in result page.

<saw:caption fmt="text"> <saw:text>here is the company name</saw:text></saw:caption></saw:zone>

 <saw:views textDelivery="compoundView!1" currentView="0" partialReportUpdate="false">          
      <saw:view xsi:type="saw:compoundView" name="compoundView!1">                     
         <saw:cvTable>            
            <saw:cvRow>               
               <saw:cvCell viewName="titleView!1"/></saw:cvRow>            
            <saw:cvRow>               
               <saw:cvCell viewName="tableView!1">                              
                  <saw:displayFormat>                                   
                     <saw:formatSpec/>            </saw:displayFormat>          </saw:cvCell></saw:cvRow></saw:cvTable>         
         <saw:pageProps orientation="landscape" printRows="visible" disableMargins="false" pageSize="letter">                    
            <saw:pageHeader showOnDashboard="false" show="true">                         
               <saw:zone position="top">                              
                  <saw:displayFormat>                                   
                     <saw:formatSpec hAlign="left" fontColor="#000000" fontStyle="bold" fontSize="20" wrapText="true"/>            </saw:displayFormat>                              
                  <saw:caption fmt="text" oldID="kcap1298656391438_406">                                   
                     <saw:text>@{cmap:/shared/Custom/image/Logo.jpg}</saw:text>            </saw:caption>          </saw:zone>                         
               <saw:zone position="left">                              
                  <saw:displayFormat>                                   
                     <saw:formatSpec hAlign="left" width="33%"/>            </saw:displayFormat>          </saw:zone>                         
               <saw:zone position="center">                              
                  <saw:displayFormat>                                   
                     <saw:formatSpec hAlign="center" width="34%" fontStyle="bold" fontSize="25" wrapText="true"/>            </saw:displayFormat>                            
                  <saw:caption fmt="text">                     
                     <saw:text>here is the company name</saw:text></saw:caption></saw:zone>                         
               <saw:zone position="right">                              
                  <saw:displayFormat>                                   
                     <saw:formatSpec hAlign="right" width="33%"/>            </saw:displayFormat>               

Thanks & Regards

Michael Li

Best Answer

  • RVohra
    RVohra Rank 6 - Analytics Lead
    Answer ✓
    • Click Edit on the analysis.
    • Switch to the Advanced Tab →
    • Scroll down to the “XML” section that defines the compound layout.
    • Edit the content . After editing the XML, scroll to the bottom of the Advanced tab and click Apply XML.
    • Save the analysis.
    • Test by clicking Print > Printable PDF/HTML

Answers

  • fandong.li-Oracle
    fandong.li-Oracle Rank 1 - Community Starter

    Hi RVohra:

    Thanks for your reply on this, I try few analysis , but sometime the update of XML doesn't work, sometime it works, does have any delay about this update ? (example have to wait a few minutes after save)

    One more question, does this support to change the xml attribute too ?

    That is to change the landscapge for print from landscape to portrait

      <saw:pageProps orientation="landscape" printRows="visible" disableMargins="false" pageSize="letter">                                <saw:pageHeader showOnDashboard="false" show="true">                                        <saw:zone position="top">                                                <saw:displayFormat>                                                        <saw:formatSpec hAlign="left" fontColor="#000000" fontStyle="bold" fontSize="20" wrapText="true"/>            </saw:displayFormat>                                                <saw:caption fmt="text" oldID="kcap1298656391438_406">                                                        <saw:text>@{cmap:/shared/Custom/image/Logo.jpg}</saw:text>            </saw:caption>          </saw:zone>                                        <saw:zone position="left">                                                <saw:displayFormat>                            
    

    Thanks & Regards

    Michael Li

  • RVohra
    RVohra Rank 6 - Analytics Lead

    If it is not consistently working, then please take help from Oracle Support by logging SR.

    About xml attribute, never tried it.