RRDI report for count of all defects.
One answer
Hi Smitha,
Do you simply want to have total number of defects? If yes, here is the report I have created for that:
<report xmlns="http://developer.cognos.com/schemas/report/8.0/" useStyleVersion="10" expressionLocale="en-us">
<modelPath>/content/folder[@name='Reporting Data Models']/package[@name='Reporting Data Model (DW)']/model[@name='model']</modelPath>
<drillBehavior modelBasedDrillThru="true"/>
<layouts>
<layout>
<reportPages>
<page name="Page1">
<style>
<defaultStyles>
<defaultStyle refStyle="pg"/>
</defaultStyles>
</style>
<pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pb"/>
</defaultStyles>
</style>
<contents><singleton refQuery="Query1" name="Singleton1">
<contents><textItem><dataSource><dataItemValue refDataItem="Total Requests"/></dataSource></textItem></contents>
</singleton></contents>
</pageBody>
</page>
</reportPages>
</layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2013-05-10T17:31:05.256Z" output="no"/></XMLAttributes><queries><query name="Query1"><source><model/></source><selection><dataItemMeasure name="Total Requests"><dmMember><MUN>[Request Metrics].[Request Metrics].[Total Requests]</MUN><itemCaption>Total Requests</itemCaption></dmMember><dmDimension><DUN>[Request Metrics].[Request Metrics]</DUN><itemCaption>Request Metrics</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItemMeasure></selection></query></queries></report>
Please let us know if you can open this code (Tools -> Open report from clipboard).
Please also check if you have selected Reporting Data Model (DW)
Let us know if that helps.
Do you simply want to have total number of defects? If yes, here is the report I have created for that:
<report xmlns="http://developer.cognos.com/schemas/report/8.0/" useStyleVersion="10" expressionLocale="en-us">
<modelPath>/content/folder[@name='Reporting Data Models']/package[@name='Reporting Data Model (DW)']/model[@name='model']</modelPath>
<drillBehavior modelBasedDrillThru="true"/>
<layouts>
<layout>
<reportPages>
<page name="Page1">
<style>
<defaultStyles>
<defaultStyle refStyle="pg"/>
</defaultStyles>
</style>
<pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pb"/>
</defaultStyles>
</style>
<contents><singleton refQuery="Query1" name="Singleton1">
<contents><textItem><dataSource><dataItemValue refDataItem="Total Requests"/></dataSource></textItem></contents>
</singleton></contents>
</pageBody>
</page>
</reportPages>
</layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2013-05-10T17:31:05.256Z" output="no"/></XMLAttributes><queries><query name="Query1"><source><model/></source><selection><dataItemMeasure name="Total Requests"><dmMember><MUN>[Request Metrics].[Request Metrics].[Total Requests]</MUN><itemCaption>Total Requests</itemCaption></dmMember><dmDimension><DUN>[Request Metrics].[Request Metrics]</DUN><itemCaption>Request Metrics</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItemMeasure></selection></query></queries></report>
Please let us know if you can open this code (Tools -> Open report from clipboard).
Please also check if you have selected Reporting Data Model (DW)
Let us know if that helps.