Ibm cognos

cGuideline

Advanced Multidimensional Reporting
Product(s): IBM Cognos 8 Report Studio Area of Interest: Report Design

Advanced Multidimensional Reporting

2

Copyright Copyright © 2008 Cognos ULC (formerly Cognos Incorporated). Cognos ULC is an IBM Company. While every attempt has been made to ensure that the information in this document is accurate and complete, some typographicalerrors or technical inaccuracies may exist. Cognos does not accept responsibility for any kind of loss resulting from the use of information contained in this document. This document shows the publication date. The information contained in this document is subject to change without notice. Any improvements or changes to the information contained in this document will be documented in subsequenteditions. This document contains proprietary information of Cognos. All rights are reserved. No part of this document may be copied, photocopied, reproduced, stored in a retrieval system, transmitted in any form or by any means, or translated into another language without the prior written consent of Cognos. Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in theUnited States and/or other countries. IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both. All other names are trademarks or registered trademarks of their respective companies. Information about Cognos products can be found at www.cognos.com This document is maintained by the Best Practices, Product and Technologyteam. You can send comments, suggestions, and additions to cscogpp@ca.ibm.com .

IBM Cognos Proprietary Information

Advanced Multidimensional Reporting

3

Contents
1 2 3 3.1 3.2 3.3 4 4.1 4.2 4.3 4.4 5 6 6.1 6.1.1 6.1.2 6.1.3 6.1.4 6.2 6.3 INTRODUCTION ............................................................................................ 4 SEGMENTATION OF DATA............................................................................. 4 FILTERING .................................................................................................... 6 FILTER CONTEXT...................................................................................................7 SORTING............................................................................................................8 RANKING ............................................................................................................8 COMPLEX AXIS DEFINITION ...................................................................... 10 LAYOUT SPECIFICATION ........................................................................................ 10 NESTING.......................................................................................................... 10 UNIONING ........................................................................................................ 12 PERFORMANCE ................................................................................................... 14 SUMMARY ................................................................................................... 15APPENDICES ............................................................................................... 16 APPENDIX A - MULTIDIMENSIONAL MODELS ................................................................ 16 What is a member?.......................................................................................... 16 Dimensions and facts....................................................................................... 16 Hierarchies and levels ...................................................................................... 16 Set Expressions ............................................................................................... 18 APPENDIX B – ADVANCED RANKING EXAMPLES ............................................................. 19 APPENDIX C – COMPLEX AXIS EXAMPLE...