![Page 1: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/1.jpg)
•
Current reporting structure in OCBC.
Present the reporting solutions enhancements in MX.3
Discuss the scope of the reporting.
Describe the approach, with the possible scenarios forthe reporting solution
UDM
![Page 2: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/2.jpg)
![Page 3: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/3.jpg)
![Page 4: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/4.jpg)
![Page 5: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/5.jpg)
![Page 6: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/6.jpg)
Groups and access rights
• Changes:– Supervisor’s new restricted role– Admin has disappeared– Users are not attached to Desks anymore
• Different activities– Configuration profile– Housekeeping profile– End user profile:
• Front office• Middle office• Back office
![Page 7: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/7.jpg)
Supervisor
• Defines the login of all individual users.
• Defines user groups: – which group may perform which action
(activity),– which users belong to which group
![Page 8: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/8.jpg)
Groups and access rights
• Configuration profile:– Specific configuration functions that reflect system organisation
(user definable fields definition, workflow configuration, SI definition, etc.)
– Ability to create several config profiles (organisation, reports, processing scripts, etc…)
• Housekeeping profile– Specific maintenance functions, affecting the whole system
(purge, portfolio reallocation, etc.) – Attached to an entity set– Ability to create several housekeeping profiles
• End user profile:– Regular Mx application activity (financial instrument definition,
pricing, simulation, etc.) – Front office, Middle office or Back office
![Page 9: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/9.jpg)
Configuration
![Page 10: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/10.jpg)
Supervisor Configuration
![Page 11: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/11.jpg)
Admin Configuration
![Page 12: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/12.jpg)
Housekeeper
• Initialize– Payments– Fixings– Accounting
• Refresh– Trade Scan & Modify– Payment Scan & Update
• Rename– Portfolio Reallocate– Counterpart reallocate & Rename
• Purge– Audits trails– Trades logical/physical purge
![Page 13: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/13.jpg)
End user
• Rights– General rights
• Navigation: for Housekeeper & Configuration• Access on Modules: “old” general rights, now by templates• Access on services: “old” Supervisor>Rights>Mx Services
– Portfolios: Portfolio rights (for FO/BO users)– Counterparts: assignment of Chinese Wall template– Trades: “old” rights by status– Users– Scripts: assignment of processing script template– Reporting: assignment of Reporting template (New Datapublisher
module, does not apply to MReports)– Middle office: Entity sets rights (for MO and Housekeeping users)– Others: Rights on filters/views/output devices– Preference list: IAS39 module– Classifications: Asset Management module
![Page 14: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/14.jpg)
Viewer
• Powerful tool to slice and dice vast amounts of data
• Mx Viewer consists in a data dictionary that contains all outputs and breakdowns available in a given context (eg all sensitivities and P&L data of a portfolio)
• Pick up any output and select the aggregation criteria in the list of breakdowns
• Can output to Datamart table– possibility of building reports on Viewer output
![Page 15: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/15.jpg)
Viewer
![Page 16: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/16.jpg)
Viewer
![Page 17: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/17.jpg)
Formulae Editor LayoutFormulae Editor Layout
![Page 18: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/18.jpg)
![Page 19: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/19.jpg)
![Page 20: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/20.jpg)
![Page 21: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/21.jpg)
![Page 22: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/22.jpg)
![Page 23: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/23.jpg)
![Page 24: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/24.jpg)
![Page 25: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/25.jpg)
![Page 26: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/26.jpg)
•Approach•Impacted Feeds•PnL Flow Diagram•Cash Flow Diagram•PL Greek and SV Diagram•Table Structure
![Page 27: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/27.jpg)
1.) Segregate PL, Cash flow, PL Greeks & SV ( All Entity) and TP PL, Cash flow, PL Greeks & SV ( All Entity) fields into different tables.
2.) Segregate Live ( All Entity) and Dead ( All Entity) trades into different tables.
3.) TP fields will be generated once and can be used by all other feeds whereever required. eg cashflow,Pl greeks etc.
4.) Python feeds to be flown in same MXG tables through Database link.
Approach
![Page 28: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/28.jpg)
Impacted Feeds
1.) Profit and Loss tables
(PnL).
2.) Cash flow.
3.) PL Greek.
4.) Sensitivities.
![Page 29: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/29.jpg)
![Page 30: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/30.jpg)
![Page 31: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/31.jpg)
![Page 32: Current reporting structure in OCBC. Present the reporting solutions enhancements in MX.3 Discuss the scope of the reporting. Describe the approach, with](https://reader035.vdocuments.us/reader035/viewer/2022081503/56649ec55503460f94bd04bc/html5/thumbnails/32.jpg)
Table Structure
• PL
• Cash flow
• PL Greeks & SV
• Python same as MXG
Cash Flow
PLGreek and SV
PL