Hi all Cognos Gurus..
I have a report with drill down/drill up function and a title. The title have to change dyanamic everytime I drill down/drill up the report. I have built using a data linking but I found an issue when I drill down until the last element and drill up, the title will be wrong.
How to solve this problem?
Is it a bug in cognos 10.1?
FYI..
I tried with cognos package sample (Go Data Warehouse Analysis).
report studio spec
<report xmlns="http://developer.cognos.com/schemas/report/7.0/" useStyleVersion="10" expressionLocale="en-us">
<modelPath>/content/folder[@name='Samples']/folder[@name='Models']/package[@name='GO Data Warehouse (analysis)']/model[@name='model']</modelPath>
<layouts>
<layout>
<reportPages>
<page name="Page1">
<style>
<defaultStyles>
<defaultStyle refStyle="pg"/>
</defaultStyles>
</style>
<pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pb"/>
</defaultStyles>
</style>
<contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><singleton name="Singleton1" refQuery="Query2">
<contents><textItem><dataSource><dataItemValue refDataItem="Products"/></dataSource></textItem></contents>
</singleton></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Query1">
<crosstabCorner>
<contents><textItem><dataSource><dataItemLabel refDataItem="Forecast unit cost"/></dataSource></textItem></contents>
<style>
<defaultStyles>
<defaultStyle refStyle="xm"/>
</defaultStyles>
</style>
</crosstabCorner>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="xt"/>
</defaultStyles>
</style>
<defaultMeasure refDataItem="Forecast unit cost"/><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Month" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns><crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Product line" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows></crosstab></contents></tableCell></tableCells></tableRow></tableRows></table></contents>
</pageBody>
</page>
</reportPages>
</layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><queries><query name="Query1"><source><model/></source><selection><dataItemMeasure name="Forecast unit cost"><dmMember><MUN>[Product forecast].[Product forecast fact].[Forecast unit cost]</MUN><itemCaption>Forecast unit cost</itemCaption></dmMember><dmDimension><DUN>[Product forecast].[Product forecast fact]</DUN><itemCaption>Product forecast fact</itemCaption></dmDimension><XMLAttributes><XMLAttribute name="RS_dataType" value="2" output="no"/></XMLAttributes></dataItemMeasure><dataItemLevelSet name="Month"><dmLevel><LUN>[Product forecast].[Time].[Time].[Month]</LUN><itemCaption>Month</itemCaption></dmLevel><dmDimension><DUN>[Product forecast].[Time]</DUN><itemCaption>Time</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Time].[Time]</HUN><itemCaption>Time</itemCaption></dmHierarchy></dataItemLevelSet><dataItemLevelSet name="Product line"><dmLevel><LUN>[Product forecast].[Products].[Products].[Product line]</LUN><itemCaption>Product line</itemCaption></dmLevel><dmDimension><DUN>[Product forecast].[Products]</DUN><itemCaption>Products</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Products].[Products]</HUN><itemCaption>Products</itemCaption></dmHierarchy></dataItemLevelSet><dataItemLevelSet name="Product type"><dmLevel><LUN>[Product forecast].[Products].[Products].[Product type]</LUN><itemCaption>Product type</itemCaption></dmLevel><dmDimension><DUN>[Product forecast].[Products]</DUN><itemCaption>Products</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Products].[Products]</HUN><itemCaption>Products</itemCaption></dmHierarchy></dataItemLevelSet><dataItemLevelSet name="Product"><dmLevel><LUN>[Product forecast].[Products].[Products].[Product]</LUN><itemCaption>Product</itemCaption></dmLevel><dmDimension><DUN>[Product forecast].[Products]</DUN><itemCaption>Products</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Products].[Products]</HUN><itemCaption>Products</itemCaption></dmHierarchy></dataItemLevelSet></selection><memberSetStructure/></query><query name="Query2">
<source>
<model/>
</source>
<selection><dataItemLevelSet name="Branch"><dmLevel><LUN>[Product forecast].[Branch].[Branch].[Branch]</LUN><itemCaption>Branch</itemCaption></dmLevel><dmDimension><DUN>[Product forecast].[Branch]</DUN><itemCaption>Branch</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Branch].[Branch]</HUN><itemCaption>Branch</itemCaption></dmHierarchy></dataItemLevelSet><dataItemHierarchySet rootMembersOnly="false" name="Products"><dmDimension><DUN>[Product forecast].[Products]</DUN><itemCaption>Products</itemCaption></dmDimension><dmHierarchy><HUN>[Product forecast].[Products].[Products]</HUN><itemCaption>Products</itemCaption></dmHierarchy></dataItemHierarchySet></selection>
</query></queries><reportName>test drill down drill up cognos using cognos sample</reportName><drillBehavior drillUpDown="true" modelBasedDrillThru="true"><drillQueryBehavior refQuery="Query2"><drillDataItemBehavior refDataItem="Products" drillColumnTitle="levelLabel"><drillUpBehavior><drillAncestor depthOffset="1"/></drillUpBehavior><drillDownBehavior><drillSimpleType type="replaceItem"/></drillDownBehavior></drillDataItemBehavior></drillQueryBehavior></drillBehavior><drillSetsBehavior><linkedDrillItemSets><linkedDrillItemSet name="Linked Data Items1"><linkedDrillItem refQuery="Query1" refDataItem="Product line"/><linkedDrillItem refQuery="Query2" refDataItem="Products"/></linkedDrillItemSet></linkedDrillItemSets></drillSetsBehavior></report>