Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Symantec Enterprise Reporting Reports

Created: 27 Jun 2008 • Updated: 21 May 2010 | 2 comments
Sunny G's picture

Hi there,

 

I realize this forum is a little quiet..   But thought i would ask the question anyway.  Has anyone done a little or a lot of work in creating/customizing the Reports in ESM SER?  The reports packages that come with the product are not too bad, but i'm finding customers have all kinds of other specific requirements when it comes to reporting, which i'm sure comes as no surprise.

 

SO what i would propose or ask, is that if you have reports that you've created and would like to share or would like to request a certain type of report, we can do so here.  I am not a Cognos expert, but i do know ESM and played with setting up reports a bit although i need to spend a lot more time to get it down.

 

Thanks,

Sunny

Discussion Filed Under:

Comments 2 CommentsJump to latest comment

Sunny G's picture

A note in how to provide these reports..  From the Reporting Portal, find the report you want to share and launch Design Studio by clicking the icon.  When the report is opened in design mode, you can go to the menu (tools?) and select copy to clipboard.  This will copy the entire report contents and queries, etc. in to an XML format to the clipboard.

 

You can then paste the XML to the forum in a message, and/or save to a text file with a .XML extension.

 

Thanks,

Sunny

Sunny G's picture

Here isample of a simple report:

 

<report xml:lang="en-ca" xmlns="http://developer.cognos.com/schemas/report/1/"><!--RS:1.1-->
 <modelConnection name="/content/package[@name='Symantec ESM 6.5.3']/model[@name='model']"/>
 <querySet xml:lang="en-ca">
  <BIQuery name="Query1">
   <cube><factList><item refItem="Agent" aggregate="none"/><item refItem="Policy" aggregate="none"/><item refItem="Module" aggregate="none"/><item refItem="Rating" aggregate="none"/><item refItem="Messages" aggregate="none"/><item refItem="Red Messages" aggregate="total"/><item refItem="Yellow Messages" aggregate="total"/></factList></cube>
  <tabularModel><dataItem name="Agent" aggregate="none"><expression>[Module Trend by Agent].[Agent].[Agent]</expression></dataItem><dataItem name="Policy" aggregate="none"><expression>[Module Trend by Agent].[Policy].[Policy]</expression></dataItem><dataItem name="Module" aggregate="none"><expression>[Module Trend by Agent].[Module].[Module]</expression></dataItem><dataItem name="Rating" aggregate="total"><expression>[Module Trend by Agent].[Agent Trend].[Rating]</expression></dataItem><dataItem name="Messages" aggregate="total"><expression>[Module Trend by Agent].[Agent Trend].[Messages]</expression></dataItem><dataItem name="Red Messages" aggregate="automatic"><expression>[Module Trend by Agent].[Agent Trend].[Red Messages]*10</expression></dataItem><dataItem name="Yellow Messages" aggregate="automatic"><expression>[Module Trend by Agent].[Agent Trend].[Yellow Messages]</expression></dataItem><filter><condition>[Agent]=?Agent?</condition></filter><filter use="required" summary="false"><condition>[Module]&lt;&gt;'&lt;All Modules&gt;'</condition></filter></tabularModel></BIQuery>
 </querySet>
 <layoutList>
  <layout>
   
  <pageSet>
    
   <page name="Page1">
     <pageBody>
      <list refQuery="Query1">
       <listColumnTitles><listColumnTitle><textItem><queryItemRef content="label" refItem="Agent"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Policy"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Module"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Messages"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Red Messages"/></textItem></listColumnTitle><listColumnTitle><textItem><queryItemRef content="label" refItem="Yellow Messages"/></textItem></listColumnTitle></listColumnTitles>
       <listColumns><listColumn><textItem><queryItemRef refItem="Agent"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Policy"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Module"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Messages"/></textItem><style><CSS value="text-align:right"/></style></listColumn><listColumn><textItem><queryItemRef refItem="Red Messages"/></textItem></listColumn><listColumn><textItem><queryItemRef refItem="Yellow Messages"/></textItem></listColumn></listColumns>
       <style>
        <CSS value="border-collapse:collapse"/>
       </style>
      <XMLAttribute name="RS_ListGroupInfo" value=""/><overallFooter><rowCells><rowCell class="inlineFooter" colSpan="4"><textItem><text>Summary</text></textItem></rowCell><rowCell class="inlineSummary"><style><CSS value="text-align:right"/></style><textItem><queryItemRef refItem="Red Messages"/></textItem></rowCell><rowCell class="inlineSummary"><style><CSS value="text-align:right"/></style><textItem><queryItemRef refItem="Yellow Messages"/></textItem></rowCell></rowCells></overallFooter></list>
     </pageBody>
     <pageHeader>
      <block class="reportTitle">
       <textItem class="reportTitleText">
        <text/>
       </textItem>
      </block>
      <style>
       <CSS value="padding-bottom:10px"/>
      </style>
     </pageHeader>
     <pageFooter>
      <table>
       <tableRow>
        <tableCell>
         <textItem>
          <expression>AsOfDate()</expression>
         </textItem>
         <style>
          <CSS value="vertical-align:top;text-align:left;width:25%"/>
         </style>
        </tableCell>
        <tableCell>
         <textItem>
          <text>- </text>
         </textItem>
         <textItem>
          <expression>PageNumber()</expression>
         </textItem>
         <textItem>
          <text> -</text>
         </textItem>
         <style>
          <CSS value="vertical-align:top;text-align:center;width:50%"/>
         </style>
        </tableCell>
        <tableCell>
         <textItem>
          <expression>AsOfTime()</expression>
         </textItem>
         <style>
          <CSS value="vertical-align:top;text-align:right;width:25%"/>
         </style>
        </tableCell>
       </tableRow>
       <style>
        <CSS value="border-collapse:collapse;width:100%"/>
       </style>
      </table>
      <style>
       <CSS value="padding-top:10px"/>
      </style>
     </pageFooter>
    </page></pageSet></layout>
 </layoutList>
</report>