Using the User POV Utility

  To export all existing User POVs:

1. Edit the ManageUserPov.properties file and specify the ReportServer.

2. Open a command prompt in the financialreporting\bin directory and type: ManageUserPov.cmd Export ManageUserPov.Properties.

3. When prompted, supply the Admin User and Password.

   A ManageUserPovExport.xml file is created which contains all the current User POVs in the system. A sample console interaction:

   EPM_ORACLE_HOME\Products\financialreporting\binManageUserPov.cmd Export ManageUserPov.properties

   Please enter AdminUser : AdminUser

   Please enter AdminPassword :*********

   INFO : Starting Hyperion Financial Reporting ManageUserPOV Utility

   INFO : Ending Hyperion Financial Reporting ManageUserPOV Utility

  To update an existing User POV:

1. Follow the steps to export all existing User POVs.

2. Open the ManageUserPovExport.xml file and update the desired User POV in the file. For example, specify a Member Name=”East” for the Market Dimension, for the User LoginID=”TestUser”, for the DATASOURCE_NAME=”Essbase Sample Basic on TestServer”

3. Edit the ManageUserPov.properties file and specify these filters to perform the update for a single user and data source:

   Users = TestUser

   Datasources = Essbase Sample Basic on TestServer

   Note:

   If the Datasource credentials are different from the Admin credentials, you should specify an asterisk (*) to prompt for them separately, such as: DatasourceUser=*, DatasourcePassword=*.

4. Save the file as ManageUserPovImport.xml.

5. Open a command prompt in the financialreporting\bin directory and type: ManageUserPov.cmd Import ManageUserPov.properties.

6. When prompted, supply the Admin User and Password and optionally the Datasource User and Password.

   The User POV is updated with the new value for Market. A sample console interaction:

   C:\Hyperion\financialreporting\bin>ManageUserPov.cmd Import ManageUserPov.properties

   Please enter AdminUser : AdminUser

   Please enter AdminPassword :*********

   Please enter DataSourceUser : TestUser

   Please enter DataSourcePassword :*********

   INFO : Starting Hyperion Financial Reporting ManageUserPOV Utility

   INFO : Setting POV for user: TestUser

   INFO : Processing DataSource: Essbase Sample Basic on TestServer

   INFO : Processing Year = Year

   INFO : Processing Measures = Measures

   INFO : Processing Product = Product

   INFO : Processing Market = East

   INFO : Processing Scenario = Scenario

   INFO : Processing Caffeinated = Caffeinated

   INFO : Processing Ounces = Ounces

   INFO : Processing Pkg Type = Pkg Type

   INFO : Processing Population = Population

   INFO : Processing Intro Date = Intro Date

   INFO : Processing Attribute Calculations = Attribute Calculations

   INFO : Ending Hyperion Financial Reporting ManageUserPOV Utility

  To delete an existing User POV:

1. Edit the MangeUserPov.properties file and specify the ReportServer and desired filters. For example, to delete a single user “TestUser” POV for the data source “Essbase Sample Basic on TestServer”, specify:

   Users = TestUser

   Datasources = Essbase Sample Basic on TestServer

2. Open a command prompt in the EPM_ORACLE_HOME\Products\financialreporting\binEPM_ORACLE_HOME\Products\financialreporting\bindirectory and type: ManageUserPov.cmd Delete ManageUserPov.properties.

3. When prompted, supply the Admin User and Password.

   The User POV is deleted. A sample console interaction:

   EPM_ORACLE_HOME\Products\financialreporting\binManageUserPov.cmd Delete ManageUserPov.properties

   Please enter AdminUser : AdminUser

   Please enter AdminPassword :*********

   INFO : Starting Hyperion Financial Reporting ManageUserPOV Utility

   This action will delete 1 POV's

   Are you sure you want to proceed? Press 1 to Proceed and 0 to Cancel : 1

   INFO : Ending Hyperion Financial Reporting ManageUserPOV Utility