BI+ Report User Point of View

Note to myself on how to add a dimension to the user point-of-view (POV) in Hyperion BI+.

1. Open the report using Financial Reporting Studio (FRS).
2. Click on the POV in a grid. FRS should open the Select Members dialog.
3. In Select Members, select the tab for the dimension you require.
4. In the dimension tab, set the member to be "User Point of View for [dimension]" (go to the bottom of the list).
5. Press the OK button to close the Select Members dialog.

The required dimension should now be in the user POV at the top of the report.

HFM Extended Analytics application name and table prefix

When we ran an Extended Analytics (EA) template in a new HFM application, the job halted with this error:

ERROR 2: Error during Extended Analytics export (Attention:  The metadata that currently exists for the Prefix %0 was extracted from a different Financial Management Application.  Extracted App: %1   Current App:  %2. You must use the Create option to overwrite this extract or use a different Prefix.)

According to the HFM Administrator's Guide, running an EA template would create a set of tables with the same prefix (e.g. DEMO_FACT, DEMO_YEAR) and master table called HFM_EA_EXTRACT. If you look in HFM_EA_EXTRACT, you should find an association between the application name and the tables with the same prefix. For this problem, my fix is to change the application name in HFM_EA_EXTRACT. The "Create" button in the HFM EA page didn't do anything and I didn't want to change the template's prefix because the applications that use the data would also have to be reconfigured.

List users in a Windows local group

Note to myself: use net localgroup [groupname] to get a list of users in a Windows server's local group (e.g. Remote Desktop Users). Refer: Net localgroup.

Excel find first word without IFERROR() or IF(ISERROR())

In Excel, to find the first word in a cell, find the position of first space then return all characters up to but excluding the space: =LEFT(A1,FIND(" ",A1)-1).

The formula above fails with #VALUE if the string in A1 doesn't have a space or the cell is empty. A Excel 2007 solution is to wrap the entire formula in IFERROR to return a default value: =IFERROR(LEFT(A1,FIND(" ",A1)-1),A1). Excel 2003 doesn't have IFERROR, so the formula is much longer with the same formula for the condition and output of the IF formula: =IF(ISERROR(LEFT(A1,(FIND(" ",A1)))),A1,LEFT(A1,(FIND(" ",A1)-1))).

A shorter solution for Excel 2003 onwards is to append a space to the cell value in the FIND formula so that a default value can always be returned: =LEFT(A1,FIND(" ",A1&" ")-1). Note: Test if it works for OpenOffice Calc.