These are the minimum settings that should be reviewed when first installing Apliqo FPM. You should review all the settings and make sure they are appropriate for your environment.

In this section we will cover.

Welcome the Apliqo FPM

The first-time logging you log into Apliqo FPM you see the Get Started page.

...

If you change the ADMIN password, you will also need to update the password in the following places.

• Splicer: Update the Admin password in \[Apliqo FPM]\batch\rule-splicing-tool\config\connection.json file.

• TM1RunTI: Update the Admin password in \[Apliqo FPM]\batch\TM1RunTIConfig.ini file.

Essential Params

Check that the following settings are true for your environment.

Menu: Apliqo Settings Navigate to the tab, Administration > System > Settings > Essential Params

...

Enter full file path to where the Apliqo FPM instance is located in the Location:Instance. The other location parameters will default to the standard locations created by the installer. Un-check any location parameter that is not correct and enter the correct full path for the location parameter.

Enter the Customer Name and Customer Key provided by Apliqo.

File System

Menu: Apliqo Settings Navigate to the tab, Administration > System > Settings > File System Location Params

...

Check the Location: Debug parameter agrees with the folder path.

Check the Location: TM1RunTI and parameter. This the full file name for TM1RunTI.exe that is installed as part of Planning Analytics. The default path is: C:\Program Files\ibm\cognos\tm1_64\bin64\tm1runti.exe. Check the Location:TM1RunTI Config parameter. This can be found at \[Apliqo FPM]\batch\TM1RunTIConfig.ini. Check that the password in the TM1RunTIConfig.ini agrees with the ADMIN password used be ApliqoFPM.

Note to update the config.ini.

Database Params

For this training material we are using the Apliqo demo.sqlite database.

Menu: Apliqo Settings Navigate to the tab, Administration > System > Settings > Database Connection Params

...

Check the ODBC Connection agrees with the SQL-Lite database OBDC. The ODBC Datasource parameter is set to “ApliqoFPM_ODS”. This must agree with the ODBC Data Source Connection that was created by the installer.

...

The ODBC Datasource User parameter and ODBC Datasource Pwd parameter are left blank for the demo.sqlite database.

...

Backup Params

Navigate to the tab, Administration > System > Settings > Backup Params

...

. Check the TM1 Server Name parameter has the value “ApliqoFPM”.Run ApliqoFPM.

...

There is 7zip.exe installed with Apliqo FPM located at, .\[Apliqo FPM]\batch\7z\7za.exe.

To confirm the backup settings are correct, run the [Backup] process. You should get the message:

...

Check the backup files have been created. The are three backup files that are created:

• Daily: One file for each day in the month. These files are retained for 30 days.

• Weekly: One file for the 7th, 14th, 21st and 28th of the month.

...

• These files are retained for 70 days.

• Monthly: One file taken at the last day of the month. These files are retained for 182 days.

...

The chore: APQ.Server.Backup is scheduled daily at 08:45 to back-up the Apliqo FPM data folder.

Rule Splicing Tool

Open the file, .\modelApliqoFPM\batch\rule-splicing-tool\config\connection.json. Check the values are correct for your environment.

• address: Machine Name or IP address where the Apliqo FPM model is being hosted. You can use localhost if the splicer and Apliqo FPM are on the same machine.

• port: The HTTPPortNumber parameter for the Apliqo FPM model.

• ssl: true or false. The same value as the UseSSL parameter for the Apliqo FPM model.

• user: Is ADMIN account or an account that has admin privileges.

• password: The password for the user nominated in user parameter of the connection.json file.

{
    "data_instance": {
        "address": "localhost",
        "port": "30031",
        "ssl": true,
        "user": "admin",
        "password": "Apliqo2023"
    }
}

Run TI Configuration

Open the file, .\ApliqoFPM\batch\TM1RunTIConfig. Check the values are correct for your environment.

• adminhost: Specifies the computer name or IP address of the Admin Host on which an Admin Server is running.

• server: The name of the Apliqo FPM Planning Analytics database. Generally, this will be ApliqoFPM.

• user: The account to run the TI process under. Must have permission to run the processes.

• pwd: The password of the account.

[TM1RunTI]
adminhost=localhost
server="ApliqoFPM"
user="admin"
pwd=""