Financial Reporting Tutorial

(1)

Internal

Internal Document Document 11 Introducti

Introduction to on to FinanciFinancial Reportingal Reporting ...2...2 Financial

Financial Reporting Reporting Overview...Overview...2...2 Navigating Reports in Workspace

Navigating Reports in Workspace ...4...4 Navigating Report

Navigating Reports in Financial Reporting Studios in Financial Reporting Studio ...10...10 Creating

Creating Reports...Reports...14...14 Creating Basic Report

Creating Basic Reportss ...14...14 Applying Advanced Member Selections

Applying Advanced Member Selections ...19...19 Formatting Cells

Formatting Cells and Gridsand Grids...20....20 Adding Objects to

Adding Objects to ReportsReports...24...24 Creating Report

Creating Report Objects...Objects...24...24 Creating

Creating ChartsCharts ...26...26 Adding

Adding Functions to Functions to Reports...Reports...30...30 Adding

Adding Text Text Functions...Functions...30....30 Adding Auto

Adding Auto CalculatiCalculations and ons and MathematicMathematical al FunctioFunctions...ns...32...32 Managing

Managing Reports...Reports...33...33 Creating

Creating Books...Books...33...33 Creating

Creating Batches...Batches...35...35 Managing Items

(2)

Introduction to Financial Reporting

Financial Reporting Overview

Financial Reporting Features Financial Reporting Features

With Financial reporting you can graphically design and present analytic data. With Financial reporting you can graphically design and present analytic data. You can design traditional financial report formats, such as cash management You can design traditional financial report formats, such as cash management report, profit and loss statements and balance statements. You can also design report, profit and loss statements and balance statements. You can also design non traditional formats for financial or analytic data that include text and objects. non traditional formats for financial or analytic data that include text and objects. Key features of Financial Reporting:

Key features of Financial Reporting:

•

• Flexible range of output optionsFlexible range of output options •

• Scalable, cross platform, server-based report generationScalable, cross platform, server-based report generation •

• Graphical report creation with access to multiple Hyperion dataGraphical report creation with access to multiple Hyperion data

Financial Reporting Features Financial Reporting Features

Batches and Batches and Books Books Asymmetric Asymmetric R Ree oorrtitinn PDF & HTML PDF & HTML R Ree oorrttss Guided Guided A Annalal sisiss Reusable Reusable Ob Ob ectectss Conditional Conditional Formattin Formattin Access Access Securit Securit Grids

Grids Charts Charts PrintingPrinting SchedulingScheduling

Report Designers and Viewers Report Designers and Viewers

(3)

Internal

Internal Document Document 33 Financial Reporting Architecture

Financial Reporting Architecture

FR is based on a three tiered architecture that contains the client, application and FR is based on a three tiered architecture that contains the client, application and database tiers.

database tiers.

Security Overview Security Overview

•

• Common user provisioning managed by Shared ServicesCommon user provisioning managed by Shared Services •

• Native and external authentication of usersNative and external authentication of users •

• Authorizations of actions that users can perform in FRAuthorizations of actions that users can perform in FR •

• Permission for report ObjectsPermission for report Objects

Financial Reporting Architecture Financial Reporting Architecture

FR

FR Studio Studio WorkspaceWorkspace Smart View forSmart View for Office Office Client Client Tier Tier Web Server Web Server Application Application tier

tier Financial ReportingFinancial Reporting Web application

Web application WorkspaceWorkspace_W_We_{eb a}_{b a} _lliic_ca_attiio_on_n

Financial Reporting Services Financial Reporting Services

Core Services Core Services Database Database tier tier Essbase

(4)

Navigating Reports in Workspace

Workspace Overview Workspace Overview

Workspace provides a single point of access to BI content and authoring tools: Workspace provides a single point of access to BI content and authoring tools: Financial Reporting:

Financial Reporting: For scheduled or on-demand, highly formatted, financialFor scheduled or on-demand, highly formatted, financial and operational reporting

and operational reporting Web Analysis:

Web Analysis: For interactive ad hoc analysis, presentations, and reporting ofFor interactive ad hoc analysis, presentations, and reporting of multidimensional data.

