Financials Report Writer > Hands-On Exercise
  PPT
Hands-On Exercise
Exercise 3: Creating a Report Cube
1 Create a new report cube using Report Cube Definition (25.16.2).
 
Field
Value
Cube Code
NAmerica Cube
Cube Description
North American Report Cube
Cube Status
INITIAL (read-only)
Report Chart
NAmerica
a In the next frame, include the following values only:
 
Field
Value
Include Sub Account Dimension
Yes (Selected)
Include Cost Center Dimension
Yes (Selected)
Include Project Dimension
Yes (Selected)
b In the next frame, select the Primary layer only. Deselect all other layers.
c In the next frame, specify the currency and exchange details:
 
Field
Value
Presentation Currency
USD
Source
BC
Exchange Rate Shared Set
QMS-ExRate-US
Translation Method
2
d In the next frame, specify a reporting period from Jan 2012 through to December 2013 with a period type of Monthly.
e Accept the defaults when defining start and end dates for reporting periods. You must click Next to display each report period.
f In the Entity Selection frame, for all three entities included in the cube, specify BC as the source of their GL balances. You must click Next to display each entity.
g In the Report Periods mapping with GL Periods frame, accept all defaults when defining the report period to GL period mappings. You must click Next to display each mapping.
2 Generate your new cube using Report Cube Generate (25.16.3). You may need to stop and start the Cube daemon first.
a Specify cube code NAmerica Cube.
b Accept all defaults.
3 Create a second report cube using Report Cube Definition (25.16.2). Use the report chart Europe you created in the previous exercise.
a Accept the default dimensions.
b Select the Primary and Management layers.
c Specify the presentation currency as EUR and use the same exchange rate shared set as used in 22UK.
d Set the translation method to be defined in the cube rather than accepting settings in GL accounts.
e Set up the report to run for 2012 and 2013.