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.

Netbeans Portable JDKHOME

You may get this dialog message when starting Netbeans Portable: Cannot find java.exe in specified jdkhome.. For me, the dialog appears because I have a JDK installed instead of inside the Netbeans Portable folder. To avoid responding to this message every time I start Netbeans, I made two changes to my configuration files:

?

1. Close Netbeans first. If you don't close Netbeans, it will overwrite your changes to the configuration files.
2. Edit ...\NetBeans_JavaSE_7.4_Portable\App\netbeans\etc\netbeans.conf and set netbeans_jdkhome to the path of your JDK installation.
3. Edit ...\NetBeans_JavaSE_7.4_Portable\App\AppInfo\Launcher\NetBeansPortable.ini and comment out the section that overwrites netbeans_jdkhome. You comment out lines in an INI file by inserting a semicolon in the first column of a row.