1 / 16

Best Practices & Tips

Best Practices & Tips. Integrating Cognos Finance With Cognos Planning. Presenters. Gary Quirke Sandy Midili. Agenda. Quick overview of Cognos EP Why EP and CF Integration Challenges Integration Tips and Tricks Questions. Quick Overview of EP.

daria
Download Presentation

Best Practices & Tips

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Best Practices & Tips Integrating Cognos Finance With Cognos Planning

  2. Presenters Gary Quirke Sandy Midili

  3. Agenda • Quick overview of Cognos EP • Why EP and CF • Integration Challenges • Integration Tips and Tricks • Questions

  4. Quick Overview of EP • Enterprise Budgeting and Forecasting • High Participation Web based planning • Central database: Oracle/SQL Server • “Owned” by Finance • Library of Specialized Planning Functions • Driver Based Planning • Integrated with C8 BI and CF

  5. Quick Overview of EP • Excel-based reporting • Limited Financial Consolidation • Does not support multiple hierarchies • Some Integration challenges with CF

  6. Quick Demo EP

  7. Why CF and EP? • Scenario 1: Own CF want EP • Scenario 2: Own EP want CF • Scenario 3: Buy CF & EP together

  8. Challenges • Avoiding two maintenance processes • Single Cube (CF) Vs Multi-Cube (EP) • CF/EP Meta data differences • Transferring data between CF/EP • Picking the best of both worlds

  9. Tips: Minimizing Maintenance • One Source: D-List Update & Import from Ledger • Database (ERP, Data warehouse, etc) • Excel • Single point Maintenance Process • For example Cognos Manager • Use CF as Financial data Mart • Aggregation of Actual to Forecast level of detail • Storage of Planning Versions as submissions

  10. Tips: Single Vs Multi Cube

  11. Tips: CF/EP Meta data • Best Case • Consistent IDs and Names in CF/EP • Combined ID + Name <= 50 Characters • Next Best • Use only IDs in EP Integration Cube • All Else Fails • Use Names • But ensure unique names in CF

  12. Demo Tips & Tricks

  13. Tips: Best of Both Worlds • CF • Allocations (where possible) • Currency Translation (where possible) • Version Control • Financial Consolidation (always!) • Storage of Detailed Actuals • EP • Financial Modeling & Forecasting • Headcount & Salary Planning • Capital Planning • Driver Based and Advanced Planning • Planning beyond Finance • High Participation Planning

  14. Questions? Gary Quirke e:gquirke@quebit.com t: 646-623-8383 Sandy Midili e:smidili@quebit.com t: 732-674-1410 http://www.QueBIT.com

More Related