multidimensional data. Interactive Reporting:

Interactive Reporting: For ad hoc relational queries, self service reporting, andFor ad hoc relational queries, self service reporting, and dashboards for open database connectivity (ODBC) data sources

dashboards for open database connectivity (ODBC) data sources Production Reporting:

Production Reporting: For high volume, enterprise wide, production reporting.For high volume, enterprise wide, production reporting. Depending on assigned access one can use Workspace to perform these tasks Depending on assigned access one can use Workspace to perform these tasks for FR users

for FR users

•

• View and Print usersView and Print users •

• Create and Modify BooksCreate and Modify Books •

• Create and schedule batchesCreate and schedule batches •

• Set permissions for repository itemsSet permissions for repository items •

• Set preferencesSet preferences •

(5)

Internal

Internal Document Document 55 Launch Workspace:

Launch Workspace: Workspace is launched through a browser. The defaultWorkspace is launched through a browser. The default path for workspace is

path for workspace is

http://<Web Server>:<Port Number>/workspace/index.jsp http://<Web Server>:<Port Number>/workspace/index.jsp Enter

(6)

Workspace User Interface Workspace User Interface

Explorer Windows Explorer Windows

Once a user logs into workspace the top most folder Root is displayed on the Once a user logs into workspace the top most folder Root is displayed on the right side and folders inside root are displayed on the right side window.

right side and folders inside root are displayed on the right side window. Once the user selects any folder on the right side window the contents are Once the user selects any folder on the right side window the contents are displayed on the right side.

displayed on the right side.

Users will be able to see folders that they have access to. The rest are not Users will be able to see folders that they have access to. The rest are not displayed.

displayed.

Drill down to the folder which has the FR and double click the report. Drill down to the folder which has the FR and double click the report.

(7)

Internal

Internal Document Document 77 Financial Repot in Workspace

Financial Repot in Workspace

Menu

Menu Buttons Buttons StandardStandard

Bar Toolbar

View

View Document Document ContentContent Pane

(8)

File > Preferences File > Preferences

General: General:

Default Startup Options Default Startup Options Content: Content: Explore > Folder Explore > Folder Document > Document Document > Document Favorite Favorite

Application > Select Application Application > Select Application

(9)

Internal

Internal Document Document 99 Explore

Explore

Default Folder Default Folder

New Document Folder New Document Folder Default Permissions Default Permissions Financial Reporting Financial Reporting

Default Preview Mode: HTML, PDF Default Preview Mode: HTML, PDF

Export Office Applications: Office 2002 or Higher Export Office Applications: Office 2002 or Higher User Point of View: On/ Off

User Point of View: On/ Off

Location of POV: In View Pane/ Above Report Location of POV: In View Pane/ Above Report

Thousands Separator: Comma, Period, Underscore, Space. Thousands Separator: Comma, Period, Underscore, Space. Decimal Separator: Comma, Period, Underscore, Space Decimal Separator: Comma, Period, Underscore, Space Merge Equivalent Prompts

Merge Equivalent Prompts

Searching in Workspace: Tools > Search Searching in Workspace: Tools > Search

(10)

Navigating Reports in Financial Reporting Studio

Once you log into FR, Navigate to the folder where the saved report is and Once you log into FR, Navigate to the folder where the saved report is and double click to open it.

(11)

Internal

Internal Document Document 1111 Repository Objects

Repository Objects

•

• Grid:Grid: Report Object that contains data from external source.Report Object that contains data from external source. •

• Image:Image: Report Object that contains a graphic or an image file.Report Object that contains a graphic or an image file. •

• Report:Report: Layout that dynamically identifies the content and formatting.Layout that dynamically identifies the content and formatting. •

• Snapshot:Snapshot: Generated report that contains static data from a point in time.Generated report that contains static data from a point in time. •

• Text:Text: Report Object that contains text of functions.Report Object that contains text of functions. •

• Chart:Chart: Report Object that contains charts linked to data.Report Object that contains charts linked to data.

Report Components Report Components

