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.5k477103)

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.5k477103) | 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.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.