Using the User POV Utility

The following instances describe how the User POV Utility is used.

Exporting User POVs

  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:

    FR_Studio_Installation_Directory\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

Importing User POVs

  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=Planning datasource

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

    Users = TestUser

    Datasources = Planning datasource

  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:\Oracle\Middleware\EPMSystem11R1\products\FinancialReportingStudio\products\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: Planning datasource

    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

Deleting User POVs

  To delete an existing User POV:

  1. Edit the MangeUserPov.properties file and specify the ReportServer and desired filters.

  2. Open a command prompt in the FR_Studio_Installation_Directory\Products\financialreporting\bin directory and enter: ManageUserPov.cmd Delete ManageUserPov.properties.

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

    The User POV is deleted. A sample console interaction:

    FR_Studio_Installation_Directory\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