Help Desk

Submit a ticket My Tickets
Welcome
Login

Oracle Hyperion Financial Management Config Text Samples


Premium BizApp

The OneCloud Oracle Hyperion Financial management (HFM) BizApp will require Config Text at times to perform pointed actions.  The examples below will help demonstrate the commands that will require Config Text and the fields they will require.

A Quick Note

You must call out Custom Dimensions by name. The examples below are based upon the Oracle Comma application: Custom1 is Product, Custom2 is Customers, Custom3 is Channel and Custom4 is UnitsFlows.

Clear Slice

The Clear Slice command only requires an HFM POV consisting of: Scenario, Year, Period, Entity and Account

[DATA_SUBSET],SCENARIO,"Actual",[MEMBER]
[DATA_SUBSET],YEAR,"2005",[MEMBER] 
[DATA_SUBSET],PERIOD,January,[MEMBER]
[DATA_SUBSET],ENTITY,"ItalySales",[MEMBER]
[DATA_SUBSET],ACCOUNT,"TotalRevenues",[BASE]

Copy Data

The Copy Data command only requires an HFM POV consisting of:  Scenario, Year, Period, Entity and Account

It also requires a [SOURCE] POV, as well as a [TARGET] POV to be specified.

[SOURCE],SCENARIO,"Actual",[MEMBER]
[SOURCE],YEAR,"2005",[MEMBER] 
[SOURCE],PERIOD,January,[MEMBER]
[TARGET],SCENARIO,"Actual",[MEMBER]
[TARGET],YEAR,"1999",[MEMBER] 
[TARGET],PERIOD,January,[MEMBER]
[DATA_SUBSET],ENTITY,"ItalySales",[MEMBER]
[DATA_SUBSET],ACCOUNT,"TotalRevenues",[BASE]

Extract Data to Database

The Extract Data to Database requires a full HFM POV, consisting of all dimensional elements.

[DATA_SUBSET],SCENARIO,"Actual",[MEMBER]
[DATA_SUBSET],YEAR,"2005",[MEMBER] 
[DATA_SUBSET],PERIOD,January,[MEMBER]
[DATA_SUBSET],VIEW,Periodic,[MEMBER]
[DATA_SUBSET],ENTITY,"ItalySales",[MEMBER]
[DATA_SUBSET],ACCOUNT,"TotalRevenues",[BASE]
[DATA_SUBSET],ACCOUNT,"TotalAssets",[BASE]
[DATA_SUBSET],VALUE,"",[MEMBER]
[DATA_SUBSET],ICP,"[ICP None]",[MEMBER]
[DATA_SUBSET],Product,"TotalProducts",[BASE]
[DATA_SUBSET],Customers,"TotalCustomers",[BASE]
[DATA_SUBSET],Channel,"TotalC3",[BASE]
[DATA_SUBSET],UnitsFlows,"ClosingBalance",[BASE]

Extract Data to File

The Extract Data to Database requires a full HFM POV, consisting of all dimensional elements.

[DATA_SUBSET],SCENARIO,"Actual",[MEMBER]
[DATA_SUBSET],YEAR,"2005",[MEMBER] 
[DATA_SUBSET],PERIOD,January,[MEMBER]
[DATA_SUBSET],VIEW,Periodic,[MEMBER]
[DATA_SUBSET],ENTITY,"ItalySales",[MEMBER]
[DATA_SUBSET],ACCOUNT,"TotalRevenues",[BASE]
[DATA_SUBSET],ACCOUNT,"TotalAssets",[BASE]
[DATA_SUBSET],VALUE,"",[MEMBER]
[DATA_SUBSET],ICP,"[ICP None]",[MEMBER]
[DATA_SUBSET],Product,"TotalProducts",[BASE]
[DATA_SUBSET],Customers,"TotalCustomers",[BASE]
[DATA_SUBSET],Channel,"TotalC3",[BASE]
[DATA_SUBSET],UnitsFlows,"ClosingBalance",[BASE]

Available Command References

The following extract commands are available for use by OneCloud.  Please note, not every command is available on every dimension or available via every command.  It is limited mostly by HFM implementation and command availability.

  • [Hierarchy]
  • [Ancestors]
  • [iAncestors]
  • [Base]
  • [Children]
  • [iChildren]
  • [Descendants]
  • [iDescendants]
  • [Parents] 
  • [iParents]
  • [Member]
  • [Memberlist]
  • [AllMembers]

What's Next?

For documentation on all available commands, see the Oracle Hyperion Financial Management Command Reference.

W
Wayne is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.