what would happen if i did...in hfm (part 2)
Post on 13-Sep-2014
1.222 Views
Preview:
DESCRIPTION
TRANSCRIPT
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
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?
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?
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Retained Earnings Before
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Database Management� Other Methods?
Clear Data
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Yes you can!
Clear Parent Entities?
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Does not return to “NoData”● …Stays at “OK”
Calc Status
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
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
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?
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Load new metadata
Make EastSales a Parent
� Data in parent entity is not from its children
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
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
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
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
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
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Add One new dimension to existing profile● Custom5 = “Species”● Save As...
Edit the Profile
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
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� ConsolidationAdministration● Administration >
Applications● Right-click and
Modify
� Scary message!
Update the Application
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
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
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Return to previous Modify steps
Return to Modify
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Before
Simple Grid Showing 4 Dimension POV
� After
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� AppName_Custom_Item table
Database
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Before: Two LCustomX fields
Data Table
� After: Three LCustomX fields
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� All data moved to Species “[None]”� Web metadata load options
Load Application Elements
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
� Data still resides in Species [None]� Other members now available� Update Account Custom
Updated Species Dimension
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?
Copyright ©2013 by Chris Barbieri, Edgewater Ranzal
Chris Barbiericbarbieri@ranzal.com
Needham, MAUSA
+1.617.480.6173www.ranzal.com
top related