Oracle Narrative Reporting

Information about Oracle Narrative Reporting

Published on January 22, 2020

Author: bispsolutions

Source: authorstream.com

Content

slide 1: www.bispsolutions.com Page 1 Oracle Narrative Reporting Creating Balance Sheet Report with Oracle PBCS Version History Version Date dd / mmm / yyyy Modification Author 0.1 5th / Jan / 2020 Initial document Neeraj Soni 0.1 5th / Jan / 2020 Review Amit Sharma slide 2: www.bispsolutions.com Page 2 Table of content Introduction .............................................................................................................................................................. 3 Narrative Reporting in Financial Reporting .......................................................................................................... 3 Creating Balance Sheet Report With Oracle PBCS as Source ............................................................................ 4 Step1: Create Database connection ..................................................................................................................... 4 1.1 Select Oracle Enterprise Performance Management Cloud as Data Source Type. ..................................... 4 1.1 Provide connection details as give below and Test Connection .................................................................. 5 Step2 Create Report ............................................................................................................................................. 5 2.1 Select Report Card and add one Grid. .......................................................................................................... 5 2.2 Select Data Source ....................................................................................................................................... 6 2.3 Oracle PBCS Account Hierarchy Mapping with Narrative Reporting Grid Elements. .................................. 6 2.4 Select Point of View as given below ............................................................................................................. 7 2.5 Insert Custom Text ....................................................................................................................................... 8 2.6 Insert Data Rows .......................................................................................................................................... 8 2.7 Select Balance Sheet Account Dimension Members in Row ....................................................................... 9 2.8 Select Children of YearTotal as Column ..................................................................................................... 11 2.9 Select Alias for Heading.............................................................................................................................. 11 2.10 Define formatting “Border Style” and Cell Formatting ............................................................................ 11 2.11 Add Text in Grid as Report Header. ......................................................................................................... 12 2.12 Select Text Functions. .............................................................................................................................. 12 2.13 Select Member Alias as Text Function. .................................................................................................... 12 Step3 Preview Report ............................................................................................................................................ 13 Key Problems with Manual Narrative Reporting ..................................................................................................... 14 slide 3: www.bispsolutions.com Page 3 Introduction Narrative Reporting is a purpose-built business process available in the Oracle EPM Cloud for management narrative and regulatory reporting. It provides a secure collaborative process-driven approach for defining authoring reviewing and publishing financial and management report. When the data is combined with narrative you gain actionable insight. Moreover data access plus data integration provides “one version of the truth” on a single reporting platform. ➢ Combining Data “What” with Business Commentary Who When Where and/or Why. ➢ Presented in expository and descriptive paragraphs as opposed to just tables and charts. Narrative Reporting in Financial Reporting Narrative reporting is used with financial statements it provides users with historical explanations of the entity’s financial position financial performance and cash flows as well as commentary on an entity’s prospects objectives strategies targets and other forward-looking information. Narrative reporting is used with financial disclosures in order to provide useful information to aid the third party in their decision making and promote a meaningful report. slide 4: www.bispsolutions.com Page 4 Creating Balance Sheet Report With Oracle PBCS as Source In the below example I have created a Balance Sheet Report with Oracle PBCS as source. Step1: Create Database connection 1.1 Select Oracle Enterprise Performance Management Cloud as Data Source Type. slide 5: www.bispsolutions.com Page 5 1.1 Provide connection details as give below and Test Connection Step2 Create Report 2.1 Select Report Card and add one Grid. slide 6: www.bispsolutions.com Page 6 2.2 Select Data Source 2.3 Oracle PBCS Account Hierarchy Mapping with Narrative Reporting Grid Elements. Left side is the Oracle PBCS Account Hierarchy and right side mapping with Grid Elements. The output will appear as below. slide 7: www.bispsolutions.com Page 7 The default selection is as below Row Account and ColumnPeriod 2.4 Select Point of View as given below In the below example variables references are used instead of actual member names. slide 8: www.bispsolutions.com Page 8 Final list of Point of view is as fellows. 2.5 Insert Custom Text In the grid custom heading can be added. ASSETS as used as Custom Text 2.6 Insert Data Rows slide 9: www.bispsolutions.com Page 9 2.7 Select Balance Sheet Account Dimension Members in Row Use member selector and select Children of Assets Liabilities and owner’s equity as given below. slide 10: www.bispsolutions.com Page 10 Final List of All Account members given below 1 Children of OFS_Total Current Assets 2 OFS_Total Current Assets 3 Children of OFS_Total Non Current Assets 4 OFS_Total Non Current Assets 5 OFS_Short Term Investment - Calc to Balance 6 OFS_Total Assets 7 Children of OFS_Total Liabilities 8 OFS_Total Liabilities 9 Childre of OFS_Total Equity 10 OFS_Total Equity 11 OFS_Short Term Borrowing - Calc to Balance 12 OFS_Total Liabilities and Equity slide 11: www.bispsolutions.com Page 11 2.8 Select Children of YearTotal as Column 2.9 Select Alias for Heading 2.10 Define formatting “Border Style” and Cell Formatting slide 12: www.bispsolutions.com Page 12 2.11 Add Text in Grid as Report Header. 2.12 Select Text Functions. 2.13 Select Member Alias as Text Function. slide 13: www.bispsolutions.com Page 13 Step3 Preview Report Run report and see below final output. Final Mapping. slide 14: www.bispsolutions.com Page 14 Key Problems with Manual Narrative Reporting Errors are made in combining data what with narrative who when why especially with rekeying data into the report. In addition organizations lack the ability to analyze the data to validate the narrative. The disconnected nature of the process means it is difficult to bring subject-matter experts into the process for centralized commentary on content. This also makes it harder to track progress and to see who is currently responsible for individual areas of content.

Related presentations


Other presentations created by bispsolutions