It's all about the answers!

Ask a question

RRDI report for count of all defects.


SMitha kumari (245254) | asked Feb 05 '14, 6:14 a.m.
edited Feb 06 '14, 11:15 a.m. by Krzysztof Ka┼║mierczyk (7.4k35399)

Hi Team,

wanted to check how do we summation of all defects in RRDI report. In execution metrics with results i am seeing lot of summation done. Please let us know how do we add new data types like Measure, count etc

One answer



permanent link
Krzysztof Ka┼║mierczyk (7.4k35399) | answered Feb 06 '14, 11:13 a.m.
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.

Your answer


Register or to post your answer.