(12)

Changing POV Changing POV

(13)

Internal

Internal Document Document 1313 Previewing and Printing Reports

Previewing and Printing Reports Print Preview

Print Preview

Web preview Web preview

(14)

Creating Reports

Creating Basic Reports

Select File > New > Report Select File > New > Report New Report

New Report

Creating Grids Creating Grids Select Insert > Grid Select Insert > Grid

(15)

Internal

Internal Document Document 1515 Setting up Dimension Layouts

Setting up Dimension Layouts

Drag Dimensions to Rows, Columns, and Pages Drag Dimensions to Rows, Columns, and Pages

(16)

Change Grid Layout:

Change Grid Layout: Right click the top left cell where the row headers andRight click the top left cell where the row headers and column headers meet and select Dimension Layout to get the Layout window. column headers meet and select Dimension Layout to get the Layout window. Select members:

Select members: Double click the Member names for member selection.Double click the Member names for member selection. SelectSelect and Move the members from left to right windows.

(17)

Internal

Internal Document Document 1717 Selecting Individual members

Selecting Individual members

Selecting Member Relationships Selecting Member Relationships

(18)

Previewing Selected Members Previewing Selected Members

Grid POV Grid POV

(19)

Internal

Internal Document Document 1919 Grid POV setup

Grid POV setup

Applying Advanced Member Selections

Selecting Children, Base, Parent, and Descendents for members Selecting Children, Base, Parent, and Descendents for members Creating User defined lists and selecting members using these lists. Creating User defined lists and selecting members using these lists.

(20)

Formatting Cells and Grids

Select the Grid and select Format > Cells Select the Grid and select Format > Cells Number

Number

Alignment Alignment

(21)

Internal

Internal Document Document 2121 Font

Font

Borders and Shading Borders and Shading

(22)

Replace Replace

Inherit Formatting Inherit Formatting

(23)

Internal

Internal Document Document 2323 Formatting Grids

Formatting Grids

Copying Cell Formatting Copying Cell Formatting Merging Cells

Merging Cells

Property Sheets are used to format Grids Property Sheets are used to format Grids Row Properties

Row Properties Column Properties Column Properties

Heading Row Properties Heading Row Properties Heading Column Properties Heading Column Properties Grid Properties

Grid Properties

Locked row and column headings Locked row and column headings Repeated heading suppression Repeated heading suppression Row and Column Sorting

Row and Column Sorting

Grid Positions and Grid Hiding Grid Positions and Grid Hiding

Data Suppression and conditional Suppression Data Suppression and conditional Suppression Format First and Last Rows

Format First and Last Rows

Suppressing Data: Basic Suppressing Data: Basic

Suppressing Data: Conditional Suppressing Data: Conditional Displaying Top Rows

Displaying Top Rows Conditional Formatting Conditional Formatting

Formatting First or Last Row Formatting First or Last Row

(24)

Adding Objects to Reports

Report Objects Overview Report Objects Overview

Report Objects include text boxes, images, row and column templates, grids, and Report Objects include text boxes, images, row and column templates, grids, and charts.

charts.

Creating Report Objects

Creating Text boxes Creating Text boxes Adding Images Adding Images Creating Grids Creating Grids Saving Objects Saving Objects

Inserting Saved Report Objects Inserting Saved Report Objects Linked Objects

Linked Objects

Insert > Saved Object Insert > Saved Object

(25)

Internal

Internal Document Document 2525 Designing Headers and Footers

Designing Headers and Footers

Designing Row and Column Templates Designing Row and Column Templates Inserting Row and Column Templates Inserting Row and Column Templates

(26)

Unlinking and Modifying Templates: Un Check the “Link to Source Object” and Unlinking and Modifying Templates: Un Check the “Link to Source Object” and edit the Object to suit the individual report.

edit the Object to suit the individual report.

Creating Charts

Charts Overview Charts Overview

You create chart Object in a report to graphically display data from a grid. You create chart Object in a report to graphically display data from a grid. Chart Types

Chart Types 1. Bar 1. Bar

(27)

Internal

