what would happen if i did...in hfm (part 2)
Post on 13-Sep-2014
1.222 views
DESCRIPTION
TRANSCRIPT
![Page 1: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/1.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater RanzalCopyright ©2013 by Chris Barbieri, Edgewater Ranzal
What Would Happen If I Did…In Hyperion Financial Management?
Part 2
Chris Barbieri
![Page 2: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/2.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Ever Wonder What Would Happen?
� Delete the first few years of data in an application?� Make a base entity into a parent?� A metadata load / deploy while someone else is
consolidating?� Add a new custom dimension in 11.1.2.2?
![Page 3: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/3.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� No built-in functionality to archive� Can not remove years
● …Can add later years
� Considerations● Roll-forwards
● Retained earnings● Cash flow
● Ratios that span years● Reports
Delete the first few years of data in an application?
![Page 4: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/4.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Retained Earnings Before
![Page 5: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/5.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Database Management� Other Methods?
Clear Data
![Page 6: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/6.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Yes you can!
Clear Parent Entities?
![Page 7: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/7.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Does not return to “NoData”● …Stays at “OK”
Calc Status
![Page 8: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/8.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Add a year condition to the rules
� Now consolidate again● Retained Earnings is gone● Cell IsCalculated
Back to the Roll Forward
![Page 9: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/9.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Account is calculated� Remove the flag before reconsolidating?
● On the Account● … and the Custom4 member● Re-load 2005 and reconsolidate 2005 and 2006 again
● Possibly load Opening Balance in 2006, now that it’s not IsCalculated● Still have to manage when to clear and when NoInput
� Re-load January 2006 base data with Replace mode?● Forces HFM to “see” it as Input rather than Calculated
� This gets more complicated the more you think it through
Avoid Lost Data
![Page 10: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/10.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Data can only be entered into base entities� <Entity Currency> in a parent is the sum of
[Contribution Total] of it’s children� Add children to EastSales
Make a base entity into a parent?
![Page 11: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/11.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Load new metadata
Make EastSales a Parent
� Data in parent entity is not from its children
![Page 12: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/12.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Data in <Parent Currency> and above are cleared during consolidation process● … and re-populated from base
Consolidate All With Data
● -1,300 is from rules, not data
![Page 13: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/13.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Can we see this?● Task Audit…● Running Tasks
A metadata load / deploy while someone else is consolidating?
When you load metadata files, the system waits
for other tasks such as consolidation, data entry
or other load processes to finish before proceeding
to load the files.
HFM Administrator Guide, p. 117
![Page 14: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/14.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Load data● Replace mode● 49 seconds
� Consolidate● Multi-year grid: Consolidate All With Data
● Actual 2005 Jan-Dec● Actual 2006 Jan-Dec● Actual 2007 Jan-Mar
● 72 seconds
� Load Metadata● 13 seconds
Task Audit for Baseline Times
![Page 15: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/15.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Executed last of three activities● Load Data: 65 seconds (vs. 49)● Consolidation: 153 seconds (vs. 72) ● Load Metadata: 115 seconds (vs. 13)
� Shortest activity
Metadata Should Complete First
![Page 16: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/16.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Requires Release 11.1.2.2.303 Patch Set Update
(PSU): 11.1.2.2.303
� Application profile determines dimensions
Add a new custom dimension in 11.1.2.2?
� Metadata file allows you to edit them
![Page 17: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/17.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Add One new dimension to existing profile● Custom5 = “Species”● Save As...
Edit the Profile
![Page 18: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/18.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Edit Customs > Import
Import this into the metadata file
� “Species” is available for editing� Update Account attributes
� Save updated metadata
![Page 19: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/19.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� ConsolidationAdministration● Administration >
Applications● Right-click and
Modify
� Scary message!
Update the Application
![Page 20: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/20.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Load the New Profile
� Select 5-dimension profile� Modify >
● Review Changes● Note “Species” dimension● Clear Data Audit Table
![Page 21: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/21.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� If you have this enabled● Use the Audit Extract Utility● Or App > Consolidation >
Maintenance > Data Audit● XX = “Delete All”
Clear Data Audit Table
![Page 22: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/22.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Return to previous Modify steps
Return to Modify
![Page 23: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/23.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Before
Simple Grid Showing 4 Dimension POV
� After
![Page 24: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/24.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� AppName_Custom_Item table
Database
![Page 25: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/25.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Before: Two LCustomX fields
Data Table
� After: Three LCustomX fields
![Page 26: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/26.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� All data moved to Species “[None]”� Web metadata load options
Load Application Elements
![Page 27: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/27.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Data still resides in Species [None]� Other members now available� Update Account Custom
Updated Species Dimension
![Page 28: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/28.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� HFM handled existing data and journals� Data integration tool and process needs to be
updated for new dimension
Woops! What About New Data?
![Page 29: What would happen if i did...in hfm (part 2)](https://reader036.vdocuments.us/reader036/viewer/2022081801/54151b848d7f72466c8b480d/html5/thumbnails/29.jpg)
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Chris [email protected]
Needham, MAUSA
+1.617.480.6173www.ranzal.com