Hi.
does anybody know how to configure drill up / down behavior?
I have a simple report (I posted it below) with list and two crosstabs. List contain only one record with summary of measure. first crosstab shows measure by organization dimension, second shows measure by question dimension.
When drilling on "Organization" item in first crosstab, the data in other crosstab and list in report should be affected.
the problem is that "Organization" item present only in one crosetab.
I don't know how to do this. I experimented along time. and nothing.
please, help me!
Thenks
<report xmlns="http://developer.cognos.com/schemas/report/7.0/" useStyleVersion="10" expressionLocale="en-us">
<modelPath>/content/folder[@name='SCM']/folder[@name='Food Safety']/folder[@name='Development']/folder[@name='Packages']/package[@name='pkg_food_safety_v01']/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><block>
<contents><promptButton type="back">
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="bp"/>
</defaultStyles>
</style>
</promptButton></contents>
</block><block>
<contents><list horizontalPagination="true" name="List1" refQuery="Query2">
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="ls"/>
</defaultStyles>
</style>
<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Inspection overall score"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Inspection overall score"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
</block><block>
<contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Query3">
<crosstabCorner>
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="xm"/>
</defaultStyles>
</style>
</crosstabCorner>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="xt"/>
</defaultStyles>
</style>
<crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Organizational entity" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Inspection overall score" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns></crosstab></contents>
</block><block>
<contents><crosstab horizontalPagination="true" name="Crosstab2" refQuery="Query4">
<crosstabCorner>
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="xm"/>
</defaultStyles>
</style>
</crosstabCorner>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="xt"/>
</defaultStyles>
</style>
<crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Section" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="CA count" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns></crosstab></contents>
</block></contents>
</pageBody>
</page>
</reportPages>
<promptPages><page name="Prompt Page1">
<pageBody>
<contents><selectWithTree parameter="OrgParameter" refQuery="Query1" required="false"><selectWithTreeItem refDataItem="Organizational entity"/></selectWithTree><promptButton type="finish">
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="bp"/>
</defaultStyles>
</style>
</promptButton></contents>
<style>
<defaultStyles>
<defaultStyle refStyle="py"/>
</defaultStyles>
</style>
</pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pp"/>
</defaultStyles>
</style>
</page></promptPages></layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="false" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><queries><query name="Query1">
<source>
<model/>
</source>
<selection><dataItemMember name="Organizational entity"><dmMember><MUN>[Dimention_View].[Sub locations].[Sub locations].[ARAMARK]->[all]</MUN><itemCaption>ARAMARK</itemCaption></dmMember><dmDimension><DUN>[Dimention_View].[Sub locations]</DUN><itemCaption>Sub locations</itemCaption></dmDimension><dmHierarchy><HUN>[Dimention_View].[Sub locations].[Sub locations]</HUN><itemCaption>Sub locations</itemCaption></dmHierarchy></dataItemMember></selection>
</query><query name="Query2"><source><model/></source><selection><dataItem name="Inspection overall score" aggregate="average" rollupAggregate="average"><expression>[Dimention_View].[Inspections].[Inspection overall score]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])'
)#</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sub locations].[Sub locations] in ([Organizational entity])</filterExpression></detailFilter><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query><query name="Query3"><source><model/></source><selection><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])',
'Children(',
'',
')'
)#</expression></dataItem><dataItem name="Inspection overall score" aggregate="average" rollupAggregate="average"><expression>[Dimention_View].[Inspections].[Inspection overall score]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query><query name="Query4"><source><model/></source><selection><dataItem name="Section" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Questions].[Questions].[Section]</expression></dataItem><dataItem name="CA count" aggregate="total" rollupAggregate="total"><expression>[Dimention_View].[Corrective actions].[CA count]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="9" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])'
)#</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sub locations].[Sub locations] in ([Organizational entity])</filterExpression></detailFilter><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query></queries><drillBehavior drillUpDown="true" modelBasedDrillThru="true"/><drillSetsBehavior><linkedDrillItemSets><linkedDrillItemSet name="Linked Data Items1"><linkedDrillItem refQuery="Query2" refDataItem="Organizational entity"/><linkedDrillItem refQuery="Query3" refDataItem="Organizational entity"/><linkedDrillItem refQuery="Query4" refDataItem="Organizational entity"/></linkedDrillItemSet></linkedDrillItemSets></drillSetsBehavior></report>
What do you mean by "affected"? Do you mean the other objects should be filtered based on the member you drill down on?
Regards,
MF.
Yes. you are right. I meant exactly this.
I found the solution. I added the "Organization" item to the each table and hide it where needed. but i don't like this solution. I think that there is another one more elegant without adding "Organization" item to each table.
<report xmlns="http://developer.cognos.com/schemas/report/7.0/" useStyleVersion="10" expressionLocale="en-us">
<modelPath>/content/folder[@name='SCM']/folder[@name='Food Safety']/folder[@name='Development']/folder[@name='Packages']/package[@name='pkg_food_safety_v01']/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><block>
<contents><promptButton type="back">
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="bp"/>
</defaultStyles>
</style>
</promptButton></contents>
</block><block>
<contents><list horizontalPagination="true" name="List1" refQuery="Query2">
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="ls"/>
</defaultStyles>
</style>
<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Organizational entity"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lc"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Organizational entity"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Inspection overall score"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Inspection overall score"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
</block><block>
<contents><crosstab horizontalPagination="true" name="Crosstab1" refQuery="Query3">
<crosstabCorner>
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="xm"/>
</defaultStyles>
</style>
</crosstabCorner>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="xt"/>
</defaultStyles>
</style>
<crosstabRows><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Organizational entity" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Inspection overall score" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns></crosstab></contents>
</block><block>
<contents><crosstab horizontalPagination="true" name="Crosstab2" refQuery="Query4">
<crosstabCorner>
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="xm"/>
</defaultStyles>
</style>
</crosstabCorner>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="xt"/>
</defaultStyles>
</style>
<crosstabRows><crosstabNode><crosstabNestedNodes><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="Section" edgeLocation="e1"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabNestedNodes><crosstabNodeMembers><crosstabNodeMember refDataItem="Organizational entity" edgeLocation="e3"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabRows><crosstabFactCell><contents><textItem><dataSource><cellValue/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="mv"/></defaultStyles></style></crosstabFactCell><crosstabColumns><crosstabNode><crosstabNodeMembers><crosstabNodeMember refDataItem="CA count" edgeLocation="e2"><style><defaultStyles><defaultStyle refStyle="ml"/></defaultStyles></style><contents><textItem><dataSource><memberCaption/></dataSource></textItem></contents></crosstabNodeMember></crosstabNodeMembers></crosstabNode></crosstabColumns></crosstab></contents>
</block></contents>
</pageBody>
</page>
</reportPages>
<promptPages><page name="Prompt Page1">
<pageBody>
<contents><selectWithTree parameter="OrgParameter" refQuery="Query1" required="false"><selectWithTreeItem refDataItem="Organizational entity"/></selectWithTree><promptButton type="finish">
<contents/>
<style>
<defaultStyles>
<defaultStyle refStyle="bp"/>
</defaultStyles>
</style>
</promptButton></contents>
<style>
<defaultStyles>
<defaultStyle refStyle="py"/>
</defaultStyles>
</style>
</pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pp"/>
</defaultStyles>
</style>
</page></promptPages></layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="false" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/></XMLAttributes><queries><query name="Query1">
<source>
<model/>
</source>
<selection><dataItemMember name="Organizational entity"><dmMember><MUN>[Dimention_View].[Sub locations].[Sub locations].[ARAMARK]->[all]</MUN><itemCaption>ARAMARK</itemCaption></dmMember><dmDimension><DUN>[Dimention_View].[Sub locations]</DUN><itemCaption>Sub locations</itemCaption></dmDimension><dmHierarchy><HUN>[Dimention_View].[Sub locations].[Sub locations]</HUN><itemCaption>Sub locations</itemCaption></dmHierarchy></dataItemMember></selection>
</query><query name="Query2"><source><model/></source><selection><dataItem name="Inspection overall score" aggregate="average" rollupAggregate="average"><expression>[Dimention_View].[Inspections].[Inspection overall score]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])'
)#</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query><query name="Query3"><source><model/></source><selection><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])',
'Children(',
'',
')'
)#</expression></dataItem><dataItem name="Inspection overall score" aggregate="average" rollupAggregate="average"><expression>[Dimention_View].[Inspections].[Inspection overall score]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query><query name="Query4"><source><model/></source><selection><dataItem name="Section" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Questions].[Questions].[Section]</expression></dataItem><dataItem name="CA count" aggregate="total" rollupAggregate="total"><expression>[Dimention_View].[Corrective actions].[CA count]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="9" output="no"/></XMLAttributes></dataItem><dataItem name="QA" aggregate="none" rollupAggregate="none"><expression>[Dimention_View].[Sources].[Sources].[Source]->[all].[2]</expression></dataItem><dataItem name="Organizational entity" aggregate="none" rollupAggregate="none"><expression>#prompt(
'OrgParameter',
'memberuniquename',
'rootMember ([Dimention_View].[Sub locations].[Sub locations])'
)#</expression></dataItem></selection><detailFilters><detailFilter><filterExpression>[Dimention_View].[Sources].[Sources]=[QA]</filterExpression></detailFilter></detailFilters></query></queries><drillBehavior drillUpDown="true" modelBasedDrillThru="true"><drillQueryBehavior refQuery="Query2"><drillDataItemBehavior refDataItem="Organizational entity"><drillUpBehavior><drillAncestor depthOffset="1"/></drillUpBehavior><drillDownBehavior><drillSimpleType type="replaceItem"/></drillDownBehavior></drillDataItemBehavior></drillQueryBehavior><drillQueryBehavior refQuery="Query4"><drillDataItemBehavior refDataItem="Organizational entity"><drillUpBehavior><drillAncestor depthOffset="1"/></drillUpBehavior><drillDownBehavior><drillSimpleType type="replaceItem"/></drillDownBehavior></drillDataItemBehavior></drillQueryBehavior></drillBehavior><drillSetsBehavior><linkedDrillItemSets><linkedDrillItemSet name="Linked Data Items1"><linkedDrillItem refQuery="Query2" refDataItem="Organizational entity"/><linkedDrillItem refQuery="Query3" refDataItem="Organizational entity"/><linkedDrillItem refQuery="Query4" refDataItem="Organizational entity"/></linkedDrillItemSet></linkedDrillItemSets></drillSetsBehavior></report>