Internal Document Document 2727 2. Line 2. Line 3. Pie 3. Pie 4. Combo 4. Combo

(28)

Designing Charts Designing Charts

You insert a chart in a report and use the Chart Properties sheet to design it. You You insert a chart in a report and use the Chart Properties sheet to design it. You mist specify the type of chart, the grid for the chart data, and the range of data. mist specify the type of chart, the grid for the chart data, and the range of data.

(29)

Internal

Internal Document Document 2929 Formatting Charts

Formatting Charts

Defining Appearance of Charts Defining Appearance of Charts Defining Chart Legends

Defining Chart Legends Defining Chart Axes Defining Chart Axes

Defining Chart Element Styles Defining Chart Element Styles Setting Bar Chart Options Setting Bar Chart Options Setting Line Chart Options Setting Line Chart Options Setting Pie Chart Options Setting Pie Chart Options Setting Combo Chart Options Setting Combo Chart Options

(30)

Adding Functions to Reports

Adding Text Functions

You can add text functions to a report to display information. For example shown You can add text functions to a report to display information. For example shown in the slide, you can add text functions to text boxes at the top of a report to

in the slide, you can add text functions to text boxes at the top of a report to display the POV, report description, and total gross margin

display the POV, report description, and total gross margin

Sample Cell Function Sample Cell Function

(31)

Internal

Internal Document Document 3131

•

• Data value retrieved from a cellData value retrieved from a cell •

• Member Names and Aliases from POVMember Names and Aliases from POV •

• Member names and Aliases from grid DimensionsMember names and Aliases from grid Dimensions •

• Property Value of a Dimension MemberProperty Value of a Dimension Member •

• Database name associated with a gridDatabase name associated with a grid •

• Grid Dimension namesGrid Dimension names •

• Page Numbers and total number of pagesPage Numbers and total number of pages •

• Current date and timeCurrent date and time

Inserting text function in text boxes Inserting text function in text boxes

Inserting text function in headings and text cells Inserting text function in headings and text cells Creating Dynamic values with the Current Key word Creating Dynamic values with the Current Key word Displaying Row and Column IDS

Displaying Row and Column IDS Common Cell text

Common Cell text functionsfunctions

• • CellTextCellText • • DataSourceDataSource • • DateDate • • GetCellGetCell • • ListOfCellDocumentsListOfCellDocuments • • MemberAliasMemberAlias • • MemberNameMemberName • • MemberPropertyMemberProperty • • PagePage • • PageCountPageCount Date Functions Date Functions

Common Date Formats Common Date Formats

Date

Date Format Format ResultResult <<>date(”d/M/yy”)>> 06/30/2008 <<>date(”d/M/yy”)>> 06/30/2008 <<>date(”d-MMM-yy”)>> 30-Jun-08 <<>date(”d-MMM-yy”)>> 30-Jun-08 <<>date(”EE

<<>date(”EEEE, EE, MMMM MMMM dd,yyyy”)>> dd,yyyy”)>> Monday, Monday, Jun Jun 30, 30, 20082008 <<>date(”h

<<>date(”h:mm :mm a”)>> a”)>> 4:30 4:30 PMPM <<>date(”h

<<>date(”h:mm :mm a a z”)>> z”)>> 4:30 4:30 PM PM CSTCST <<>date(”hh

<<>date(”hh ‘o ‘o clock’ clock’ a, a, zzzz”)>> zzzz”)>> 12 12 o’Clock o’Clock PM PM CentralCentral standard Time

(32)

Adding Auto Calculations

Adding Auto Calculations and Mathematical Functions

and Mathematical Functions

Auto Calculations Overview Auto Calculations Overview

You can setup auto calculations to calculate data rows and columns. For You can setup auto calculations to calculate data rows and columns. For

example you can calculate average or several products for different customers. example you can calculate average or several products for different customers.

•

• AverageAverage •

• Average AllAverage All •

• CountCount •

• Count AllCount All • • MaximumMaximum • • MinimumMinimum • • ProductProduct • • TotalTotal

