Table Of ContentI
I
L-'
Oracle Hyperion
FDMEE Design
Thinking
in
FDMEE Projects
Leo Reny
Yamin Ren
HYPech.com
t
India • Japan • Korea ■ Singapore ■ United Kingdom ■ United Slates
Oracle Hyperion Series
ALL RIGHTS RESERVED.
fdmee Design:
No part of this work covered by the copyright herein may be
Leo Reny
reproduced, transmitted, stored, or used in any form or by
any means graphic, electronic, or mechanical, including but
General Manager:
not limited to photocopying, recording, scanning, digitizing,
taping, web distribution, information networks, or informa
Mel Pearce
tion storage and retrieval systems, except as permitted un
der Section 107 or 108 of the 1976 United States Copyright
Associate Director:
Act, without the prior written permission of the publisher.
Kris Burns
Throughout this book, we refer to products and designs
which are not our property. These references are meant
Manager of Editorial Ser only to be informational. We do not represent the compa
vices: nies mentioned and were not paid promotional fees. How
ever, if these companies would like to send us evaluation
Hayden Simpson copies of future products, we would be thrilled. References
to products are not endorsements, but reflect our opinions
Marketing Manager: in some cases.
Lilyana Cardenas Computer software products mentioned are the property
of their respective publishers. Instead of attempting to list
Acquisitions Editor; every software publishers and brand, or including trade
mark symbols throughout this book, we assume that We
Alexandra Lewis know these product and brand names are protected under
U.S. and international laws. Fonts and designs are the intel
Project and Copy Editor: lectual property of the design artists. Although U.S. copy
right laws do not protect font designs, we consider them the
Isabella Fletcher property of the designers and licensing agencies.
For product information and assistance, contact us at
Technical Reviewer:
Hypech Publisher Customer Support, 1-872-222-8067
Sergio Crawford
For permission to use material from this text or product,
submit all requests to: [email protected]
Interior Layout Tech:
Oracle and Hyperion are registered trademarks of Oracle
ReApex Limited Corp. Access, Excel, Microsoft, SQL Server, and Windows are
registered trademarks of Microsoft Corporation. DB2 and
Cover Designer: IBM are registered trademarks of IBM Corporation. MySQL
is a registered trademark of MySQL AB. Mac OS is a regis
Luke Fletcher tered trademark of Apple Inc. All other trademarks are the
property of their respective owners.
Indexer:
Images designed by Freepik, and used here with thanks.
Harley Kramer
ISBN-13: 978-1 -7774122-0-3 (e-Book)
Proofreader: ISBN-13: 978-1-7774122-2-7 (Book)
ISBN-13: 979-8-5545172-9-7 (KDP)
Blair Salas
HYPech.com is a leading provider of customized learning so-
lutions to IT technology. Hypech.com learning products are
represented in Canada by ReApex Corp.
Printed in the US Visit our corporate website at http://HYPech.com.
1 234567 12 11 10
ACKNOWLEDGMENTS
I would like to acknowledge the help received from
those who assisted, either directly or indirectly, with
the words found between these covers.
First, I would like to thank the many editors and work
ers at Hypech Publisher who skillfully enhanced and
improved many aspects of this book as it was brought
to fruition. Without Alexandra Lewis, my acquisitions
editor, this book literally would not exist. Sergio Craw
ford, my technical editor, did an outstanding job in
his review. I thank him for the numerous suggestions
and corrections that he provided. Finally, Mel Pearce,
my project editor was superb in pulling it all together,
while adding a professional touch and coherency to
the entire project.
I would also like to thank a former colleague, Kelly
Ding, who contributed to my understanding of Ac
counting, Finance, and Hyperion. Without her encour
agement and support, I might not start this Hyperion
book project.
Finally, and most especially, I would like to thank ev
eryone in my immediate family for their encourage
ment and support as I’ve dedicated myself to this proj
ect.
THE AUTHOR
czz
Leo Reny has been involved with Enterprise
Management System and Business Intelligence
(BI) development, cloud calculation, and Al for
20+ years. He has developed multiple MIS for
factories and companies before jumping into Or
acle’s fields. His main area of expertise is with fi
nancial system, data warehouse systems, business
intelligence, and reporting tools. He has served
as a consultant for Canada Federal Government,
Glencore, and many other industry leaders. He
has worked with Accenture and HWG. He holds
an MBA from the University of California, Los
Angeles, with a specialization in Management
Information System.
For more information on his current activities
or to contact the author, please visit http://www.
hypech.com or http://www.amazon.com/author/
leoreny.
CONTENTS
INTRODUCTION XI
FDMEE Design xii
On-line Support and Forum xiii
Business Story xiv
Prerequisites xvii
Contents at a Glance xviii
How to Use This Book? xix
PART 1. CASE STUDY 1
CONTENTS AT A GLANCE 2
CHAPTER 1.1 FDMEE FROM HEM TO PBCS 3
1. PBCS Design 4
2. Business Context 9
3. FDMEE Design 11
4. Register Target Application 12
Link Source to Target (Import Format) 15
5. Store Transferring Data (Data Load Rule) 17
5.1 Location 18
5.2 Category 19
5.3 Period 20
5.4 Create Data Load Rule 20
5.5 Create Data Load Mapping 25
6. FDMEE Automation - Batch 31
Step 1: Define a Batch 31
Step 2: Create Batch File 32
Step 3: Execute the batch 34
Batch Design 35
7. Process 36
7.1 BATCH HFM To PBCS 37
7.2 DLR BATCH HFM To PBCS 39
7.3 DLR SNCL To PBCS 2 40
7.4 DLR Conso SNCL 2 43
7.5 Summary 44
8. Script 45
8.1 Beflmport 46
8.2 afterValidate 51
8.3 BefExportToDat 52
8.4 AftExportToDat 59
CHAPTER 1.2 MIGRATING FDMEE 61
LCM and Shared Services 62
Step 1: Export FDMEE Through LCM 64
Step 2: Import FDMEE Through LCM 68
Step 3: Check Artifact List 70
Step 4: Import FDMEE 71
PART 2 CONTENTS AT A GLANCE 74
PART 2. REAL PROJECT: HFM INTEGRATION 75
Business Story 76
CHAPTER 2.1 ANALYSIS 77
1. Background 78
3. Check XM’s Original Import Format 85
4. Understand Import Script 88
5. HFM Dimension 89
CHAPTER 2.2 REVERSE ENGINEERING EBS MAPPING 91
1. Source Data Analysis 92
2. Account Mapping 93
3. Entity Mapping 99
4. Movement Mapping 104
5. ICP Mapping 105
6. Qualifier Mapping 110
7. Project Mapping 113
8. Region Mapping 116
CHAPTER 2.3 REVERSE ENGINEERING JOE 121
1. XM’s FDMEE Data Mapping 122
1.1 Account Mapping 123
1.2 Entity Mapping 125
1.3 XM’s Movement Mapping 128
1.4 XM’s ICP Mapping 128
2. Final Data Mapping 129
kit
i
2.1 HWG Account Mapping 129
2.2 HWG Entity Mapping 130
2.3 ICP Mapping 131
2.4 Qualifier Mapping 135
2.5 HWG Project Mapping 139
i
2.6 HWG Region Mapping 140
3. JDE GAP Analysis Deliverable 143
CHAPTER 2.4 REVERSE ENGINEERING MAC 149
1. Source File 150
2. GAP Analysis 151
3. Final Data Mapping 157
3.1 HWG Account Mapping 157
3.2 HWG Entity Mapping 158
3.3 ICP Mapping 159
3.4 DataType Mapping 160
3.5 Region 161
3.6 Project 162
i
163
CHAPTER 2.5 INTEGRATION ■ DEVELOPING
1. Check Environment 164
2. Maconomy (Deltek) FDMEE 168
2.1 Create Import Format 169
2.2 Create Location 171
2.3 Data Load Mapping 172
2.4 Create Data Load Rule 182
2.5 Work at Data Load Workbench 185
3. EBS FDMEE 187
