IBM Controller

IBM Controller

Software that supports the close, consolidate and report process

 View Only

Cognos Controller Proven practices documents

By FRASER ANDERSON posted Mon April 24, 2017 10:43 AM

  
Here's a listing of the Cognos Controller Proven Practices documents for your reference.

Application settings:




  • Guidelines to using change tables:


http://www.ibm.com/support/docview.wss?uid=swg21999354.




  • Guidelines to using Z consolidation method:


http://www.ibm.com/support/docview.wss?uid=swg21999351.




  • Guidelines to using company and group journals:


http://www.ibm.com/support/docview.wss?uid=swg21999349.




  • Guidelines to using Calculation accounts


http://www.ibm.com/support/docview.wss?uid=swg21999352


Consolidation settings:




  • Guidelines to currency translation


http://www.ibm.com/support/docview.wss?uid=swg21998446 .




  • Guidelines to using historical rates


http://www.ibm.com/support/docview.wss?uid=swg21998450.




  • Guidelines to general configuration, account structure and automatic journals


http://www.ibm.com/support/docview.wss?uid=swg21998442 .




  • Guidelines to configuring intercompany profit


http://www.ibm.com/support/docview.wss?uid=swg21998386.




  • Guidelines and examples of allocations


http://www.ibm.com/support/docview.wss?uid=swg21999091




  • Guidelines to eliminating gain or loss on sales of fixed assets


http://www.ibm.com/support/docview.wss?uid=swg21999090 .




  • Investment elimination using currency conversion method 2


http://www.ibm.com/support/docview.wss?uid=swg21999093.


Import and export:




  • Guidelines to importing structures:


http://www.ibm.com/support/docview.wss?uid=swg21999355




  • Guidelines to importing structures using staging tables and SQL server


http://www.ibm.com/support/docview.wss?uid=swg22000747.




  • Guidelines to importing data:


http://www.ibm.com/support/docview.wss?uid=swg21998671




  • Guidelines to importing data using IIF function:


http://www.ibm.com/support/docview.wss?uid=swg22000744.




  • Guidelines to setting up and using look-up tables


http://www.ibm.com/support/docview.wss?uid=swg22000741.




  • Guidelines to importing data using lookup splits:


http://www.ibm.com/support/docview.wss?uid=swg22000728.




  • Guidelines to loading non-cumulative monthly data


http://www.ibm.com/support/docview.wss?uid=swg22000752.




  • Guidelines on handling intercompany balances when the counter company is the actual general ledger account number.


http://www.ibm.com/support/docview.wss?uid=swg21999092.




  • Guidelines to importing journals


http://www.ibm.com/support/docview.wss?uid=swg22000745.




  • Guidelines to importing data from TM1


http://www.ibm.com/support/docview.wss?uid=swg22000757.


Financial reporting:




  • Building notes to financial statements


http://www-01.ibm.com/support/docview.wss?uid=swg21998444




  • Guidelines to designing efficient report in excel link


http://www-01.ibm.com/support/docview.wss?uid=swg22000900


Other:




  • How to improve performance


http://www-01.ibm.com/support/docview.wss?uid=swg21690080




  • How to maintain and optimize Controller SQL database


http://www-01.ibm.com/support/docview.wss?uid=swg21396973




  • How to reduce the size of a Controller database by deleting data from XDBTRICKLE


http://www-01.ibm.com/support/docview.wss?uid=swg21624409



0 comments
114 views

Permalink

Comments

Currently no comments.