...

Guidelines to IBM Cognos Controller Standard Reports Guideline

by user

on
Category: Documents
6

views

Report

Comments

Transcript

Guidelines to IBM Cognos Controller Standard Reports Guideline
Guideline
Guidelines to IBM Cognos
Controller Standard Reports
Product(s): IBM Cognos Controller
Area of Interest: Financial Management
Guidelines to IBM Cognos Controller Standard Reports
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]
Adobe, the Adobe logo, PostScript, and the PostScript logo are either registered
trademarks or trademarks of Adobe Systems Incorporated in the United States,
and/or other countries.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft
Corporation in the United States, other countries, or both.
Guidelines to IBM Cognos Controller Standard Reports
3
Contents
1
INTRODUCTION ............................................................................................ 3
1.1
1.2
1.3
PURPOSE ................................................................................................................ 3
APPLICABILITY ......................................................................................................... 3
EXCLUSIONS AND EXCEPTIONS ..................................................................................... 3
2
SAMPLE REPORTS ......................................................................................... 4
2.1
2.2
2.3
2.4
2.5
2.6
2.7
TRIAL BALANCE WITH DRILL DOWN ............................................................................... 4
THE LEDGER REPORT................................................................................................. 5
JOURNALS ACROSS REPORT ......................................................................................... 6
JOURNALS REPORT .................................................................................................... 7
ACQUISITIONS CALCULATION REPORT ............................................................................ 8
INTERCOMPANY RECONCILIATION REPORT ...................................................................... 9
RECONCILE BETWEEN ACCOUNTS/OPENING BALANCES ....................................................... 10
3
REPORTS ON METADATA ............................................................................ 11
3.1
3.2
3.3
3.4
3.5
ACCOUNT STRUCTURE.............................................................................................. 11
COMPANY STRUCTURE ............................................................................................. 12
SYSTEM AUDIT LOG ................................................................................................ 13
VERIFY STRUCTURES: .............................................................................................. 14
USER RIGHTS AND SECURITY GROUP ............................................................................ 14
1 Introduction
1.1
Purpose
To list the standard reports that are available with Controller 8.1 or higher.
1.2
Applicability
Controller 8.1 and 8.2
1.3
Exclusions and Exceptions
There are no known exceptions and exclusions at the time this document was
created.
Guidelines to IBM Cognos Controller Standard Reports
4
2 Sample Reports
2.1
Trial Balance with Drill Down
a) The trial balance allows to have a complete view of the data for a specific
form (Balance sheet, profit and loss, disclosures,…) or for a specific account.
The content of the columns can be the companies of the selected group or
the closing/contribution versions.Note that you can select the drilldown in
order to trace the figures until the more detailed info.
You can make a drill by account, by company, by journal type, by automatic
journal type, by journal number, by dim, by counter company and by counter
dim.
Guidelines to IBM Cognos Controller Standard Reports
2.2
5
The Ledger Report
a) The ledger report allows you view in details the amount of an account for a
specific closing version and contribution version. This report can be selected
for a specific group and all these companies or for a specific company. There
are different report selections (by company, by account, by movement,…)
and this report can be launched for specific accounts or for a specific form.
The report will show the figures of the period, of the previous year and the
difference.
b) Example of ledger report by account launched on a Balance Sheet Form:
Guidelines to IBM Cognos Controller Standard Reports
2.3
6
Journals Across Report
a) This report allows you to see for a company or for a group the evolution of
the data for a specific closing version and contribution version. In column you
can ask to view the evolution by manual journal types or by automatic journal
types. This report is launched on forms (balance sheet, profit and loss,…)
b) Example of a journal across report by automatic journals for a Balance Sheet
Form
Guidelines to IBM Cognos Controller Standard Reports
2.4
Journals Report
a) This report allows you to see on a “debit-credit configuration the manual
journals and automatic journals. There are several selections possible (by
journal, by account, by date ,…)
b) Automatic Journal Example
7
Guidelines to IBM Cognos Controller Standard Reports
2.5
Acquisitions Calculation Report
a) This report allows a general view of the acquisition calculation.
b) Example, Group Net Value
8
Guidelines to IBM Cognos Controller Standard Reports
2.6
Intercompany Reconciliation Report
a) This report allows view of the matching of intercompany balances
between companies.
9
Guidelines to IBM Cognos Controller Standard Reports
2.7
10
Reconcile between accounts/opening balances
a) This report allows you to see the reconciliation differences based on
control build in the account structure.
b) It can be reconciliation between accounts, between opening balances
and ending balances of the previous year and debit/credit control.
c) An example of reconciliation report
Guidelines to IBM Cognos Controller Standard Reports
11
3 Reports on Metadata
3.1
Account Structure
a) This report allows, through different views, to see the configuration of
the accounts.
Guidelines to IBM Cognos Controller Standard Reports
b) Example sorted by account
3.2
Company Structure
12
Guidelines to IBM Cognos Controller Standard Reports
13
a) This report allows you to see the configuration of the company structure.
b) Example of a tree structure:
3.3
System Audit Log
a) This report allows you to track changes in metadata “who/what/when”
Guidelines to IBM Cognos Controller Standard Reports
3.4
Verify Structures:
a) Example of forms verification report:
3.5
User rights and security group
14
Guidelines to IBM Cognos Controller Standard Reports
a) Report allows you to see set up of user rights and security group
b) Example of the user rights on approval of journals
15
Fly UP