Managing User POVs in Hyperion Financial Reporting


Purpose


This tutorial covers exporting, modifying, importing, and deleting user Point of Views (POVs) for multiple users and data sources in Hyperion Financial Reporting.

Time to Complete


Approximately 30 minutes

Topics


This tutorial covers the following topics:

 Overview
 Scenario
 Prerequisites
 Exporting User POVs from Financial Reporting
 Modifying and Importing User POVs
 Deleting User POVs in Financial Reporting
 Summary
 Related Information

Viewing Screenshots


Click icon to show all screenshots Click icon to show all screenshots

Note: Alternatively, you can click an individual icon (or image) associated with each step to view (or hide) the screenshot associated with that step.

Overview


In Hyperion Financial Reporting, users have a user POV for each data source that they can access.

To change user POVs for multiple users and data sources, you modify and import an XML file that contains the POVs for users and data sources. The easiest way to create the layout of the XML file is to export the user POVs from Financial Reporting. You then modify the XML file and import the user POVs into Financial Reporting.

Administrators can also delete POVs for multiple users and data sources if the user POVs are corrupt. User POVs can be corrupt due to changes to data source outlines, such such as adding, removing, or renaming dimensions.

Back to Topic List

Scenario


As an administrator, you are tasked with modifying user POVs for multiple users and data sources and importing them into Financial Reporting.

If user POVs are corrupt, you must delete the user POVs from Financial Reporting so that the POVs will revert to the top-level members of each dimension.

Back to Topic List

Prerequisites


Before starting this tutorial, you should:

1.Have access to a data source such as a Financial Management application or an Essbase database.
2.Have access to Hyperion Financial Reporting release 9.3.1 or higher.
3.Have access in Hyperion Workspace to a Financial Reporting report for the data source.
4.Have the administrator account and password.

Back to Topic List

Exporting User POVs from Financial Reporting


To export user POVs to an XML file, perform these steps:

1.

Edit the <BIPlus>\bin\ManageUserPOV.properties file, where <BIPlus> is the location of the BI install directory.

a.

Enter the report server name, administrator user name, administrator password, and, if needed, the data source user name and password.

In this example, you use the * to prompt for the administrator user name and password.

 

b.

Enter the export XML file name, and the list of users and data sources for which you want to export the user POVs. Leave the list of users and data sources blank to export all user POVs for all data sources.

 

2.

From the Windows desktop, select Start > Run. In the Open box, type cmd and click OK .

 

3.

In the Command Prompt window, enter the CD command to change the directory to the <BIPlus>\bin directory.

 

4.

Type ManageUserPOV.cmd Export ManageUserPOV.properties .

 

5.

Enter the administrator user name and password.

The POVs for the selected user names and data sources are exported to the XML file, ManageUserPOVExport.xml, that you specified in the properties file, ManageUserPOV.properties.

This is a portion of an exported XML file:

For the rjackson user, the Product dimension is set to 200 and the Market dimension is set to East.

Back to Topic List

Modifying and Importing User POVs


To modify and import user POVs to Financial Reporting, perform these steps:

1.

Edit the <BIPlus>\bin\ManageUserPOVExport.xml file, modify the user POVs, and save the file with a different name, such as ManageUserPOVImport.xml .

In this example, we change the Product member to 100, and the Market member to West for the rjackson user.

 

2.

Edit the <BIPlus>\bin\ManageUserPOV.properties file.

a.

Enter the report server name, administrator user name, administrator password, and, if needed, the data source user name and password.

 

b.

Enter the import XML file name, and the list of users and data sources for which you want to import the user POVs.

In this example, we import the user POVs from the ManageUserPOVImport.xml file, for the rjackson and lturner users, and the Sample:Basic data source.

 

3.

From the Windows desktop, select Start > Run . In the Open box, type cmd and click OK .

 

4.

In the Command Prompt window, enter the CD command to change the directory to the <BIPlus>\bin directory.

 

5.

Type ManageUserPOV.cmd Import ManageUserPOV.properties .

 

6.

Enter the administrator user name and password.

The user POVs for the selected users and data sources are imported to Financial Reporting.

 

7.

Launch Hyperion Workspace and log in as one of the users whose user POV you modified. Run a report for the selected data source and verify the user POV.

The user POV for rjackson is the 100 product member for the West market.

Back to Topic List

Deleting User POVs in Financial Reporting


To delete user POVs in Financial Reporting, perform these steps:

1.

Edit the <BIPlus>\bin\ManageUserPOV.properties file, where <BIPlus> is the location of the BI install directory.

a.

Enter the report server name, administrator user name, administrator password, and, if needed, the data source user name and password.

In this example, you use the * to prompt for the administrator user name and password.

 

b.

Enter the list of users and data sources for which you want to delete the user POV. For the ConfirmDeletion option, accept the default of true to require a confirmation before Financial Reporting deletes the user POVs.

In this example, the user POVs for the Sample:Basic data source for the rjackson, LTurner, and ljensen users will be deleted.

 

2.

From the Windows desktop, select Start > Run. In the Open box, type cmd and click OK.

 

3.

In the Command Prompt window, enter the CD command to change the directory to the <BIPlus>\bin directory.

 

4.

Type ManageUserPOV.cmd Delete ManageUserPOV.properties.

 

5.

Enter the administrator user name and password.

 

6.

At the "Are you sure you want to proceed?" prompt, type 1 to proceed.

The user POVs for the Sample:Basic database for the rjackson, LTurner, and ljensen users are deleted from Financial Reporting. The user POVs are reset to the top-level member of each dimension.

 

7.

Launch Hyperion Workspace and log in as one of the users whose user POV you deleted. Run a report for the selected data source and verify that the user POV is set to the top-level member of each dimension.

In this example, the user POV for rjackson is set to the top-level member of the Product and Market dimensions.

 

Back to Topic List

Summary


In this tutorial, you've learned how to:

 Export user POVs from Financial Reporting
 Modify and import user POVs
 Delete user POVs in Financial Reporting

Back to Topic List

Related Information


To learn more about Financial Reporting, refer to additional OBEs..

Back to Topic List

Left Curve
Popular Downloads
Right Curve
Untitled Document
Left Curve
More Middleware Downloads
Right Curve