QAD 2016 Enterprise Edition Training Guides > Financials-Advanced > Financials Report Writer > Hands-On Exercise
  PPT
Hands-On Exercise
Exercise 2: Creating a Report Cube
1 Create a new report cube using Report Cube Create (25.16.13.1).
 
Field
Value
Cube Code
NAmerica Cube
Description
North American Report Cube
Status
INITIAL (read-only)
Chart
NAmerica
a In the Currency tab, specify the currency and exchange details:
 
Field
Value
Presentation Currency
USD
Exchange Rate Shared Set
QMS-ExRate-US
Translation Method
GL Consolidation Method
BS Exchange Rate Type
Accounting
BS Translation Method
Blank
IS Exchange Rate Type
Accounting
IS Translation Method
Blank
b In the Layers tab, select the Primary layer only. Deselect all other layers.
c In the Dimensions tab, include the following values only:
 
Field
Value
Include Sub Account Dimension
Yes (Selected)
Include Cost Center Dimension
Yes (Selected)
d In the Report Calendar tab, specify a reporting period from Jan 2014 through to December 2014 with a period type of Months. Click Generate Calendar.
e In the Entities tab, the three entities included in the report chart are selected. For the entities, specify BC as the source of their GL balances.
f In the Periods Mapping tab, click Generate Mapping and accept all defaults.
g Save the cube.
2 Stop the Cube daemon using Cube Daemon Stop (36.14.16.18.5).
3 Generate your new cube using Report Cube Generate (25.16.3).
a Specify cube code NAmerica Cube.
b Accept all defaults.
4 Restart the Cube daemon using Cube Daemon Start (36.14.16.18.4).