Adding Auto Calculations Adding Auto Calculations Position Auto calculations Position Auto calculations Formatting Auto Calculations Formatting Auto Calculations Include Auto Calculation in Chart Include Auto Calculation in Chart

Defining Formula Rows, Columns and Cells Defining Formula Rows, Columns and Cells Calculating Formulas at Cell Level

Calculating Formulas at Cell Level Common Mathematical Functions Common Mathematical Functions

•

• Average and AverageAAverage and AverageA •

• Count and CountACount and CountA •

• EvalEval •

• IFThen “IfThen(Condition, TrueParamenter, Falseparameter)”IFThen “IfThen(Condition, TrueParamenter, Falseparameter)” • • PercentOfTotalPercentOfTotal • • RankRank • • RoundRound • • SumSum • • TruncateTruncate • • VarianceVariance • • VariancePercentVariancePercent

(33)

Internal

Internal Document Document 3333

Managing Reports

Creating Books

Books Overview Books Overview

Books contain reports and snapshot reports that you can view or print at the Books contain reports and snapshot reports that you can view or print at the same time. For example, you might create a book called quarterly report that you same time. For example, you might create a book called quarterly report that you run at the end of each quarter.

run at the end of each quarter.

In most cases you configure a book to generate several versions of a report for In most cases you configure a book to generate several versions of a report for different member selections.

different member selections.

Book: A collection of reports and Snapshot reports. When you run a book, the Book: A collection of reports and Snapshot reports. When you run a book, the report data is dynamically retrieved from the database connection, while the data report data is dynamically retrieved from the database connection, while the data within the snapshot reports remains static. After saving the book you can make within the snapshot reports remains static. After saving the book you can make changes to it, and you can preview and print the book.

changes to it, and you can preview and print the book.

Snapshot Book: A collection of reports an snapshot reports saved as snapshots. Snapshot Book: A collection of reports an snapshot reports saved as snapshots. All reports in a snapshot book are converted to snapshots containing static data All reports in a snapshot book are converted to snapshots containing static data as of a specific time. You cannot change the snapshot books, but you can

as of a specific time. You cannot change the snapshot books, but you can preview and print them.

preview and print them.

Previewing and Printing Books Previewing and Printing Books Changing Book POV

Changing Book POV Creating Books

(34)

Setting Member

(35)

Internal

Internal Document Document 3535 Collating the table of Contents by reports Collating the table of Contents by reports

Creating Batches

Working with Batches Working with Batches

Batches contain reports, snapshot reports, books and snapshot books that you Batches contain reports, snapshot reports, books and snapshot books that you process simultaneously. For example you might create a batch all weekly reports process simultaneously. For example you might create a batch all weekly reports and books. You can also email the exported output to the users. With batch

and books. You can also email the exported output to the users. With batch bursting options, you can run reports for multiple members in a dimension and bursting options, you can run reports for multiple members in a dimension and email the respective output to different users.

email the respective output to different users. Adding items to Batches:

Adding items to Batches: Selecting Prompt Members: Selecting Prompt Members: Scheduling batches

Scheduling batches

Setting the Start Time and Batch POV Setting the Start Time and Batch POV Setting Batch Output destinations Setting Batch Output destinations Emailing Scheduled batch Details Emailing Scheduled batch Details Scheduling Batch-Bursting Options Scheduling Batch-Bursting Options Setting Bursting Options

Setting Bursting Options

Selecting Bursted Output Labels Selecting Bursted Output Labels Emailing PDF Attachments

Emailing PDF Attachments Preview Bursting Lists Preview Bursting Lists

Emailing Bursting Destination Files Emailing Bursting Destination Files Importing Bursting Destination Files Importing Bursting Destination Files Applying Bursting Destination Files Applying Bursting Destination Files Copying Members of Bursting Copying Members of Bursting Monitoring Batch Schedules Monitoring Batch Schedules

Managing Items in Repository

Creating Email Links Creating Email Links

Managing Email recipients Managing Email recipients Exporting repository items Exporting repository items Importing Repository items Importing Repository items

Setting Permissions of repository Items Setting Permissions of repository Items