Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Next »

Welcome the Apliqo FPM

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

If you change the Admin password you will 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 > 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 > System > Settings > File System Location Params

image-20240212-010042.png

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

Check the Location: TM1RunTI 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 > 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.

image-20240212-011348.png

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

Backup Params

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

image-20240212-025335.png

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

Run the [Backup] process. You should get the message:

image-20240212-011631.png

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 backup the Apliqo FPM data folder.

Rule Splicing Tool

Open the file .\model\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: The same value as the UseSSL parameter for the Apliqo FPM model.

  • user: Is ADMIN 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"
    }
}

  • No labels