Downloading and Creating FRS Report

Role Required:  Financial Analyst

Process:

·       Downloading FRS Studio

·       Log in to FRS Studio

·       Creating Grid and setting up POV(Point of View) Values

·       Formatting the Report output

 

Downloading FRS Studio:

 Navigate to the below path as shown in the screenshot

 Welcome spring board à Navigator Menu à Financial Reporting Center

Allow popup to open FRS Window

Navigate as shown in the below screenshot to Install Studio 

Once the Studio is downloaded, Navigate to the installed location and run as administrator.

 

 Login to FRS Studio:

Open the App and Run as administrator 

 

 

Enter Credentials as below

User Name & Password: User Login Credentials

Server URL: Oracle Instance URL till .com

 

 

Example :

Let us try to build the Report shown in the below screenshot. 

 

 

Creating Grid and setting up POV Values:

From the FRS Studio, follow the Navigation shown in the below screenshot to Create new Report

Create Grid by Dragging and select the Database connection

Now to get the Report in the desired Format, we need to Drag Account to the Rows and Period to the Column as shown and click OK

Once you click on OK , you will see the selected Dimensions in the Grid.

 

To select the desired accounts, double click on the Account Dimension. Member selection screen will appear as shown

First we need to remove the Account present on the Right side by moving to left as shown

Now, expand the account hierarchy and move the desired accounts from left to the right as shown.

Once we select the desired Accounts and move, enable Place selections into separate rows checkbox to see accounts in separate lines.

And click OK.

Now select the Desired Periods by double clicking Accounting Period Dimension in the same way as we selected Accounts.

Now, the grid will look like this

If you run Report at this Stage, you will not see any Data. To get the Data we need to set the POV Members as shown

Double click on any POV Member to set the Value as shown below and click OK

Follow the same for Remaining Point of Views and select Values.

 

Now save the Report in desired Location

 

Now run the Report to see the Values

Output

Formatting Report:

To rename the Accounts to match with the sample 

 Select the account and give the custom heading from Row properties as shown 

Follow for the Remaining rows and columns as required.

Now, we will add the formula row to show the check value as shown

 Give custom heading similar to Accounts

 Enter formula and click on Right mark as shown

 

Now save the Report and Run to view the latest output

Adding borders to the formula row

Right Align Columns and displaying $ symbol

Making column Headings Bold

Now save the Report and Run to view latest output

Adding Report Name in the Header

Now drag the Text Box and add heading and format as shown

 

Position the Header to Display in the Middle as shown

Now save the Report and view the final Output