webinar: how to make hyperion financial reports do what you want them to do
TRANSCRIPT
Emtec, Inc. Copyright © 2016. All Rights Reserved.
Presented by Christie Koza
December 2016
Make Financial Reports Do What You Want Them To Do
2
Oracle Focus20 Year Oracle Focus
Platinum Partner
2,500+ Projects
100+ Cloud Clients
Run Cloud Internally
Offshore Lab & Support Center
3
CONFIDENTIAL | © 2016 Emtec, Inc.
What We Do
Advisory
Strategy, planning and
process improvements
that ensure measurable ROI
Applications
Mission critical applications that
empower your employees,
partners and clients
Infrastructure
Optimized IT architecture to
deliver powerful user experiences
and extreme performance
Analytics
Integrated data for powerful
insights and more informed decision
making, on any device
Services that deliver rapid, meaningful and lasting business value.
Agenda• Introduction
• Design Considerations
• Metadata Structures
• Text/Commentary
• Charts and Reports
• Creative Solutions
5
CONFIDENTIAL | © 2016 Emtec, Inc.
Introductiono Frustrated with making Financial Reporting do exactly what
you want it to do?
o Capability of financial reporting.
o Methods to make your FR reports look and behave the way you would like.
o How to make your reports as dynamic and flexible as possible.
o It CAN be done!
6
CONFIDENTIAL | © 2016 Emtec, Inc.
Design Considerations for Enterprise Report Developmento Create standardized report templates that can be re-used
Get formatting standards from client – font sizes, headers, footers, etc.
Report writers can take these templates as starting points and not have to create every report from scratch.
o If your rows or columns contain multiple dimensions, put the dense dimensions first.
o Minimize the number of dimensions in the grid. Single-member dimensions should be in the Grid Point of View (POV) or the Report POV.
Hardcode (and hide) dimensions that are for system use and may not make ‘sense’ to the user.
o Use substitution variables to minimize selections for the user.
o Use Same As instead of selecting member / sub var in each row/column.
o Use Grid POVs to limit Page members that can cause long run time.
o Use Prompts to allow users to select members from a limited list.
o Use Related Content to guide the user interaction with reports (summary to detail links).
o Consider user experience – setting Preferences, selecting POV, Prompts.
7
CONFIDENTIAL | © 2016 Emtec, Inc.
Grido Standard P&L grid – Period and YTD
o Formatting
Gray font for hidden rows/columns or some other visual indicator.
Insert a space to align positive numbers when using ( ) for negative.
Be conscious of “overlapping” formats that may cancel each other out – not always evident in format editor.
o Dynamic References
Same As….
Current POV
Substitution Variables
Functions (e.g. Relative Member)
o Dimension Layout
Use Grid POV for single members and “system” members.
8
CONFIDENTIAL | © 2016 Emtec, Inc.
Add Metadata to Facilitate Reporting
o Ever find yourself in report building situations where metadata structures do not easily support constructing reports?
o So what do we do in FR?
Workarounds
Complex report formulas
Hardcode reports – potentially causing large quantities of reports
o A better solution ? Leverage your metadata structures to make reports dynamic.
This requires a holistic approach to report design and creation.
o Examples
Dynamic member formulas on dimension members instead of report formulas Percent of Sales, Statistical Accounts
UDAs, attributes, alternate hierarchies, Smart Lists
9
CONFIDENTIAL | © 2016 Emtec, Inc.
Text / Commentaryo Situation – need to include variance comments or other text information on a report.
o Solution Use a metadata member to hold information – Account dimension in example.
Create Planning web forms for user commentary entry (can also use this method to load any other supplemental text)
o Pull the comments into the Financial Report Create a column with the correct intersection. Format to use white font or Replace (with a blank space) to
mask the column data. OR
Hide the column and use “GetCell” function in FR Studio to pull the text information/commentary into the grid.
10
CONFIDENTIAL | © 2016 Emtec, Inc.
Financial Reports – Charts
o STRENGTHS
Visual aid to support grid data
Variety of chart formats (line, bar, pie, etc)
Show data from one data source in chart and another data source in grid
Re-use chart object once you get it set up/formatted
o WEAKNESSES
Functionality not as robust as Excel
Limited format /customization capabilities
Sizing / positioning is manual
Resolution is not as advanced as other cutting edge tools
Legend members can only be stacked (client)
o Graphs are not often used in Financial Reports due to lack of training and perceived complexity.
o However, charts can be leveraged to make them do what you want them to.
11
CONFIDENTIAL | © 2016 Emtec, Inc.
Chart – Line Drops to Axis in ‘Empty’ Monthso Situation - in a line or combo chart, the line drops to the axis when there is no data
o Solution Use conditional formatting on row/cells to replace Zero/NoData/#Missing with ‘Null’
12
CONFIDENTIAL | © 2016 Emtec, Inc.
Dual Grids / Cross-Referenceo Situation – you want to show data from another cube, or a different dimension
layout than the main grid
o Solution Insert a hidden grid that pulls the correct intersection of data.
In the main grid, add formula rows to reference the hidden grid row/column/cell.
Syntax = GridX. ( row, column, page reference ) e.g. Grid2. ( [ 1 ] ) or Grid2. ( [ B ] ) or Grid2. ( [ B,1 ] )
13
CONFIDENTIAL | © 2016 Emtec, Inc.
Report Books: Add a Cover Page to a Booko Often, a client wants a cover page before the Table of Contents
o Add a cover page in the Book Editor1. First, import into Workspace > Explore the Word or PDF that will be the cover page.
2. In Workspace Explore, right click the book name and select Open In > Editor.
3. Select the PDF file or Word file you imported.
4. In the lower pane containing the object settings, find the Value column.
5. Click the arrow in the row for Cover Page, and then select Yes. It is moved to the top of the book objects list and is marked with a star to indicate that it is the cover page.
14
CONFIDENTIAL | © 2016 Emtec, Inc.
Other Creative Solutions for Client Specific Requirements
o Changing decimal precision in charts – single or dual axis (modification of xml
o Multiple charts in a report
o Multiple grids with different data sources
o Aligning color schemes in a combo chart
o Use of special characters to display symbols (on premise)
o Conditional formatting to evaluate results against targets or other comparisons
o Rolling month/quarter reports using trigger columns and conditional suppression
o Auto Calculation feature to provide dynamic subtotal, average, etc.
o Related Content – setup and flow
Q&A
Get in TouchLet’s get started!
20 N. WACKER DR.
SUITE 2050@EMTECINC WWW.EMTECINC.COM 800 - 800 - 8805
Christie Koza – [email protected]
Thank You