...

Model Review Tool Proven Practice Product(s): IBM Cognos 8 Contributor

by user

on
Category: Documents
1

views

Report

Comments

Transcript

Model Review Tool Proven Practice Product(s): IBM Cognos 8 Contributor
Proven Practice
Model Review Tool
Product(s): IBM Cognos 8 Contributor
Area of Interest: Modeling, Performance
Model Review Tool
2
Copyright and Trademarks
Licensed Materials - Property of IBM.
© Copyright IBM Corp. 2009
IBM, the IBM logo, and Cognos are trademarks or registered trademarks of
International Business Machines Corp., registered in many jurisdictions worldwide.
Other product and service names might be trademarks of IBM or other companies. A
current list of IBM trademarks is available on the Web at
http://www.ibm.com/legal/copytrade.shtml
While every attempt has been made to ensure that the information in this document
is accurate and complete, some typographical errors or technical inaccuracies may
exist. IBM does not accept responsibility for any kind of loss resulting from the use of
information contained in this document. The information contained in this document
is subject to change without notice.
This document is maintained by the Best Practices, Product and Technology team.
You can send comments, suggestions, and additions to [email protected]
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft
Corporation in the United States, other countries, or both.
IBM Proprietary
Model Review Tool
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
PURPOSE ............................................................................................................ 4
APPLICABILITY ..................................................................................................... 4
2
GENERATING A REPORT ............................................................................... 4
3
REPORT CONTENTS....................................................................................... 6
IBM Proprietary
Model Review Tool
4
1 Introduction
1.1
Purpose
The Model Review Tool was developed to provide documentation for
applications as well as to help highlight design issues which may affect model
stability and performance.
It can be downloaded here Model Review Tool
1.2
Applicability
The Model Review Tool is a utility that when executed against the Production
XML of a Contributor Model will generated a detailed report based on Model
statistics. It will determine the size of objects in the model which may slow
response times such as large Access Tables or Cubes.
The Model Review Tool has been designed to work with IBM Cognos 8
Planning 8.4, however it has been successfully tested on all currently
supported versions of IBM Cognos 8 Planning.
2 Generating a Report
The Model Review Tool is a self contained utility that is in a zip file attached
to this document. When unzipping be sure to maintain the folder structure.
The Model Review tool is executed via the command line calling the
ModelReviewTool.bat file seen above.
You will need to navigate via command line to the location you have unzipped
the Model Review Tool.
IBM Proprietary
Model Review Tool
5
Once you have browsed to the correct location of the ModelReviewTool.bat
location you need to supply the batch file name and the necessary switches.
Switch one is –f <modelxml path> which will supply the Model Review Tool
the production XML file location. The second switch –s <1 or 0> informs
the Model Review tool if you want to include Sparcity data as part of your
report. 1 = Create Sparcity Report 0 = Do Not.
Including Scarcity data will take a great deal more time to generate, but will
supply valuable data about cube usage.
An example where Sparcity will be included in the report.
After executing the command a report will be generated as an html file and
saved in the same location as the Production XML file. The file is given the
same name as the production xml file with _report.html appended to the end.
Once the Model Reviewer Tool has completed its task it will return to the
command prompt.
IBM Proprietary
Model Review Tool
6
3 Report Contents
The first section of the report will provide a summary of the model, as well as
the time to unpack.
Section two will contain the top 25 Objects in terms of size that are contained
in the model. You are provided with the total file size of the XML file, as well
as the Object Types, the Object Size the percentage of the total size the
object consumes as well as the name. For example we can see that a Simple
1 Accounts Hierarchy contains 7.58kb and 6.42% of the overall model size.
IBM Proprietary
Model Review Tool
7
Section three contains ELIST details from the model. A break down of the
number of levels, the number of reviews and contributors as well as the avg
contributors rolling into parents.
Also you will find the top 10 parents with the most children rolling into them.
In this example you will note e.list item Corporate has only 6 direct children
falling well within recommended guidelines.
IBM Proprietary
Model Review Tool
8
The forth section provides the top 10 reviewer nodes who have the greatest
review debt. For example the Total e.list item has a review debt that
contains 10 e.list items. If the user was to have Multi e.List item views
turned on it would try and load the details for every e.list in its review debt.
If the review debt was much greater for instance 50+ the user experience
while trying to navigate this many e.list items would be slow and difficult.
Review/View debt may also affect a Reconcile perform off a GTP. It must
resolve the node access table which may take an excessive amount of
memory. Best practice would be to have the Review/View debt set to no
more than two levels.
The fifth section provides the Maximum space required to resolve cell-level
access for the Node with Maximum Children. For example the Comm Costs
requires .2kb of memory to resolve the cell level access. We also see a total
.68 kB of memory is consumed opening this node.
IBM Proprietary
Model Review Tool
9
Section six breaks down the size of each cube, and provides details whether
the cube is hidden not. It also tells whether the cube is an assumption cube
non-assumption. Within Cube Calculation the colouring of the cell indicates
the calculation is ran outside of the JCE memory as a disk based calculation.
Section eight provides a break down of the cube and dimensions mappings.
We are presented with a table that allows us to easily see which dimension
belongs to which cube, as well the highlighted box provided the order the
dimension is added in the cube.
Section nine provides information about the dimensions themselves. Each
dimension is listed as well as the number of items it contains. A drop down is
provided that displays the elements of the dimensions.
IBM Proprietary
Model Review Tool
10
D.Link details are provided in the next section. The link name, the source
cube and target cube are given as well as the link type. You can also gather
the volume of cells being read from the source cube, and the volume inserted
into the target cube. For example in the link Corp Exp<Travel Costs the
source cube travel costs is having 960 cells read, and the target cube
Corporate Expenses is having 960 cells inserted.
Next we see Cube – Dlink Mappings
IBM Proprietary
Model Review Tool
11
This section provides us with a table displaying the Dlink’s present, and which
cubes are linked together. For example we can see that the Travel Costs
cubs is being targeted by a link from Corporate Expenses. The link name is
shown in the intersecting box.
This section provides the size of the master model, as well as the size the
runtime model. It also provides a quick break down of the number of
contribution and review nodes, the average number of contribution nodes per
view, and the Avg size, Total Size, and Total Time of a View.
This information is valuable when trying to determine the reason for slow
down times when loading the grid on the website.
Section ten is the optional sparcity section.
In the below example what we see is 100% of the nodes in an e.list have 91100% of the cells in the cubes visible to them. So in essence everyone can
see everything.
IBM Proprietary
Model Review Tool
12
The Percentage of Cells Used refers to the number of cells in the cubes of the
model that has read/write access rights.
The Node Count refers to how many nodes in the e.list that have read
read/write access rights for a particular percentage of cells in the model.
This may be a review node or contribution node.
The Percentage of Node is generated by dividing the node count by the total
number of notes * 100.
IBM Proprietary
Fly UP