cancel
Showing results for 
Search instead for 
Did you mean: 
OSAdmin
Community Manager
Community Manager
 

Answer

Answer: Configuration touchpoints:
Entity
Time Profiles
Scenarios
FX Rates
Cubes
Data Integration – moving data between cubes

 

Case Study A

  • Two completely separate organizations:
  • Retail/Commercial organization – “Business”
  • FEBRUARY year-end
  • Charitable Foundation – “Charity”
  • DECEMBER year-end
  • No crossing of entities – entities are one or the other only
  • Entities GL systems set up based on their respective year-ends
OSAdmin_0-1629140136897.png

 

Scenario Configuration

Due to FX Rate tables being stored by cube, you’ll need separate scenario dimensions for each respective entity dimension.

 

OSAdmin_1-1629140185205.png

 

OSAdmin_2-1629140220207.png

 

OSAdmin_3-1629140232656.png

 

OSAdmin_4-1629140245572.png

 

Time Profiles

OSAdmin_5-1629140274771.png

Cubes

OSAdmin_6-1629140286347.png

 

OSAdmin_7-1629140313466.png

 

Case Study B

  • Group SEC & Managerial reported based on Corporate October year-end
  • Local/Legal Statutory & Tax reporting based on following requirements:
  • March Year-End – required for India entities
  • December Year-End – required for Mexico, Brazil, Israel, China, Romania
  • Other countries use corporate fiscal year as local/legal calendar
  • All entities data imported via connector to Corporate wide Oracle GL based on October calendar
  • GL Data coded by “ledger codes” to indicate what is US GAAP, Local/Legal, or both (captured in UD1)
  • Some countries need country specific COA hierarchies
  • Local/Legal reporting only needs to be in local currency

Entity Configuration

Create separate entity dimensions for each local reporting year-end.  

OSAdmin_8-1629140422800.pngOSAdmin_9-1629140437293.png

 

Scenario Configuration

Duplicate scenarios to accommodate FX rates by currency and fiscal year.

OSAdmin_10-1629140511843.png

 

Time Profiles

OSAdmin_11-1629140558780.png

 

Accounts

Summary Accts – level used for planning

Detail Accounts – level used for group financial reporting

LL (Local/Legal) Accounts – additional detail and alternate hierarchies for country specific COA

OSAdmin_12-1629140598014.png

 

UD1

OSAdmin_13-1629140617969.png

Cubes

OSAdmin_14-1629140637419.png

 

Sample app available as attachment

 

Source: Office Hours 2020-02-13 Partner Enablement

Version history
Last update:
‎02-07-2022 11:22 AM
Updated by: