Certain Oracle Hyperion Financial management (HFM) commands require config text to perform actions. The examples below demonstrate which commands require config text and the required fields.
Note: 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 the connector. Not every command is available on every dimension or available via every command. Limitations exist due to HFM implementation(s) and command availability.
-
[Ancestors]
-
[iAncestors]
-
[Base]
-
[Children]
-
[iChildren]
-
[Descendants]
-
[iDescendants]
-
[Parents]
-
[iParents]
-
[Member]
-
[Memberlist]
-
[AllMembers] -- Performs an extract at the top node [Hierarchy]
Extracting Data from System Accounts
To extract data from a specific system account, please use the following syntax of:
Example:
[DATA_SUBSET],ACCOUNT,<MemberName>|[SYSTEM],[MEMBER]
Sample:
[DATA_SUBSET],ACCOUNT,[SharesOutstanding]|[SYSTEM],[MEMBER]
To extract data from all system accounts, please use the following syntax of:
Example:
[DATA_SUBSET],ACCOUNT,<MemberListName>,[MEMBERLIST]
Sample:
[DATA_SUBSET],ACCOUNT,[SYSTEM],[MEMBERLIST]