1 2 Previous Next 17 Replies Latest reply on Jun 3, 2015 9:45 AM by Christian Berg

    BI Answers footer components

    DarranA

      Hi All,

       

      I'm trying to set a default footer in BI Answers using xml.  I can do this fine using the code below:

      <pageProps>

              <pageFooter showOnDashboard="true" show="true">

                <zone type="ok">

                  <caption>[b]Test Footer Text[/b]</caption>

                </zone>

              </pageFooter>

            </pageProps>

       

      This puts the string "Test Footer Text" in the top section of the footer as shown below (presumably this is the "caption" section).

      Capture.JPG

       

      Can anyone tell me if I can use the other 4 sections of the footer in the same way (ie: the ones with red question marks in the image above) - and if so what these sections are called?

       

      Thanks in advance to anyone who can help.

       

      Cheers,

      Darran


        • 1. Re: BI Answers footer components
          Christian Berg

          Darran,

           

          Oracle documentation contains the code example for that: http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/answersconfigset.htm#i1018681

           

          And here's how you reference the different sections:

          • 2. Re: BI Answers footer components
            DarranA

            Thanks Christian.

             

            I had found the doco - but it only had an example and I didn't realise it was the "zone" that controlled the location!  Makes sense! - and works perfectly now.  Thanks.

             

            Now I'm trying to make the footer smarter by using parameters (to show the path, name and date/time/timezone).  I've been able to do this fine for Dashboards (using the code below), but it doesn't work for analyses.  Any thoughts?  Can this be done?

             

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

            <WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">

               <WebMessageTable system="Answers" table="ViewDefaults">

            <WebMessage name="kuiDashboardDefaultElements" translate="no"><HTML>

            <element signature="dashboardPage" personalSelections="true">

                 <pageProps orientation="portrait" printRows="all" pageSize="a4">

                     <pageFooter showOnDashboard="true" show="true">

                        <zone type="top">

                           <caption>Dashboard Name: @{dashboard.path}[br/]Run Time: @{system.currentTime} @{session.timeZone.value}

                           </caption>

                           <displayFormat hAlign="left"/>

                        </zone>

                     </pageFooter>

                   </pageProps>

               </element>

            </HTML>

            </WebMessage>

            </WebMessageTable>

            </WebMessageTables>

             

             

            Cheers,

            Darran


            • 3. Re: BI Answers footer components
              Christian Berg

              I've been able to do this fine for Dashboards (using the code below), but it doesn't work for analyses.

               

              For analyses? The XML you post is definitely for dashboards. For Answers it would be this tags:

              <WebMessageTable system="Answers" table="ViewDefaults">

              <WebMessage name="kuiCriteriaDefaultViewElements" translate="no">

               

              ...but that's just for setting the default views which go in any new analysis. not sure you can already pre-fill these variables into a narrative for example. Haven't tried that yet.

              • 4. Re: BI Answers footer components
                DarranA

                Thanks Christian - yes, the xml above is what I used for dashboards. I'm trying to use the same variables in an analysis footer (as shown below), but it doesn't work.

                 

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

                <WebMessageTables xmlns:sawm="com.siebel.analytics.web.messageSystem">

                   <WebMessageTable system="Answers" table="ViewDefaults">

                <WebMessage name="kuiCriteriaDefaultViewElements" translate="no"><HTML>

                   <view signature="compoundView" >

                      <cv signature="titleView" />

                      <cv signature="filtersView" />

                      <cv signature="tableView" />

                      <cv signature="pivotTableView" />

                      <pageProps pageSize="a4">

                        <pageFooter showOnDashboard="true" show="true">

                          <zone type="top">

                            <caption>Run Time: @{system.currentTime}</caption>

                            <displayFormat hAlign="left"/>

                          </zone>

                        </pageFooter>

                      </pageProps>

                   </view>

                </HTML>

                </WebMessage>

                   </WebMessageTable>

                </WebMessageTables>

                 

                This just results in the text "Run Time: @{system.currentTime}" being displayed in the top section of the analysis footer

                 

                I can successfully display the date/time in the footer using the variables @{dateCreated} and @{timeCreated}.  However - the real reason I want to use variables is that I want to include the Analysis Path and Name in the footer so that I can easily locate an analysis when a user sends me output with a question.

                • 5. Re: BI Answers footer components
                  Christian Berg

                  Those are @{report.name} and @{report.path} .

                  • 6. Re: BI Answers footer components
                    DarranA

                    Thanks again Christian.

                     

                    I can get those parameters to work in the subtitle field of the Title - but when I use them in a footer they don't work, it just displays the string @{report.name}.

                    Capture.JPG

                    Cheers,

                    Darran

                    • 7. Re: BI Answers footer components
                      Christian Berg

                      Are you still inside the Answers / Analysis context? In that case is the Analysis stored already? Otherwise the variable isn't instantiated.

                      Otherwise put single quotes around it? '@{report.name}'

                      • 8. Re: BI Answers footer components
                        DarranA

                        Hi Christian,

                         

                        In my example above, yes I was still in the Analysis context and not sure if I had saved the Analysis.  I have saved two versions of the analysis (one with single quotes as suggested and one without) - but still I just see the text rather than the analysis name.  I'm starting to think perhaps this just isn't possible in an Analysis?

                         

                        Without Quotes

                        Footer-without quotes.JPG

                         

                        With Quotes

                        Footer-with quotes.JPG

                         

                        Cheers,

                        Darran

                        • 9. Re: BI Answers footer components
                          Christian Berg

                          Hi Darran,

                           

                          Looks like it which is a bit surprising. But you can always put it into a Narrative View - just not default it upon creation.

                          1 person found this helpful
                          • 10. Re: BI Answers footer components
                            DarranA

                            Many thanks for your help Christian - looks like you're right.

                             

                            Cheers,

                            Darran

                            • 11. Re: BI Answers footer components
                              Christian Berg

                              Cool! So can we consider this thread as closed or do you want to dig further? Currently it's still marked as

                               

                              This question is Not Answered.
                              • 12. Re: BI Answers footer components
                                DarranA

                                My apologies – yes, please do mark this as closed.

                                 

                                Cheers,

                                Darran

                                 

                                Description: cid:image001.png@01CF9569.C97E3530

                                 

                                Darran Ambrose

                                 

                                Business Intelligence Manager

                                 

                                 

                                Tel: +61 8 8131 2473

                                 

                                Mob: +61 411 484 213

                                 

                                Level 3, 167 Fullarton Road, Dulwich SA 5065

                                • 13. Re: BI Answers footer components
                                  Christian Berg

                                  Hi Darran,

                                   

                                  It's only you as the original poster who asked the question who can close the thread :-)

                                  • 14. Re: BI Answers footer components
                                    DarranA

                                    Hi Christian,

                                     

                                    Well this is embarrassing.  I can't find where to mark the thread as closed!  I read the FAQ topic "How can I mark answers as correct or helpful?" - but it unhelpfully says "just click the appropriate button to mark an answer as correct or as helpful"   Not very helpful if you can't see any buttons

                                     

                                    Could you please kindly point me in the right direction?

                                     

                                    Cheers,

                                    Darran

                                    1 2 Previous Next