If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to Set dynamic title depend on drill down/up?

Started by kenrisen, 21 Nov 2011 03:07:38 AM

Previous topic - Next topic

kenrisen

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>