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 required fields.

📓 Users 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. Not every Command is available on every dimension or available via every Command. Limitations exist due to HFM implementation and Command availability.

  • [Ancestors]

  • [iAncestors]

  • [Base]

  • [Children]

  • [iChildren]

  • [Descendants]

  • [iDescendants]

  • [Parents]

  • [iParents]

  • [Member]

  • [Memberlist]

  • [AllMembers]
    -- Performs an extract at the top node [Hierarchy]

  • <MemberName>|[SYSTEM]
    -- Performs an extract of System members

Did this answer your question?