Reporting

These videos were recorded using US terminology, but the concepts still apply. Refer to Terminology across locales to see related terms for your location.

Financial reports

88:22

Webinar: Going beyond financial statements with Financial Report Writer

In this customer meetup recording, an expert demonstrates how to create financial reports using dimension groups and structures.

4:01

Create a financial report

Shows how to create a new financial report.

3:01

Create a dimension-based financial report

Shows how to create a dimension-based financial report.

3:28

Run a financial report

Shows how to run a financial report.

5:51

Use dates and filters in financial reports

Understand how column dates and As of dates work in financial reports.

4:38

Filter a financial report

Shows how to filter a financial report.

5:48

Create and filter account groups

Explains how to create and filter account groups.

3:07

Manage and organize account groups

Learn how to use fields that define the Account Group Purpose and Account Group Manager.

3:17

Expand columns by dimensions

Shows you how to expand columns by dimensions in a financial report.

7:06

Expand columns by dimension structures

Shows you how to expand columns with dimensions by modifying an existing report's columns using dimension structures.

2:57

Expand rows by dimensions

Shows you how to expand rows by dimensions in a financial report.

2:14

Find and organize reports

See search in action, plus learn how to organize reports by type and audience for flexible filtering.

4:28

Add a row calculation

Shows how to create a report that uses statistical and computation account groups to show calculations in a row on a financial report.

5:42

Add a column computation

Shows how to add a column computation to a financial report.

3:01

Add a computation account group

Shows how to add a computation acount group.

2:25

Add a percentage of amount column

Shows how to add a percentage of amount column.

2:39

Add a statistical account group

Shows how to add a statistical account group.

3:16

Add a summary column

Shows how to add a summary column to a financial report.

2:36

Compare columns by time periods

Shows how to compare data in columns across time periods.

9:10

Create groups of account groups

Shows how to create groups of account groups.

6:44

Filter columns by dimension structures

Shows how to filter columns by dimension structures.

3:32

Modify the Account name and Actual columns

Shows how to modify the settings for the Account name and Actual columns in a financial report.

3:39

Purchasing commitments financial report

Shows how to include a user-defined book in a financial report. The example includes committed purchase orders in a report.

1:23

Use books in financial reports

Shows how to include a user-defined book in a financial report. The example includes the RealEstate book in a report.

Interactive Custom Report Writer (ICRW)

2:40

Introduction to Interactive Custom Report Writer

An overview of this powerful custom reporting tool that allows you to build reports to meet your company's specific needs and work on real-time data.

88:41

Customer meetup Webinar: ICRW

Experts discuss how Interactive Custom Report Writer and other modules help improve your efficiency and productivity.

1:55

Create a new report from the report library

See how to browse the library for pre-created reports that you can use as-is or adapt for your needs.

2:39

Create a new interactive custom report

Shows how to create a new ICRW report.

2:12

Add a calculation column

Shows how to add a calculation column to an ICRW report.

2:44

Add a custom calculated item

Shows how to add a custom calculated item to an ICRW report.

1:38

Add a report to a dashboard

Shows how to add an ICRW report to a dashboard.

2:21

Add filters

Shows how to add basic filters to an ICRW report.

2:42

Use a filter in a calculation column

Shows how to use a filter within a calculation column in an ICRW report.

2:57

Use the Keep Only selection step

Shows how to use the Keep Only selection step to filter data in an ICRW report.

7:06

Add a local date and timestamp to a report

Shows how to create a calculated column to add a local date and timestamp to an ICRW report.

8:35

Time series functions

Demonstrates new time series functions in ICRW and IVE.

3:25

Use conditional formats

Shows how to use conditional formats in ICRW.

2:33

Sort and add totals

Shows how to sort data and add totals in an ICRW.

2:17

Set permissions and add reports to the menu

Shows how to control access to an ICRW report, including making a report available on the menu.

3:22

Assign Interactive Custom Report Writer Designer permission to a role

Learn about the different types of permissions available in ICRW and how to grant designer access.

3:30

Format column data

Shows some of the format options for columns in ICRW.

3:03

Format alternate rows and subtotals

Shows some options to format rows in ICRW. The example shows how to format alternate rows and subtotals.