The Manage User POV utility is a command line utility where the administrator creates, views, updates, or deletes the Financial Reporting POV for one or more users. The utility is installed with Reporting Studio to the EPM_ORACLE_HOME\Products\financialreporting\bin directory as ManageUserPov.cmd and comes with a sample configuration file called ManageUserPOV.properties.
To run the utility, open a command prompt in the EPM_ORACLE_HOME\Products\financialreporting\bin directory and run the ManageUserPov.cmd:
ManageUserPOV <Mode> <ConfigFileName>
where Mode = Import, Export, or Delete (case insensitive)
where ConfigFileName = the name of the configuration file (the default name is ManageUserPov.properties located in the EPM_ORACLE_HOME\Products\financialreporting\bin directory).
Example: ManageUserPOV Export ManageUserPov.properties
Two files must be predefined before executing the POV utility; the configuration file, such as ManageUserPov.properties, and, when importing, an import file such as ManageUserPovImport.xml. Sample files are provided in the <financialreporting>\bin directory:
ManageUserPov.properties file. Use this file to define the report server, assign administrator and data source credentials, specify the import and export file names, and set the various options such as user and data source filters and whether or not to perform a dry run, or confirm deletion of User POVs. See the sample ManageUserPov.properties file for details.
The ManageUserPovImport.xml file. An ImportFileName, such as ManageUserPovImport.xml. The XML file created during an export can also be edited and used for importing.
Database connections which do not yet exist in the repository are created if the TYPE, SERVER, APPNAME, and DBNAME attributes are provided. Valid data source TYPEs are: Essbase, Financial Management, Planning, SAPBW, MSOLAP.
All dimensions and members are validated against the data source to ensure that only valid User POVs are created or updated.
Individual user access to a member is not validated; administrators should assign User POVs to only those users with access rights to view them.
User POVs are only created for provisioned users.
Partial User POVs are valid; only dimensions specified in the import file are updated.